DBA Data[Home] [Help]

APPS.PAP_CMERGE dependencies on HZ_CUSTOMER_MERGE_LOG_S

Line 407: HZ_CUSTOMER_MERGE_LOG_s.nextval,

403: DEL_COL23,
404: DEL_COL24 -- FP_M Changes
405: )
406: ( SELECT
407: HZ_CUSTOMER_MERGE_LOG_s.nextval,
408: 'PA_PROJECT_CUSTOMERS',
409: RACM.CUSTOMER_MERGE_HEADER_ID,
410: var_project_id,
411: new_customer_id,

Line 482: HZ_CUSTOMER_MERGE_LOG_s.nextval,

478: LAST_UPDATE_DATE,
479: LAST_UPDATED_BY
480: )
481: ( SELECT
482: HZ_CUSTOMER_MERGE_LOG_s.nextval,
483: 'PA_PROJECT_CUSTOMERS',
484: RACM.CUSTOMER_MERGE_HEADER_ID,
485: PC.project_id,
486: PC.customer_id,

Line 554: HZ_CUSTOMER_MERGE_LOG_s.nextval,

550: LAST_UPDATE_LOGIN,
551: LAST_UPDATE_DATE,
552: LAST_UPDATED_BY)
553: ( SELECT
554: HZ_CUSTOMER_MERGE_LOG_s.nextval,
555: 'PA_PROJECT_CUSTOMERS',
556: RACM.CUSTOMER_MERGE_HEADER_ID,
557: PC.project_id,
558: PC.customer_id,

Line 621: HZ_CUSTOMER_MERGE_LOG_s.nextval,

617: LAST_UPDATE_LOGIN,
618: LAST_UPDATE_DATE,
619: LAST_UPDATED_BY)
620: ( SELECT
621: HZ_CUSTOMER_MERGE_LOG_s.nextval,
622: 'PA_PROJECT_CUSTOMERS',
623: RACM.CUSTOMER_MERGE_HEADER_ID,
624: PC.project_id,
625: PC.customer_id,

Line 687: HZ_CUSTOMER_MERGE_LOG_s.nextval,

683: LAST_UPDATE_LOGIN,
684: LAST_UPDATE_DATE,
685: LAST_UPDATED_BY)
686: ( SELECT
687: HZ_CUSTOMER_MERGE_LOG_s.nextval,
688: 'PA_PROJECT_CUSTOMERS',
689: RACM.CUSTOMER_MERGE_HEADER_ID,
690: PC.project_id,
691: PC.customer_id,

Line 746: HZ_CUSTOMER_MERGE_LOG_s.nextval,

742: LAST_UPDATE_LOGIN,
743: LAST_UPDATE_DATE,
744: LAST_UPDATED_BY)
745: ( SELECT
746: HZ_CUSTOMER_MERGE_LOG_s.nextval,
747: 'PA_PROJECT_CUSTOMERS',
748: RACM.CUSTOMER_MERGE_HEADER_ID,
749: PC.project_id,
750: PC.customer_id,

Line 809: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

805: CREATION_DATE,
806: LAST_UPDATE_LOGIN,
807: LAST_UPDATE_DATE,
808: LAST_UPDATED_BY)
809: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
810: 'PA_PROJECT_CUSTOMERS',
811: RACM.CUSTOMER_MERGE_HEADER_ID,
812: PC.project_id,
813: RACM.CUSTOMER_ID,

Line 891: HZ_CUSTOMER_MERGE_LOG_S.nextval,

887: LAST_UPDATE_DATE,
888: LAST_UPDATED_BY
889: )
890: (SELECT
891: HZ_CUSTOMER_MERGE_LOG_S.nextval,
892: 'PA_DRAFT_INVOICES_ALL',
893: RACM.CUSTOMER_MERGE_HEADER_ID,
894: PDI.PROJECT_ID,
895: PDI.DRAFT_INVOICE_NUM,

Line 951: HZ_CUSTOMER_MERGE_LOG_S.nextval,

947: LAST_UPDATE_DATE,
948: LAST_UPDATED_BY
949: )
950: (SELECT
951: HZ_CUSTOMER_MERGE_LOG_S.nextval,
952: 'PA_DRAFT_INVOICES_ALL',
953: RACM.CUSTOMER_MERGE_HEADER_ID,
954: PDI.PROJECT_ID,
955: PDI.DRAFT_INVOICE_NUM,

Line 1011: HZ_CUSTOMER_MERGE_LOG_S.nextval,

1007: LAST_UPDATE_DATE,
1008: LAST_UPDATED_BY
1009: )
1010: (SELECT
1011: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1012: 'PA_DRAFT_INVOICES_ALL',
1013: RACM.CUSTOMER_MERGE_HEADER_ID,
1014: PDI.PROJECT_ID,
1015: PDI.DRAFT_INVOICE_NUM,

Line 1072: HZ_CUSTOMER_MERGE_LOG_S.nextval,

1068: LAST_UPDATE_DATE,
1069: LAST_UPDATED_BY
1070: )
1071: (SELECT
1072: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1073: 'PA_DRAFT_INVOICES_ALL',
1074: RACM.CUSTOMER_MERGE_HEADER_ID,
1075: PDI.PROJECT_ID,
1076: PDI.DRAFT_INVOICE_NUM,

Line 1133: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1129: LAST_UPDATE_DATE,
1130: LAST_UPDATED_BY
1131: )
1132: (SELECT
1133: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1134: 'PA_DRAFT_INVOICES_ALL',
1135: RACM.CUSTOMER_MERGE_HEADER_ID,
1136: PDI.PROJECT_ID,
1137: PDI.DRAFT_INVOICE_NUM,

Line 1198: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1194: CREATION_DATE,
1195: LAST_UPDATE_LOGIN,
1196: LAST_UPDATE_DATE,
1197: LAST_UPDATED_BY)
1198: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1199: 'PA_DRAFT_INVOICE_ITEMS',
1200: RACM.CUSTOMER_MERGE_HEADER_ID,
1201: PDII.project_id,
1202: PDII.draft_invoice_num,

Line 1271: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1267: CREATION_DATE,
1268: LAST_UPDATE_LOGIN,
1269: LAST_UPDATE_DATE,
1270: LAST_UPDATED_BY)
1271: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1272: 'PA_TASKS',
1273: RACM.CUSTOMER_MERGE_HEADER_ID,
1274: PT.TASK_ID,
1275: PT. address_id,

Line 1340: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1336: CREATION_DATE,
1337: LAST_UPDATE_LOGIN,
1338: LAST_UPDATE_DATE,
1339: LAST_UPDATED_BY)
1340: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1341: 'PA_IMPLEMENTATIONS_ALL',
1342: RACM.CUSTOMER_MERGE_HEADER_ID,
1343: PI.ORG_ID,
1344: PI.CUSTOMER_ID,

Line 1411: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1407: CREATION_DATE,
1408: LAST_UPDATE_LOGIN,
1409: LAST_UPDATE_DATE,
1410: LAST_UPDATED_BY)
1411: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1412: 'PA_PROJ_RETN_RULES',
1413: RACM.CUSTOMER_MERGE_HEADER_ID,
1414: PR.RETENTION_RULE_ID,
1415: PR.CUSTOMER_ID,

Line 1489: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1485: CREATION_DATE,
1486: LAST_UPDATE_LOGIN,
1487: LAST_UPDATE_DATE,
1488: LAST_UPDATED_BY)
1489: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1490: 'PA_PROJ_RETN_BILL_RULES',
1491: RACM.CUSTOMER_MERGE_HEADER_ID,
1492: PB. RETN_BILLING_RULE_ID,
1493: PB.CUSTOMER_ID,

Line 1569: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1565: CREATION_DATE,
1566: LAST_UPDATE_LOGIN,
1567: LAST_UPDATE_DATE,
1568: LAST_UPDATED_BY)
1569: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1570: 'PA_SUMMARY_PROJECT_RETN',
1571: RACM.CUSTOMER_MERGE_HEADER_ID,
1572: PS.PROJECT_ID,
1573: PS.TASK_ID,