This appendix covers the following topics:
In normal situations, you do not need to change this insert statement. It is only necessary to change it if you are performing customizations.
Go to section or comment, which says == > " OIC CODE TO INSERT DATA INTO JTF_TAE_1001_SC_TRANS GOES HERE"
Enter the following SQL script.
Insert into JTF_TAE_1001_SC_TRANS (
source_id,
trans_object_type_id,
trans_object_id,
trans_detail_object_id, --PARTY SITE ID (TCA)
squal_num02, --ACCOUNT CODE (TCA)
squal_num04, --ACCOUNT HIERARCHY (TCA)
squal_char08, --AREA CODE
squal_char09, --CATEGORY CODE (TCA)
squal_char02, --CITY (AR)
squal_curc01, --CURRENCY CODE
squal_num06, --COMPANY ANNUAL REVENUE
squal_char07, --COUNTRY (AR)
squal_char03, --COUNTY (AR)
squal_num01, --PARTY_ID (TCA)
squal_fc01, --FIRST CHARACTER OF CUSTOMER NAME RANGE
squal_char01, --CUSTOMER NAME RANGE
squal_num10, --DUNS NUMBER (TCA)
squal_num05, --NUMBER OF EMPLOYEES
squal_char06, --POSTAL CODE
squal_char05, --PROVINCE (AR)
squal_num01, --REGISTRY ID (TCA)
squal_num03, --SALES PARTNER OF (TCA)
squal_char10, --SIC CODE (TCA)
squal_char04, --STATE (AR)
worker_id
)
SELECT -1001,
-1002,
comm_lines_api_id,
ATTRIBUTE1, --PARTY SITE ID (TCA)
ATTRIBUTE3, --ACCOUNT CODE (TCA)
ATTRIBUTE4, --ACCOUNT HIERARCHY (TCA)
ATTRIBUTE5, --AREA CODE
ATTRIBUTE6, --CATEGORY CODE (TCA)
ATTRIBUTE7, --CITY (AR)
ATTRIBUTE8, --CURRENCY CODE
ATTRIBUTE9, --COMPANY ANNUAL REVENUE
ATTRIBUTE10, --COUNTRY (AR)
ATTRIBUTE11, --COUNTY (AR)
ATTRIBUTE12, --PARTY_ID (TCA)
ATTRIBUTE13, --FIRST CHARACTER OF CUSTOMER NAME RANGE
ATTRIBUTE14, --CUSTOMER NAME RANGE
ATTRIBUTE15, --DUNS NUMBER (TCA)
ATTRIBUTE16, --NUMBER OF EMPLOYEES
ATTRIBUTE17, --POSTAL CODE
ATTRIBUTE18, --PROVINCE (AR)
ATTRIBUTE19, --REGISTRY ID (TCA)
ATTRIBUTE20, --SALES PARTNER OF (TCA)
ATTRIBUTE21, --SIC CODE (TCA)
ATTRIBUTE22, --STATE (AR)
1
FROM cn_comm_lines_api
WHERE process_batch_id in
(select process_audit_id from cn_process_audits where parent_
process_audit_id = x_conc_program_id);.