APPS.OKS_IMPORT_INSERT dependencies on OKC_K_PARTY_ROLES_B

Line 730: INTO OKC_K_PARTY_ROLES_B

726: l_stmt_num := 10;
727:
728: INSERT ALL
729: WHEN (OPERATING_UNIT_ID is not null ) THEN
730: INTO OKC_K_PARTY_ROLES_B
731: (ID
732: ,CHR_ID
733: ,CLE_ID
734: ,DNZ_CHR_ID

Line 759: INTO OKC_K_PARTY_ROLES_B

755: ,LAST_UPDATED_BY
756: ,LAST_UPDATE_DATE)
757:
758: WHEN (CUSTOMER_PARTY_ID IS NOT NULL ) THEN
759: INTO OKC_K_PARTY_ROLES_B
760: (ID
761: ,CHR_ID
762: ,CLE_ID
763: ,DNZ_CHR_ID

Line 787: INTO OKC_K_PARTY_ROLES_B

783: ,CREATION_DATE
784: ,LAST_UPDATED_BY
785: ,LAST_UPDATE_DATE)
786: WHEN (THIRD_PARTY_ID IS NOT NULL ) THEN
787: INTO OKC_K_PARTY_ROLES_B
788: (ID
789: ,CHR_ID
790: ,CLE_ID
791: ,DNZ_CHR_ID

Line 853: INTO OKC_K_PARTY_ROLES_B

849: l_stmt_num := 40;
850:
851: INSERT ALL
852: WHEN (1=1) THEN
853: INTO OKC_K_PARTY_ROLES_B
854: (ID
855: ,CHR_ID
856: ,CLE_ID
857: ,DNZ_CHR_ID

Line 959: FROM OKC_K_PARTY_ROLES_B OKCPTY

955: ,SYSDATE LAST_UPDATE_DATE
956: ,null COGNOMEN
957: ,FND_GLOBAL.LOGIN_ID LAST_UPDATE_LOGIN
958:
959: FROM OKC_K_PARTY_ROLES_B OKCPTY
960: ,OKC_K_HEADERS_ALL_B OKCHDRB
961: ,OKS_INT_HEADER_STG_TEMP HDRSTG
962:
963: WHERE HDRSTG.INTERFACE_STATUS ='S'

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

1041: ,CREATION_DATE
1042: ,LAST_UPDATED_BY
1043: ,LAST_UPDATE_DATE)
1044: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID
1045: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.
1046: ,HDRSTG.CUSTOMER_CONTRACT_ADMIN_ID CUSTOMER_CONTRACT_ADMIN_ID
1047: ,OKCHDRB.ID DNZ_CHR_ID
1048: ,1 OBJECT_VERSION_NUMBER
1049: ,FND_GLOBAL.USER_ID CREATED_BY

Line 1054: ,OKC_K_PARTY_ROLES_B OKCKPTYRL

1050: ,SYSDATE CREATION_DATE
1051: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1052: ,SYSDATE LAST_UPDATE_DATE
1053: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1054: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1055: ,OKC_K_HEADERS_ALL_B OKCHDRB
1056: WHERE HDRSTG.INTERFACE_STATUS='S'
1057: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1058: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

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

1099: ,LAST_UPDATED_BY
1100: ,LAST_UPDATE_DATE)
1101:
1102: SELECT okc_p_util.raw_to_number(sys_guid()) OKCCONTACTS_ID
1103: ,OKCKPTYRL.ID CPL_ID -- ID of okc_k_party_roles_b table.
1104: ,HDRSTG.SALESPERSON_ID SALESPERSON_ID
1105: ,OKCHDRB.ID DNZ_CHR_ID
1106: ,1 OBJECT_VERSION_NUMBER
1107: ,HDRSTG.SALESGROUP_ID SALESGROUP_ID

Line 1113: ,OKC_K_PARTY_ROLES_B OKCKPTYRL

1109: ,SYSDATE CREATION_DATE
1110: ,FND_GLOBAL.USER_ID LAST_UPDATED_BY
1111: ,SYSDATE LAST_UPDATE_DATE
1112: FROM OKS_INT_HEADER_STG_TEMP HDRSTG
1113: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1114: ,OKC_K_HEADERS_ALL_B OKCHDRB
1115: WHERE HDRSTG.INTERFACE_STATUS='S'
1116: AND HDRSTG.CONTRACT_NUMBER = OKCHDRB.CONTRACT_NUMBER
1117: AND NVL(HDRSTG.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1') = NVL(OKCHDRB.CONTRACT_NUMBER_MODIFIER , 'Xwqwewe@!&*aQ1')

Line 1211: ,OKC_K_PARTY_ROLES_B OKCKPTYRL

1207:
1208: FROM OKS_INT_LINE_STG_TEMP LINSTG
1209: ,OKS_INT_HEADER_STG_TEMP HDRSTG
1210: ,OKC_K_HEADERS_ALL_B OKCHDRB
1211: ,OKC_K_PARTY_ROLES_B OKCKPTYRL
1212: ,OKC_K_LINES_B OKCLINB
1213:
1214: WHERE HDRSTG.INTERFACE_STATUS='S'
1215: AND LINSTG.HEADER_INTERFACE_ID = HDRSTG.HEADER_INTERFACE_ID