DBA Data[Home] [Help]

APPS.PAP_CMERGE dependencies on HZ_CUSTOMER_MERGE_LOG_S

Line 439: HZ_CUSTOMER_MERGE_LOG_s.nextval,

435: DEL_COL23,
436: DEL_COL24 -- FP_M Changes
437: )
438: ( SELECT
439: HZ_CUSTOMER_MERGE_LOG_s.nextval,
440: 'PA_PROJECT_CUSTOMERS',
441: RACM.CUSTOMER_MERGE_HEADER_ID,
442: var_project_id,
443: new_customer_id,

Line 514: HZ_CUSTOMER_MERGE_LOG_s.nextval,

510: LAST_UPDATE_DATE,
511: LAST_UPDATED_BY
512: )
513: ( SELECT
514: HZ_CUSTOMER_MERGE_LOG_s.nextval,
515: 'PA_PROJECT_CUSTOMERS',
516: RACM.CUSTOMER_MERGE_HEADER_ID,
517: PC.project_id,
518: PC.customer_id,

Line 586: HZ_CUSTOMER_MERGE_LOG_s.nextval,

582: LAST_UPDATE_LOGIN,
583: LAST_UPDATE_DATE,
584: LAST_UPDATED_BY)
585: ( SELECT
586: HZ_CUSTOMER_MERGE_LOG_s.nextval,
587: 'PA_PROJECT_CUSTOMERS',
588: RACM.CUSTOMER_MERGE_HEADER_ID,
589: PC.project_id,
590: PC.customer_id,

Line 653: HZ_CUSTOMER_MERGE_LOG_s.nextval,

649: LAST_UPDATE_LOGIN,
650: LAST_UPDATE_DATE,
651: LAST_UPDATED_BY)
652: ( SELECT
653: HZ_CUSTOMER_MERGE_LOG_s.nextval,
654: 'PA_PROJECT_CUSTOMERS',
655: RACM.CUSTOMER_MERGE_HEADER_ID,
656: PC.project_id,
657: PC.customer_id,

Line 719: HZ_CUSTOMER_MERGE_LOG_s.nextval,

715: LAST_UPDATE_LOGIN,
716: LAST_UPDATE_DATE,
717: LAST_UPDATED_BY)
718: ( SELECT
719: HZ_CUSTOMER_MERGE_LOG_s.nextval,
720: 'PA_PROJECT_CUSTOMERS',
721: RACM.CUSTOMER_MERGE_HEADER_ID,
722: PC.project_id,
723: PC.customer_id,

Line 778: HZ_CUSTOMER_MERGE_LOG_s.nextval,

774: LAST_UPDATE_LOGIN,
775: LAST_UPDATE_DATE,
776: LAST_UPDATED_BY)
777: ( SELECT
778: HZ_CUSTOMER_MERGE_LOG_s.nextval,
779: 'PA_PROJECT_CUSTOMERS',
780: RACM.CUSTOMER_MERGE_HEADER_ID,
781: PC.project_id,
782: PC.customer_id,

Line 841: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

837: CREATION_DATE,
838: LAST_UPDATE_LOGIN,
839: LAST_UPDATE_DATE,
840: LAST_UPDATED_BY)
841: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
842: 'PA_PROJECT_CUSTOMERS',
843: RACM.CUSTOMER_MERGE_HEADER_ID,
844: PC.project_id,
845: RACM.CUSTOMER_ID,

Line 923: HZ_CUSTOMER_MERGE_LOG_S.nextval,

919: LAST_UPDATE_DATE,
920: LAST_UPDATED_BY
921: )
922: (SELECT
923: HZ_CUSTOMER_MERGE_LOG_S.nextval,
924: 'PA_DRAFT_INVOICES_ALL',
925: RACM.CUSTOMER_MERGE_HEADER_ID,
926: PDI.PROJECT_ID,
927: PDI.DRAFT_INVOICE_NUM,

Line 983: HZ_CUSTOMER_MERGE_LOG_S.nextval,

979: LAST_UPDATE_DATE,
980: LAST_UPDATED_BY
981: )
982: (SELECT
983: HZ_CUSTOMER_MERGE_LOG_S.nextval,
984: 'PA_DRAFT_INVOICES_ALL',
985: RACM.CUSTOMER_MERGE_HEADER_ID,
986: PDI.PROJECT_ID,
987: PDI.DRAFT_INVOICE_NUM,

Line 1043: HZ_CUSTOMER_MERGE_LOG_S.nextval,

1039: LAST_UPDATE_DATE,
1040: LAST_UPDATED_BY
1041: )
1042: (SELECT
1043: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1044: 'PA_DRAFT_INVOICES_ALL',
1045: RACM.CUSTOMER_MERGE_HEADER_ID,
1046: PDI.PROJECT_ID,
1047: PDI.DRAFT_INVOICE_NUM,

Line 1104: HZ_CUSTOMER_MERGE_LOG_S.nextval,

1100: LAST_UPDATE_DATE,
1101: LAST_UPDATED_BY
1102: )
1103: (SELECT
1104: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1105: 'PA_DRAFT_INVOICES_ALL',
1106: RACM.CUSTOMER_MERGE_HEADER_ID,
1107: PDI.PROJECT_ID,
1108: PDI.DRAFT_INVOICE_NUM,

Line 1168: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1164: LAST_UPDATE_DATE,
1165: LAST_UPDATED_BY
1166: )
1167: (SELECT
1168: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1169: 'PA_DRAFT_INVOICES_ALL',
1170: RACM.CUSTOMER_MERGE_HEADER_ID,
1171: PDI.PROJECT_ID,
1172: PDI.DRAFT_INVOICE_NUM,

Line 1236: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1232: CREATION_DATE,
1233: LAST_UPDATE_LOGIN,
1234: LAST_UPDATE_DATE,
1235: LAST_UPDATED_BY)
1236: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1237: 'PA_DRAFT_INVOICE_ITEMS',
1238: RACM.CUSTOMER_MERGE_HEADER_ID,
1239: PDII.project_id,
1240: PDII.draft_invoice_num,

Line 1309: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1305: CREATION_DATE,
1306: LAST_UPDATE_LOGIN,
1307: LAST_UPDATE_DATE,
1308: LAST_UPDATED_BY)
1309: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1310: 'PA_TASKS',
1311: RACM.CUSTOMER_MERGE_HEADER_ID,
1312: PT.TASK_ID,
1313: PT. address_id,

Line 1378: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1374: CREATION_DATE,
1375: LAST_UPDATE_LOGIN,
1376: LAST_UPDATE_DATE,
1377: LAST_UPDATED_BY)
1378: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1379: 'PA_IMPLEMENTATIONS_ALL',
1380: RACM.CUSTOMER_MERGE_HEADER_ID,
1381: PI.ORG_ID,
1382: PI.CUSTOMER_ID,

Line 1449: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1445: CREATION_DATE,
1446: LAST_UPDATE_LOGIN,
1447: LAST_UPDATE_DATE,
1448: LAST_UPDATED_BY)
1449: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1450: 'PA_PROJ_RETN_RULES',
1451: RACM.CUSTOMER_MERGE_HEADER_ID,
1452: PR.RETENTION_RULE_ID,
1453: PR.CUSTOMER_ID,

Line 1527: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1523: CREATION_DATE,
1524: LAST_UPDATE_LOGIN,
1525: LAST_UPDATE_DATE,
1526: LAST_UPDATED_BY)
1527: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1528: 'PA_PROJ_RETN_BILL_RULES',
1529: RACM.CUSTOMER_MERGE_HEADER_ID,
1530: PB. RETN_BILLING_RULE_ID,
1531: PB.CUSTOMER_ID,

Line 1607: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,

1603: CREATION_DATE,
1604: LAST_UPDATE_LOGIN,
1605: LAST_UPDATE_DATE,
1606: LAST_UPDATED_BY)
1607: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1608: 'PA_SUMMARY_PROJECT_RETN',
1609: RACM.CUSTOMER_MERGE_HEADER_ID,
1610: PS.PROJECT_ID,
1611: PS.TASK_ID,