eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAP_CMERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 400: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

396: IF NOT not_found_flag THEN
397: /*Added for Tca audit */
398: IF g_audit_profile='Y' THEN
399:
400: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
401: MERGE_LOG_ID,
402: TABLE_NAME,
403: MERGE_HEADER_ID,
404: PRIMARY_KEY1,

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 497: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

493: --
494: /*Added for Tca audit */
495: IF g_audit_profile='Y' THEN
496:
497: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
498: MERGE_LOG_ID,
499: TABLE_NAME,
500: MERGE_HEADER_ID,
501: PRIMARY_KEY1,

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 570: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

566:
567: /*Added for tca audit*/
568: IF g_audit_profile='Y' THEN
569:
570: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
571: MERGE_LOG_ID,
572: TABLE_NAME,
573: MERGE_HEADER_ID,
574: PRIMARY_KEY1,

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 637: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

633: -- update pa_project_customers table for customer_id and ship_to_address_id.
634: --
635: IF g_audit_profile='Y' THEN
636:
637: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
638: MERGE_LOG_ID,
639: TABLE_NAME,
640: MERGE_HEADER_ID,
641: PRIMARY_KEY1,

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 703: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

699: /*For customer account relation enhancement*/
700:
701: IF g_audit_profile='Y' THEN
702:
703: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
704: MERGE_LOG_ID,
705: TABLE_NAME,
706: MERGE_HEADER_ID,
707: PRIMARY_KEY1,

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 762: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

758: AND PC.BILL_TO_CUSTOMER_ID = var_bill_to_cust_id; /* for bug 11842127 */
759:
760: IF g_audit_profile='Y' THEN
761:
762: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
763: MERGE_LOG_ID,
764: TABLE_NAME,
765: MERGE_HEADER_ID,
766: PRIMARY_KEY1,

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 826: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

822: --
823:
824: IF g_audit_profile='Y' THEN
825:
826: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
827: MERGE_LOG_ID,
828: TABLE_NAME,
829: MERGE_HEADER_ID,
830: PRIMARY_KEY1,

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 906: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

902: -- update log file to indicate the table being updated.
903: --
904: IF g_audit_profile='Y' THEN
905:
906: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
907: MERGE_LOG_ID,
908: TABLE_NAME,
909: MERGE_HEADER_ID,
910: PRIMARY_KEY1,

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 966: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

962: AND RACM.SET_NUMBER = set_no );
963:
964: IF g_audit_profile='Y' THEN
965:
966: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
967: MERGE_LOG_ID,
968: TABLE_NAME,
969: MERGE_HEADER_ID,
970: PRIMARY_KEY1,

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 1026: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1022: AND RACM.SET_NUMBER = set_no );
1023:
1024: IF g_audit_profile='Y' THEN
1025:
1026: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1027: MERGE_LOG_ID,
1028: TABLE_NAME,
1029: MERGE_HEADER_ID,
1030: PRIMARY_KEY1,

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 1087: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1083:
1084:
1085: IF g_audit_profile='Y' THEN
1086:
1087: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1088: MERGE_LOG_ID,
1089: TABLE_NAME,
1090: MERGE_HEADER_ID,
1091: PRIMARY_KEY1,

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 1151: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1147: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' );
1148:
1149: IF g_audit_profile='Y' THEN
1150:
1151: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1152: MERGE_LOG_ID,
1153: TABLE_NAME,
1154: MERGE_HEADER_ID,
1155: PRIMARY_KEY1,

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 1220: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1216: -- update pa_draft_invoice_items for ship_to_address_id only.
1217: --
1218: IF g_audit_profile='Y' THEN
1219:
1220: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1221: MERGE_LOG_ID,
1222: TABLE_NAME,
1223: MERGE_HEADER_ID,
1224: PRIMARY_KEY1,

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 1293: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1289: -- update pa_tasks for address_id ( ship address id ).
1290: --
1291: IF g_audit_profile='Y' THEN
1292:
1293: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1294: MERGE_LOG_ID,
1295: TABLE_NAME,
1296: MERGE_HEADER_ID,
1297: PRIMARY_KEY_ID,

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 1364: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1360: -- update pa_implementations for customer_id (duplicate_id ).
1361: --
1362: IF g_audit_profile='Y' THEN
1363:
1364: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1365: MERGE_LOG_ID,
1366: TABLE_NAME,
1367: MERGE_HEADER_ID,
1368: PRIMARY_KEY_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 1435: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1431: -- update pa_proj_retn_rules for customer_id (duplicate_id ).
1432:
1433: IF g_audit_profile='Y' THEN
1434:
1435: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1436: MERGE_LOG_ID,
1437: TABLE_NAME,
1438: MERGE_HEADER_ID,
1439: PRIMARY_KEY_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 1513: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1509: -- update pa_proj_retn_bill_rules for customer_id (duplicate_id ).
1510: --
1511: IF g_audit_profile='Y' THEN
1512:
1513: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1514: MERGE_LOG_ID,
1515: TABLE_NAME,
1516: MERGE_HEADER_ID,
1517: PRIMARY_KEY_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 1591: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1587: -- update pa_summary_project_retn for customer_id (duplicate_id ).
1588: --
1589: IF g_audit_profile='Y' THEN
1590:
1591: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1592: MERGE_LOG_ID,
1593: TABLE_NAME,
1594: MERGE_HEADER_ID,
1595: PRIMARY_KEY1,

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,