APPS.PAP_CMERGE dependencies on HZ_UTILITY_PUB

Line 446: hz_utility_pub.CREATED_BY,

442: var_project_id,
443: new_customer_id,
444: 'D',
445: req_id,
446: hz_utility_pub.CREATED_BY,
447: hz_utility_pub.CREATION_DATE,
448: hz_utility_pub.LAST_UPDATE_LOGIN,
449: hz_utility_pub.LAST_UPDATE_DATE,
450: hz_utility_pub.LAST_UPDATED_BY,

Line 447: hz_utility_pub.CREATION_DATE,

443: new_customer_id,
444: 'D',
445: req_id,
446: hz_utility_pub.CREATED_BY,
447: hz_utility_pub.CREATION_DATE,
448: hz_utility_pub.LAST_UPDATE_LOGIN,
449: hz_utility_pub.LAST_UPDATE_DATE,
450: hz_utility_pub.LAST_UPDATED_BY,
451: PC.PROJECT_ID

Line 448: hz_utility_pub.LAST_UPDATE_LOGIN,

444: 'D',
445: req_id,
446: hz_utility_pub.CREATED_BY,
447: hz_utility_pub.CREATION_DATE,
448: hz_utility_pub.LAST_UPDATE_LOGIN,
449: hz_utility_pub.LAST_UPDATE_DATE,
450: hz_utility_pub.LAST_UPDATED_BY,
451: PC.PROJECT_ID
452: ,PC.CUSTOMER_ID

Line 449: hz_utility_pub.LAST_UPDATE_DATE,

445: req_id,
446: hz_utility_pub.CREATED_BY,
447: hz_utility_pub.CREATION_DATE,
448: hz_utility_pub.LAST_UPDATE_LOGIN,
449: hz_utility_pub.LAST_UPDATE_DATE,
450: hz_utility_pub.LAST_UPDATED_BY,
451: PC.PROJECT_ID
452: ,PC.CUSTOMER_ID
453: ,PC.LAST_UPDATE_DATE

Line 450: hz_utility_pub.LAST_UPDATED_BY,

446: hz_utility_pub.CREATED_BY,
447: hz_utility_pub.CREATION_DATE,
448: hz_utility_pub.LAST_UPDATE_LOGIN,
449: hz_utility_pub.LAST_UPDATE_DATE,
450: hz_utility_pub.LAST_UPDATED_BY,
451: PC.PROJECT_ID
452: ,PC.CUSTOMER_ID
453: ,PC.LAST_UPDATE_DATE
454: ,PC.LAST_UPDATED_BY

Line 523: hz_utility_pub.CREATED_BY,

519: PC.customer_bill_split,
520: PC.customer_bill_split+ var_customer_bill_split,
521: 'U',
522: req_id,
523: hz_utility_pub.CREATED_BY,
524: hz_utility_pub.CREATION_DATE,
525: hz_utility_pub.LAST_UPDATE_LOGIN,
526: hz_utility_pub.LAST_UPDATE_DATE,
527: hz_utility_pub.LAST_UPDATED_BY

Line 524: hz_utility_pub.CREATION_DATE,

520: PC.customer_bill_split+ var_customer_bill_split,
521: 'U',
522: req_id,
523: hz_utility_pub.CREATED_BY,
524: hz_utility_pub.CREATION_DATE,
525: hz_utility_pub.LAST_UPDATE_LOGIN,
526: hz_utility_pub.LAST_UPDATE_DATE,
527: hz_utility_pub.LAST_UPDATED_BY
528: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM

Line 525: hz_utility_pub.LAST_UPDATE_LOGIN,

521: 'U',
522: req_id,
523: hz_utility_pub.CREATED_BY,
524: hz_utility_pub.CREATION_DATE,
525: hz_utility_pub.LAST_UPDATE_LOGIN,
526: hz_utility_pub.LAST_UPDATE_DATE,
527: hz_utility_pub.LAST_UPDATED_BY
528: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
529: WHERE PC.PROJECT_ID = var_project_id

Line 526: hz_utility_pub.LAST_UPDATE_DATE,

522: req_id,
523: hz_utility_pub.CREATED_BY,
524: hz_utility_pub.CREATION_DATE,
525: hz_utility_pub.LAST_UPDATE_LOGIN,
526: hz_utility_pub.LAST_UPDATE_DATE,
527: hz_utility_pub.LAST_UPDATED_BY
528: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
529: WHERE PC.PROJECT_ID = var_project_id
530: AND PC.CUSTOMER_ID = new_customer_id

Line 527: hz_utility_pub.LAST_UPDATED_BY

523: hz_utility_pub.CREATED_BY,
524: hz_utility_pub.CREATION_DATE,
525: hz_utility_pub.LAST_UPDATE_LOGIN,
526: hz_utility_pub.LAST_UPDATE_DATE,
527: hz_utility_pub.LAST_UPDATED_BY
528: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
529: WHERE PC.PROJECT_ID = var_project_id
530: AND PC.CUSTOMER_ID = new_customer_id
531: AND RACM.DUPLICATE_ID = var_customer_id

Line 595: hz_utility_pub.CREATED_BY,

591: PC.bill_to_address_id,
592: RACM.CUSTOMER_ADDRESS_ID,
593: 'U',
594: req_id,
595: hz_utility_pub.CREATED_BY,
596: hz_utility_pub.CREATION_DATE,
597: hz_utility_pub.LAST_UPDATE_LOGIN,
598: hz_utility_pub.LAST_UPDATE_DATE,
599: hz_utility_pub.LAST_UPDATED_BY

Line 596: hz_utility_pub.CREATION_DATE,

592: RACM.CUSTOMER_ADDRESS_ID,
593: 'U',
594: req_id,
595: hz_utility_pub.CREATED_BY,
596: hz_utility_pub.CREATION_DATE,
597: hz_utility_pub.LAST_UPDATE_LOGIN,
598: hz_utility_pub.LAST_UPDATE_DATE,
599: hz_utility_pub.LAST_UPDATED_BY
600: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

Line 597: hz_utility_pub.LAST_UPDATE_LOGIN,

593: 'U',
594: req_id,
595: hz_utility_pub.CREATED_BY,
596: hz_utility_pub.CREATION_DATE,
597: hz_utility_pub.LAST_UPDATE_LOGIN,
598: hz_utility_pub.LAST_UPDATE_DATE,
599: hz_utility_pub.LAST_UPDATED_BY
600: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
601: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/

Line 598: hz_utility_pub.LAST_UPDATE_DATE,

594: req_id,
595: hz_utility_pub.CREATED_BY,
596: hz_utility_pub.CREATION_DATE,
597: hz_utility_pub.LAST_UPDATE_LOGIN,
598: hz_utility_pub.LAST_UPDATE_DATE,
599: hz_utility_pub.LAST_UPDATED_BY
600: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
601: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
602: AND RACM.DUPLICATE_ADDRESS_ID = PC.BILL_TO_ADDRESS_ID

Line 599: hz_utility_pub.LAST_UPDATED_BY

595: hz_utility_pub.CREATED_BY,
596: hz_utility_pub.CREATION_DATE,
597: hz_utility_pub.LAST_UPDATE_LOGIN,
598: hz_utility_pub.LAST_UPDATE_DATE,
599: hz_utility_pub.LAST_UPDATED_BY
600: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
601: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
602: AND RACM.DUPLICATE_ADDRESS_ID = PC.BILL_TO_ADDRESS_ID
603: AND RACM.PROCESS_FLAG = 'N'

Line 662: hz_utility_pub.CREATED_BY,

658: PC.ship_to_address_id,
659: RACM.CUSTOMER_ADDRESS_ID,
660: 'U',
661: req_id,
662: hz_utility_pub.CREATED_BY,
663: hz_utility_pub.CREATION_DATE,
664: hz_utility_pub.LAST_UPDATE_LOGIN,
665: hz_utility_pub.LAST_UPDATE_DATE,
666: hz_utility_pub.LAST_UPDATED_BY

Line 663: hz_utility_pub.CREATION_DATE,

659: RACM.CUSTOMER_ADDRESS_ID,
660: 'U',
661: req_id,
662: hz_utility_pub.CREATED_BY,
663: hz_utility_pub.CREATION_DATE,
664: hz_utility_pub.LAST_UPDATE_LOGIN,
665: hz_utility_pub.LAST_UPDATE_DATE,
666: hz_utility_pub.LAST_UPDATED_BY
667: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

Line 664: hz_utility_pub.LAST_UPDATE_LOGIN,

660: 'U',
661: req_id,
662: hz_utility_pub.CREATED_BY,
663: hz_utility_pub.CREATION_DATE,
664: hz_utility_pub.LAST_UPDATE_LOGIN,
665: hz_utility_pub.LAST_UPDATE_DATE,
666: hz_utility_pub.LAST_UPDATED_BY
667: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
668: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/

Line 665: hz_utility_pub.LAST_UPDATE_DATE,

661: req_id,
662: hz_utility_pub.CREATED_BY,
663: hz_utility_pub.CREATION_DATE,
664: hz_utility_pub.LAST_UPDATE_LOGIN,
665: hz_utility_pub.LAST_UPDATE_DATE,
666: hz_utility_pub.LAST_UPDATED_BY
667: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
668: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
669: AND RACM.DUPLICATE_ADDRESS_ID = PC.SHIP_TO_ADDRESS_ID

Line 666: hz_utility_pub.LAST_UPDATED_BY

662: hz_utility_pub.CREATED_BY,
663: hz_utility_pub.CREATION_DATE,
664: hz_utility_pub.LAST_UPDATE_LOGIN,
665: hz_utility_pub.LAST_UPDATE_DATE,
666: hz_utility_pub.LAST_UPDATED_BY
667: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
668: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
669: AND RACM.DUPLICATE_ADDRESS_ID = PC.SHIP_TO_ADDRESS_ID
670: AND RACM.PROCESS_FLAG = 'N'

Line 728: hz_utility_pub.CREATED_BY,

724: PC.bill_to_customer_id,
725: RACM.CUSTOMER_ID,
726: 'U',
727: req_id,
728: hz_utility_pub.CREATED_BY,
729: hz_utility_pub.CREATION_DATE,
730: hz_utility_pub.LAST_UPDATE_LOGIN,
731: hz_utility_pub.LAST_UPDATE_DATE,
732: hz_utility_pub.LAST_UPDATED_BY

Line 729: hz_utility_pub.CREATION_DATE,

725: RACM.CUSTOMER_ID,
726: 'U',
727: req_id,
728: hz_utility_pub.CREATED_BY,
729: hz_utility_pub.CREATION_DATE,
730: hz_utility_pub.LAST_UPDATE_LOGIN,
731: hz_utility_pub.LAST_UPDATE_DATE,
732: hz_utility_pub.LAST_UPDATED_BY
733: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

Line 730: hz_utility_pub.LAST_UPDATE_LOGIN,

726: 'U',
727: req_id,
728: hz_utility_pub.CREATED_BY,
729: hz_utility_pub.CREATION_DATE,
730: hz_utility_pub.LAST_UPDATE_LOGIN,
731: hz_utility_pub.LAST_UPDATE_DATE,
732: hz_utility_pub.LAST_UPDATED_BY
733: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
734: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/

Line 731: hz_utility_pub.LAST_UPDATE_DATE,

727: req_id,
728: hz_utility_pub.CREATED_BY,
729: hz_utility_pub.CREATION_DATE,
730: hz_utility_pub.LAST_UPDATE_LOGIN,
731: hz_utility_pub.LAST_UPDATE_DATE,
732: hz_utility_pub.LAST_UPDATED_BY
733: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
734: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
735: AND RACM.PROCESS_FLAG = 'N'

Line 732: hz_utility_pub.LAST_UPDATED_BY

728: hz_utility_pub.CREATED_BY,
729: hz_utility_pub.CREATION_DATE,
730: hz_utility_pub.LAST_UPDATE_LOGIN,
731: hz_utility_pub.LAST_UPDATE_DATE,
732: hz_utility_pub.LAST_UPDATED_BY
733: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
734: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
735: AND RACM.PROCESS_FLAG = 'N'
736: AND RACM.SET_NUMBER = set_no

Line 787: hz_utility_pub.CREATED_BY,

783: PC.ship_to_customer_id,
784: RACM.CUSTOMER_ID,
785: 'U',
786: req_id,
787: hz_utility_pub.CREATED_BY,
788: hz_utility_pub.CREATION_DATE,
789: hz_utility_pub.LAST_UPDATE_LOGIN,
790: hz_utility_pub.LAST_UPDATE_DATE,
791: hz_utility_pub.LAST_UPDATED_BY

Line 788: hz_utility_pub.CREATION_DATE,

784: RACM.CUSTOMER_ID,
785: 'U',
786: req_id,
787: hz_utility_pub.CREATED_BY,
788: hz_utility_pub.CREATION_DATE,
789: hz_utility_pub.LAST_UPDATE_LOGIN,
790: hz_utility_pub.LAST_UPDATE_DATE,
791: hz_utility_pub.LAST_UPDATED_BY
792: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

Line 789: hz_utility_pub.LAST_UPDATE_LOGIN,

785: 'U',
786: req_id,
787: hz_utility_pub.CREATED_BY,
788: hz_utility_pub.CREATION_DATE,
789: hz_utility_pub.LAST_UPDATE_LOGIN,
790: hz_utility_pub.LAST_UPDATE_DATE,
791: hz_utility_pub.LAST_UPDATED_BY
792: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
793: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/

Line 790: hz_utility_pub.LAST_UPDATE_DATE,

786: req_id,
787: hz_utility_pub.CREATED_BY,
788: hz_utility_pub.CREATION_DATE,
789: hz_utility_pub.LAST_UPDATE_LOGIN,
790: hz_utility_pub.LAST_UPDATE_DATE,
791: hz_utility_pub.LAST_UPDATED_BY
792: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
793: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
794: AND RACM.PROCESS_FLAG = 'N'

Line 791: hz_utility_pub.LAST_UPDATED_BY

787: hz_utility_pub.CREATED_BY,
788: hz_utility_pub.CREATION_DATE,
789: hz_utility_pub.LAST_UPDATE_LOGIN,
790: hz_utility_pub.LAST_UPDATE_DATE,
791: hz_utility_pub.LAST_UPDATED_BY
792: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
793: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
794: AND RACM.PROCESS_FLAG = 'N'
795: AND RACM.SET_NUMBER = set_no

Line 850: hz_utility_pub.CREATED_BY,

846: PC.customer_id,
847: RACM.CUSTOMER_ID,
848: 'U',
849: req_id,
850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY

Line 851: hz_utility_pub.CREATION_DATE,

847: RACM.CUSTOMER_ID,
848: 'U',
849: req_id,
850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY
855: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM

Line 852: hz_utility_pub.LAST_UPDATE_LOGIN,

848: 'U',
849: req_id,
850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY
855: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
856: WHERE RACM.DUPLICATE_ID = var_customer_id

Line 853: hz_utility_pub.LAST_UPDATE_DATE,

849: req_id,
850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY
855: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
856: WHERE RACM.DUPLICATE_ID = var_customer_id
857: AND RACM.PROCESS_FLAG = 'N'

Line 854: hz_utility_pub.LAST_UPDATED_BY

850: hz_utility_pub.CREATED_BY,
851: hz_utility_pub.CREATION_DATE,
852: hz_utility_pub.LAST_UPDATE_LOGIN,
853: hz_utility_pub.LAST_UPDATE_DATE,
854: hz_utility_pub.LAST_UPDATED_BY
855: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
856: WHERE RACM.DUPLICATE_ID = var_customer_id
857: AND RACM.PROCESS_FLAG = 'N'
858: AND RACM.SET_NUMBER = set_no

Line 932: hz_utility_pub.CREATED_BY,

928: PDI.CUSTOMER_ID,
929: RACM.CUSTOMER_ID,
930: 'U',
931: req_id,
932: hz_utility_pub.CREATED_BY,
933: hz_utility_pub.CREATION_DATE,
934: hz_utility_pub.LAST_UPDATE_LOGIN,
935: hz_utility_pub.LAST_UPDATE_DATE,
936: hz_utility_pub.LAST_UPDATED_BY

Line 933: hz_utility_pub.CREATION_DATE,

929: RACM.CUSTOMER_ID,
930: 'U',
931: req_id,
932: hz_utility_pub.CREATED_BY,
933: hz_utility_pub.CREATION_DATE,
934: hz_utility_pub.LAST_UPDATE_LOGIN,
935: hz_utility_pub.LAST_UPDATE_DATE,
936: hz_utility_pub.LAST_UPDATED_BY
937: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 934: hz_utility_pub.LAST_UPDATE_LOGIN,

930: 'U',
931: req_id,
932: hz_utility_pub.CREATED_BY,
933: hz_utility_pub.CREATION_DATE,
934: hz_utility_pub.LAST_UPDATE_LOGIN,
935: hz_utility_pub.LAST_UPDATE_DATE,
936: hz_utility_pub.LAST_UPDATED_BY
937: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
938: CUSTOMER_ID,

Line 935: hz_utility_pub.LAST_UPDATE_DATE,

931: req_id,
932: hz_utility_pub.CREATED_BY,
933: hz_utility_pub.CREATION_DATE,
934: hz_utility_pub.LAST_UPDATE_LOGIN,
935: hz_utility_pub.LAST_UPDATE_DATE,
936: hz_utility_pub.LAST_UPDATED_BY
937: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
938: CUSTOMER_ID,
939: DUPLICATE_ID

Line 936: hz_utility_pub.LAST_UPDATED_BY

932: hz_utility_pub.CREATED_BY,
933: hz_utility_pub.CREATION_DATE,
934: hz_utility_pub.LAST_UPDATE_LOGIN,
935: hz_utility_pub.LAST_UPDATE_DATE,
936: hz_utility_pub.LAST_UPDATED_BY
937: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
938: CUSTOMER_ID,
939: DUPLICATE_ID
940: FROM RA_CUSTOMER_MERGES

Line 992: hz_utility_pub.CREATED_BY,

988: PDI.BILL_TO_CUSTOMER_ID,
989: RACM.CUSTOMER_ID,
990: 'U',
991: req_id,
992: hz_utility_pub.CREATED_BY,
993: hz_utility_pub.CREATION_DATE,
994: hz_utility_pub.LAST_UPDATE_LOGIN,
995: hz_utility_pub.LAST_UPDATE_DATE,
996: hz_utility_pub.LAST_UPDATED_BY

Line 993: hz_utility_pub.CREATION_DATE,

989: RACM.CUSTOMER_ID,
990: 'U',
991: req_id,
992: hz_utility_pub.CREATED_BY,
993: hz_utility_pub.CREATION_DATE,
994: hz_utility_pub.LAST_UPDATE_LOGIN,
995: hz_utility_pub.LAST_UPDATE_DATE,
996: hz_utility_pub.LAST_UPDATED_BY
997: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 994: hz_utility_pub.LAST_UPDATE_LOGIN,

990: 'U',
991: req_id,
992: hz_utility_pub.CREATED_BY,
993: hz_utility_pub.CREATION_DATE,
994: hz_utility_pub.LAST_UPDATE_LOGIN,
995: hz_utility_pub.LAST_UPDATE_DATE,
996: hz_utility_pub.LAST_UPDATED_BY
997: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
998: CUSTOMER_ID,

Line 995: hz_utility_pub.LAST_UPDATE_DATE,

991: req_id,
992: hz_utility_pub.CREATED_BY,
993: hz_utility_pub.CREATION_DATE,
994: hz_utility_pub.LAST_UPDATE_LOGIN,
995: hz_utility_pub.LAST_UPDATE_DATE,
996: hz_utility_pub.LAST_UPDATED_BY
997: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
998: CUSTOMER_ID,
999: DUPLICATE_ID

Line 996: hz_utility_pub.LAST_UPDATED_BY

992: hz_utility_pub.CREATED_BY,
993: hz_utility_pub.CREATION_DATE,
994: hz_utility_pub.LAST_UPDATE_LOGIN,
995: hz_utility_pub.LAST_UPDATE_DATE,
996: hz_utility_pub.LAST_UPDATED_BY
997: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
998: CUSTOMER_ID,
999: DUPLICATE_ID
1000: FROM RA_CUSTOMER_MERGES

Line 1052: hz_utility_pub.CREATED_BY,

1048: PDI.SHIP_TO_CUSTOMER_ID,
1049: RACM.CUSTOMER_ID,
1050: 'U',
1051: req_id,
1052: hz_utility_pub.CREATED_BY,
1053: hz_utility_pub.CREATION_DATE,
1054: hz_utility_pub.LAST_UPDATE_LOGIN,
1055: hz_utility_pub.LAST_UPDATE_DATE,
1056: hz_utility_pub.LAST_UPDATED_BY

Line 1053: hz_utility_pub.CREATION_DATE,

1049: RACM.CUSTOMER_ID,
1050: 'U',
1051: req_id,
1052: hz_utility_pub.CREATED_BY,
1053: hz_utility_pub.CREATION_DATE,
1054: hz_utility_pub.LAST_UPDATE_LOGIN,
1055: hz_utility_pub.LAST_UPDATE_DATE,
1056: hz_utility_pub.LAST_UPDATED_BY
1057: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1054: hz_utility_pub.LAST_UPDATE_LOGIN,

1050: 'U',
1051: req_id,
1052: hz_utility_pub.CREATED_BY,
1053: hz_utility_pub.CREATION_DATE,
1054: hz_utility_pub.LAST_UPDATE_LOGIN,
1055: hz_utility_pub.LAST_UPDATE_DATE,
1056: hz_utility_pub.LAST_UPDATED_BY
1057: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1058: CUSTOMER_ID,

Line 1055: hz_utility_pub.LAST_UPDATE_DATE,

1051: req_id,
1052: hz_utility_pub.CREATED_BY,
1053: hz_utility_pub.CREATION_DATE,
1054: hz_utility_pub.LAST_UPDATE_LOGIN,
1055: hz_utility_pub.LAST_UPDATE_DATE,
1056: hz_utility_pub.LAST_UPDATED_BY
1057: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1058: CUSTOMER_ID,
1059: DUPLICATE_ID

Line 1056: hz_utility_pub.LAST_UPDATED_BY

1052: hz_utility_pub.CREATED_BY,
1053: hz_utility_pub.CREATION_DATE,
1054: hz_utility_pub.LAST_UPDATE_LOGIN,
1055: hz_utility_pub.LAST_UPDATE_DATE,
1056: hz_utility_pub.LAST_UPDATED_BY
1057: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1058: CUSTOMER_ID,
1059: DUPLICATE_ID
1060: FROM RA_CUSTOMER_MERGES

Line 1113: hz_utility_pub.CREATED_BY,

1109: PDI.BILL_TO_ADDRESS_ID,
1110: RACM.CUSTOMER_ADDRESS_ID,
1111: 'U',
1112: req_id,
1113: hz_utility_pub.CREATED_BY,
1114: hz_utility_pub.CREATION_DATE,
1115: hz_utility_pub.LAST_UPDATE_LOGIN,
1116: hz_utility_pub.LAST_UPDATE_DATE,
1117: hz_utility_pub.LAST_UPDATED_BY

Line 1114: hz_utility_pub.CREATION_DATE,

1110: RACM.CUSTOMER_ADDRESS_ID,
1111: 'U',
1112: req_id,
1113: hz_utility_pub.CREATED_BY,
1114: hz_utility_pub.CREATION_DATE,
1115: hz_utility_pub.LAST_UPDATE_LOGIN,
1116: hz_utility_pub.LAST_UPDATE_DATE,
1117: hz_utility_pub.LAST_UPDATED_BY
1118: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

Line 1115: hz_utility_pub.LAST_UPDATE_LOGIN,

1111: 'U',
1112: req_id,
1113: hz_utility_pub.CREATED_BY,
1114: hz_utility_pub.CREATION_DATE,
1115: hz_utility_pub.LAST_UPDATE_LOGIN,
1116: hz_utility_pub.LAST_UPDATE_DATE,
1117: hz_utility_pub.LAST_UPDATED_BY
1118: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1119: WHERE

Line 1116: hz_utility_pub.LAST_UPDATE_DATE,

1112: req_id,
1113: hz_utility_pub.CREATED_BY,
1114: hz_utility_pub.CREATION_DATE,
1115: hz_utility_pub.LAST_UPDATE_LOGIN,
1116: hz_utility_pub.LAST_UPDATE_DATE,
1117: hz_utility_pub.LAST_UPDATED_BY
1118: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1119: WHERE
1120: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID

Line 1117: hz_utility_pub.LAST_UPDATED_BY

1113: hz_utility_pub.CREATED_BY,
1114: hz_utility_pub.CREATION_DATE,
1115: hz_utility_pub.LAST_UPDATE_LOGIN,
1116: hz_utility_pub.LAST_UPDATE_DATE,
1117: hz_utility_pub.LAST_UPDATED_BY
1118: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1119: WHERE
1120: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID
1121: AND RACM.DUPLICATE_ID = PDI.BILL_TO_CUSTOMER_ID /* for bug 11842127 */

Line 1177: hz_utility_pub.CREATED_BY,

1173: PDI.SHIP_TO_ADDRESS_ID,
1174: RACM.CUSTOMER_ADDRESS_ID,
1175: 'U',
1176: req_id,
1177: hz_utility_pub.CREATED_BY,
1178: hz_utility_pub.CREATION_DATE,
1179: hz_utility_pub.LAST_UPDATE_LOGIN,
1180: hz_utility_pub.LAST_UPDATE_DATE,
1181: hz_utility_pub.LAST_UPDATED_BY

Line 1178: hz_utility_pub.CREATION_DATE,

1174: RACM.CUSTOMER_ADDRESS_ID,
1175: 'U',
1176: req_id,
1177: hz_utility_pub.CREATED_BY,
1178: hz_utility_pub.CREATION_DATE,
1179: hz_utility_pub.LAST_UPDATE_LOGIN,
1180: hz_utility_pub.LAST_UPDATE_DATE,
1181: hz_utility_pub.LAST_UPDATED_BY
1182: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

Line 1179: hz_utility_pub.LAST_UPDATE_LOGIN,

1175: 'U',
1176: req_id,
1177: hz_utility_pub.CREATED_BY,
1178: hz_utility_pub.CREATION_DATE,
1179: hz_utility_pub.LAST_UPDATE_LOGIN,
1180: hz_utility_pub.LAST_UPDATE_DATE,
1181: hz_utility_pub.LAST_UPDATED_BY
1182: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1183: WHERE

Line 1180: hz_utility_pub.LAST_UPDATE_DATE,

1176: req_id,
1177: hz_utility_pub.CREATED_BY,
1178: hz_utility_pub.CREATION_DATE,
1179: hz_utility_pub.LAST_UPDATE_LOGIN,
1180: hz_utility_pub.LAST_UPDATE_DATE,
1181: hz_utility_pub.LAST_UPDATED_BY
1182: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1183: WHERE
1184: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID

Line 1181: hz_utility_pub.LAST_UPDATED_BY

1177: hz_utility_pub.CREATED_BY,
1178: hz_utility_pub.CREATION_DATE,
1179: hz_utility_pub.LAST_UPDATE_LOGIN,
1180: hz_utility_pub.LAST_UPDATE_DATE,
1181: hz_utility_pub.LAST_UPDATED_BY
1182: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1183: WHERE
1184: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID
1185: AND RACM.DUPLICATE_ID = PDI.SHIP_TO_CUSTOMER_ID /* for bug 11842127 */

Line 1246: hz_utility_pub.CREATED_BY,

1242: PDII.ship_to_address_id,
1243: RACM.CUSTOMER_ADDRESS_ID,
1244: 'U',
1245: req_id,
1246: hz_utility_pub.CREATED_BY,
1247: hz_utility_pub.CREATION_DATE,
1248: hz_utility_pub.LAST_UPDATE_LOGIN,
1249: hz_utility_pub.LAST_UPDATE_DATE,
1250: hz_utility_pub.LAST_UPDATED_BY

Line 1247: hz_utility_pub.CREATION_DATE,

1243: RACM.CUSTOMER_ADDRESS_ID,
1244: 'U',
1245: req_id,
1246: hz_utility_pub.CREATED_BY,
1247: hz_utility_pub.CREATION_DATE,
1248: hz_utility_pub.LAST_UPDATE_LOGIN,
1249: hz_utility_pub.LAST_UPDATE_DATE,
1250: hz_utility_pub.LAST_UPDATED_BY
1251: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM

Line 1248: hz_utility_pub.LAST_UPDATE_LOGIN,

1244: 'U',
1245: req_id,
1246: hz_utility_pub.CREATED_BY,
1247: hz_utility_pub.CREATION_DATE,
1248: hz_utility_pub.LAST_UPDATE_LOGIN,
1249: hz_utility_pub.LAST_UPDATE_DATE,
1250: hz_utility_pub.LAST_UPDATED_BY
1251: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM
1252: WHERE RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID

Line 1249: hz_utility_pub.LAST_UPDATE_DATE,

1245: req_id,
1246: hz_utility_pub.CREATED_BY,
1247: hz_utility_pub.CREATION_DATE,
1248: hz_utility_pub.LAST_UPDATE_LOGIN,
1249: hz_utility_pub.LAST_UPDATE_DATE,
1250: hz_utility_pub.LAST_UPDATED_BY
1251: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM
1252: WHERE RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID
1253: AND RACM.PROCESS_FLAG = 'N'

Line 1250: hz_utility_pub.LAST_UPDATED_BY

1246: hz_utility_pub.CREATED_BY,
1247: hz_utility_pub.CREATION_DATE,
1248: hz_utility_pub.LAST_UPDATE_LOGIN,
1249: hz_utility_pub.LAST_UPDATE_DATE,
1250: hz_utility_pub.LAST_UPDATED_BY
1251: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM
1252: WHERE RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID
1253: AND RACM.PROCESS_FLAG = 'N'
1254: AND RACM.SET_NUMBER = set_no

Line 1319: hz_utility_pub.CREATED_BY,

1315: PT.Customer_ID,
1316: New_customer_ID,
1317: 'U',
1318: req_id,
1319: hz_utility_pub.CREATED_BY,
1320: hz_utility_pub.CREATION_DATE,
1321: hz_utility_pub.LAST_UPDATE_LOGIN,
1322: hz_utility_pub.LAST_UPDATE_DATE,
1323: hz_utility_pub.LAST_UPDATED_BY

Line 1320: hz_utility_pub.CREATION_DATE,

1316: New_customer_ID,
1317: 'U',
1318: req_id,
1319: hz_utility_pub.CREATED_BY,
1320: hz_utility_pub.CREATION_DATE,
1321: hz_utility_pub.LAST_UPDATE_LOGIN,
1322: hz_utility_pub.LAST_UPDATE_DATE,
1323: hz_utility_pub.LAST_UPDATED_BY
1324: FROM PA_TASKS PT, ra_customer_merges RACM

Line 1321: hz_utility_pub.LAST_UPDATE_LOGIN,

1317: 'U',
1318: req_id,
1319: hz_utility_pub.CREATED_BY,
1320: hz_utility_pub.CREATION_DATE,
1321: hz_utility_pub.LAST_UPDATE_LOGIN,
1322: hz_utility_pub.LAST_UPDATE_DATE,
1323: hz_utility_pub.LAST_UPDATED_BY
1324: FROM PA_TASKS PT, ra_customer_merges RACM
1325: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID

Line 1322: hz_utility_pub.LAST_UPDATE_DATE,

1318: req_id,
1319: hz_utility_pub.CREATED_BY,
1320: hz_utility_pub.CREATION_DATE,
1321: hz_utility_pub.LAST_UPDATE_LOGIN,
1322: hz_utility_pub.LAST_UPDATE_DATE,
1323: hz_utility_pub.LAST_UPDATED_BY
1324: FROM PA_TASKS PT, ra_customer_merges RACM
1325: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1326: AND RACM.PROCESS_FLAG = 'N'

Line 1323: hz_utility_pub.LAST_UPDATED_BY

1319: hz_utility_pub.CREATED_BY,
1320: hz_utility_pub.CREATION_DATE,
1321: hz_utility_pub.LAST_UPDATE_LOGIN,
1322: hz_utility_pub.LAST_UPDATE_DATE,
1323: hz_utility_pub.LAST_UPDATED_BY
1324: FROM PA_TASKS PT, ra_customer_merges RACM
1325: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1326: AND RACM.PROCESS_FLAG = 'N'
1327: AND RACM.SET_NUMBER = set_no

Line 1386: hz_utility_pub.CREATED_BY,

1382: PI.CUSTOMER_ID,
1383: RACM.CUSTOMER_ID,
1384: 'U',
1385: req_id,
1386: hz_utility_pub.CREATED_BY,
1387: hz_utility_pub.CREATION_DATE,
1388: hz_utility_pub.LAST_UPDATE_LOGIN,
1389: hz_utility_pub.LAST_UPDATE_DATE,
1390: hz_utility_pub.LAST_UPDATED_BY

Line 1387: hz_utility_pub.CREATION_DATE,

1383: RACM.CUSTOMER_ID,
1384: 'U',
1385: req_id,
1386: hz_utility_pub.CREATED_BY,
1387: hz_utility_pub.CREATION_DATE,
1388: hz_utility_pub.LAST_UPDATE_LOGIN,
1389: hz_utility_pub.LAST_UPDATE_DATE,
1390: hz_utility_pub.LAST_UPDATED_BY
1391: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1388: hz_utility_pub.LAST_UPDATE_LOGIN,

1384: 'U',
1385: req_id,
1386: hz_utility_pub.CREATED_BY,
1387: hz_utility_pub.CREATION_DATE,
1388: hz_utility_pub.LAST_UPDATE_LOGIN,
1389: hz_utility_pub.LAST_UPDATE_DATE,
1390: hz_utility_pub.LAST_UPDATED_BY
1391: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1392: CUSTOMER_ID,

Line 1389: hz_utility_pub.LAST_UPDATE_DATE,

1385: req_id,
1386: hz_utility_pub.CREATED_BY,
1387: hz_utility_pub.CREATION_DATE,
1388: hz_utility_pub.LAST_UPDATE_LOGIN,
1389: hz_utility_pub.LAST_UPDATE_DATE,
1390: hz_utility_pub.LAST_UPDATED_BY
1391: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1392: CUSTOMER_ID,
1393: DUPLICATE_ID

Line 1390: hz_utility_pub.LAST_UPDATED_BY

1386: hz_utility_pub.CREATED_BY,
1387: hz_utility_pub.CREATION_DATE,
1388: hz_utility_pub.LAST_UPDATE_LOGIN,
1389: hz_utility_pub.LAST_UPDATE_DATE,
1390: hz_utility_pub.LAST_UPDATED_BY
1391: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1392: CUSTOMER_ID,
1393: DUPLICATE_ID
1394: FROM RA_CUSTOMER_MERGES

Line 1457: hz_utility_pub.CREATED_BY,

1453: PR.CUSTOMER_ID,
1454: RACM.CUSTOMER_ID,
1455: 'U',
1456: req_id,
1457: hz_utility_pub.CREATED_BY,
1458: hz_utility_pub.CREATION_DATE,
1459: hz_utility_pub.LAST_UPDATE_LOGIN,
1460: hz_utility_pub.LAST_UPDATE_DATE,
1461: hz_utility_pub.LAST_UPDATED_BY

Line 1458: hz_utility_pub.CREATION_DATE,

1454: RACM.CUSTOMER_ID,
1455: 'U',
1456: req_id,
1457: hz_utility_pub.CREATED_BY,
1458: hz_utility_pub.CREATION_DATE,
1459: hz_utility_pub.LAST_UPDATE_LOGIN,
1460: hz_utility_pub.LAST_UPDATE_DATE,
1461: hz_utility_pub.LAST_UPDATED_BY
1462: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1459: hz_utility_pub.LAST_UPDATE_LOGIN,

1455: 'U',
1456: req_id,
1457: hz_utility_pub.CREATED_BY,
1458: hz_utility_pub.CREATION_DATE,
1459: hz_utility_pub.LAST_UPDATE_LOGIN,
1460: hz_utility_pub.LAST_UPDATE_DATE,
1461: hz_utility_pub.LAST_UPDATED_BY
1462: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1463: CUSTOMER_ID,

Line 1460: hz_utility_pub.LAST_UPDATE_DATE,

1456: req_id,
1457: hz_utility_pub.CREATED_BY,
1458: hz_utility_pub.CREATION_DATE,
1459: hz_utility_pub.LAST_UPDATE_LOGIN,
1460: hz_utility_pub.LAST_UPDATE_DATE,
1461: hz_utility_pub.LAST_UPDATED_BY
1462: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1463: CUSTOMER_ID,
1464: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

Line 1461: hz_utility_pub.LAST_UPDATED_BY

1457: hz_utility_pub.CREATED_BY,
1458: hz_utility_pub.CREATION_DATE,
1459: hz_utility_pub.LAST_UPDATE_LOGIN,
1460: hz_utility_pub.LAST_UPDATE_DATE,
1461: hz_utility_pub.LAST_UPDATED_BY
1462: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1463: CUSTOMER_ID,
1464: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1465: WHERE PROCESS_FLAG = 'N'

Line 1535: hz_utility_pub.CREATED_BY,

1531: PB.CUSTOMER_ID,
1532: RACM.CUSTOMER_ID,
1533: 'U',
1534: req_id,
1535: hz_utility_pub.CREATED_BY,
1536: hz_utility_pub.CREATION_DATE,
1537: hz_utility_pub.LAST_UPDATE_LOGIN,
1538: hz_utility_pub.LAST_UPDATE_DATE,
1539: hz_utility_pub.LAST_UPDATED_BY

Line 1536: hz_utility_pub.CREATION_DATE,

1532: RACM.CUSTOMER_ID,
1533: 'U',
1534: req_id,
1535: hz_utility_pub.CREATED_BY,
1536: hz_utility_pub.CREATION_DATE,
1537: hz_utility_pub.LAST_UPDATE_LOGIN,
1538: hz_utility_pub.LAST_UPDATE_DATE,
1539: hz_utility_pub.LAST_UPDATED_BY
1540: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1537: hz_utility_pub.LAST_UPDATE_LOGIN,

1533: 'U',
1534: req_id,
1535: hz_utility_pub.CREATED_BY,
1536: hz_utility_pub.CREATION_DATE,
1537: hz_utility_pub.LAST_UPDATE_LOGIN,
1538: hz_utility_pub.LAST_UPDATE_DATE,
1539: hz_utility_pub.LAST_UPDATED_BY
1540: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1541: CUSTOMER_ID,

Line 1538: hz_utility_pub.LAST_UPDATE_DATE,

1534: req_id,
1535: hz_utility_pub.CREATED_BY,
1536: hz_utility_pub.CREATION_DATE,
1537: hz_utility_pub.LAST_UPDATE_LOGIN,
1538: hz_utility_pub.LAST_UPDATE_DATE,
1539: hz_utility_pub.LAST_UPDATED_BY
1540: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1541: CUSTOMER_ID,
1542: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

Line 1539: hz_utility_pub.LAST_UPDATED_BY

1535: hz_utility_pub.CREATED_BY,
1536: hz_utility_pub.CREATION_DATE,
1537: hz_utility_pub.LAST_UPDATE_LOGIN,
1538: hz_utility_pub.LAST_UPDATE_DATE,
1539: hz_utility_pub.LAST_UPDATED_BY
1540: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1541: CUSTOMER_ID,
1542: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1543: WHERE PROCESS_FLAG ='N'

Line 1617: hz_utility_pub.CREATED_BY,

1613: PS.CUSTOMER_ID,
1614: RACM.CUSTOMER_ID,
1615: 'U',
1616: req_id,
1617: hz_utility_pub.CREATED_BY,
1618: hz_utility_pub.CREATION_DATE,
1619: hz_utility_pub.LAST_UPDATE_LOGIN,
1620: hz_utility_pub.LAST_UPDATE_DATE,
1621: hz_utility_pub.LAST_UPDATED_BY

Line 1618: hz_utility_pub.CREATION_DATE,

1614: RACM.CUSTOMER_ID,
1615: 'U',
1616: req_id,
1617: hz_utility_pub.CREATED_BY,
1618: hz_utility_pub.CREATION_DATE,
1619: hz_utility_pub.LAST_UPDATE_LOGIN,
1620: hz_utility_pub.LAST_UPDATE_DATE,
1621: hz_utility_pub.LAST_UPDATED_BY
1622: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1619: hz_utility_pub.LAST_UPDATE_LOGIN,

1615: 'U',
1616: req_id,
1617: hz_utility_pub.CREATED_BY,
1618: hz_utility_pub.CREATION_DATE,
1619: hz_utility_pub.LAST_UPDATE_LOGIN,
1620: hz_utility_pub.LAST_UPDATE_DATE,
1621: hz_utility_pub.LAST_UPDATED_BY
1622: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1623: CUSTOMER_ID,

Line 1620: hz_utility_pub.LAST_UPDATE_DATE,

1616: req_id,
1617: hz_utility_pub.CREATED_BY,
1618: hz_utility_pub.CREATION_DATE,
1619: hz_utility_pub.LAST_UPDATE_LOGIN,
1620: hz_utility_pub.LAST_UPDATE_DATE,
1621: hz_utility_pub.LAST_UPDATED_BY
1622: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1623: CUSTOMER_ID,
1624: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

Line 1621: hz_utility_pub.LAST_UPDATED_BY

1617: hz_utility_pub.CREATED_BY,
1618: hz_utility_pub.CREATION_DATE,
1619: hz_utility_pub.LAST_UPDATE_LOGIN,
1620: hz_utility_pub.LAST_UPDATE_DATE,
1621: hz_utility_pub.LAST_UPDATED_BY
1622: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1623: CUSTOMER_ID,
1624: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1625: WHERE PROCESS_FLAG = 'N'