APPS.OKS_IMPORT_INSERT dependencies on OKC_K_PARTY_ROLES_B

Line 735: INTO OKC_K_PARTY_ROLES_B

731: l_stmt_num := 10;
732:
733: INSERT ALL
734: WHEN (OPERATING_UNIT_ID is not null ) THEN
735: INTO OKC_K_PARTY_ROLES_B
736: (ID
737: ,CHR_ID
738: ,CLE_ID
739: ,DNZ_CHR_ID

Line 764: INTO OKC_K_PARTY_ROLES_B

760: ,LAST_UPDATED_BY
761: ,LAST_UPDATE_DATE)
762:
763: WHEN (CUSTOMER_PARTY_ID IS NOT NULL ) THEN
764: INTO OKC_K_PARTY_ROLES_B
765: (ID
766: ,CHR_ID
767: ,CLE_ID
768: ,DNZ_CHR_ID

Line 792: INTO OKC_K_PARTY_ROLES_B

788: ,CREATION_DATE
789: ,LAST_UPDATED_BY
790: ,LAST_UPDATE_DATE)
791: WHEN (THIRD_PARTY_ID IS NOT NULL ) THEN
792: INTO OKC_K_PARTY_ROLES_B
793: (ID
794: ,CHR_ID
795: ,CLE_ID
796: ,DNZ_CHR_ID

Line 858: INTO OKC_K_PARTY_ROLES_B

854: l_stmt_num := 40;
855:
856: INSERT ALL
857: WHEN (1=1) THEN
858: INTO OKC_K_PARTY_ROLES_B
859: (ID
860: ,CHR_ID
861: ,CLE_ID
862: ,DNZ_CHR_ID

Line 964: FROM OKC_K_PARTY_ROLES_B OKCPTY

960: ,SYSDATE LAST_UPDATE_DATE
961: ,null COGNOMEN
962: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
963:
964: FROM OKC_K_PARTY_ROLES_B OKCPTY
965: ,OKC_K_HEADERS_ALL_B OKCHDRB
966: ,OKS_INT_HEADER_STG_TEMP HDRSTG
967:
968: WHERE HDRSTG.INTERFACE_STATUS ='S'

Line 1050: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.

1046: ,CREATION_DATE
1047: ,LAST_UPDATED_BY
1048: ,LAST_UPDATE_DATE)
1049: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID
1050: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.
1051: ,HDRSTG.CUSTOMER_CONTRACT_ADMIN_ID CUSTOMER_CONTRACT_ADMIN_ID
1052: ,OKCHDRB.ID DNZ_CHR_ID
1053: ,1 OBJECT_VERSION_NUMBER
1054: ,FND_GLOBAL.USER_ID CREATED_BY

Line 1059: ,OKC_K_PARTY_ROLES_B OKCKPTYRL

1055: ,SYSDATE CREATION_DATE
1056: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1057: ,SYSDATE LAST_UPDATE_DATE
1058: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1059: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1060: ,OKC_K_HEADERS_ALL_B OKCHDRB
1061: WHERE HDRSTG.INTERFACE_STATUS='S'
1062: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1063: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1108: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.

1104: ,LAST_UPDATED_BY
1105: ,LAST_UPDATE_DATE)
1106:
1107: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID
1108: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.
1109: ,HDRSTG.SALESPERSON_ID SALESPERSON_ID
1110: ,OKCHDRB.ID DNZ_CHR_ID
1111: ,1 OBJECT_VERSION_NUMBER
1112: ,HDRSTG.SALESGROUP_ID SALESGROUP_ID

Line 1118: ,OKC_K_PARTY_ROLES_B OKCKPTYRL

1114: ,SYSDATE CREATION_DATE
1115: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1116: ,SYSDATE LAST_UPDATE_DATE
1117: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1118: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1119: ,OKC_K_HEADERS_ALL_B OKCHDRB
1120: WHERE HDRSTG.INTERFACE_STATUS='S'
1121: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1122: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1216: ,OKC_K_PARTY_ROLES_B OKCKPTYRL

1212:
1213: FROM OKS_INT_LINE_STG_TEMP LINSTG
1214: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1215: ,OKC_K_HEADERS_ALL_B OKCHDRB
1216: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1217: ,OKC_K_LINES_B OKCLINB
1218:
1219: WHERE HDRSTG.INTERFACE_STATUS='S'
1220: AND LINSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID