APPS.PAP_CMERGE dependencies on HZ_UTILITY_PUB

Line 414: hz_utility_pub.CREATED_BY,

410: var_project_id,
411: new_customer_id,
412: 'D',
413: req_id,
414: hz_utility_pub.CREATED_BY,
415: hz_utility_pub.CREATION_DATE,
416: hz_utility_pub.LAST_UPDATE_LOGIN,
417: hz_utility_pub.LAST_UPDATE_DATE,
418: hz_utility_pub.LAST_UPDATED_BY,

Line 415: hz_utility_pub.CREATION_DATE,

411: new_customer_id,
412: 'D',
413: req_id,
414: hz_utility_pub.CREATED_BY,
415: hz_utility_pub.CREATION_DATE,
416: hz_utility_pub.LAST_UPDATE_LOGIN,
417: hz_utility_pub.LAST_UPDATE_DATE,
418: hz_utility_pub.LAST_UPDATED_BY,
419: PC.PROJECT_ID

Line 416: hz_utility_pub.LAST_UPDATE_LOGIN,

412: 'D',
413: req_id,
414: hz_utility_pub.CREATED_BY,
415: hz_utility_pub.CREATION_DATE,
416: hz_utility_pub.LAST_UPDATE_LOGIN,
417: hz_utility_pub.LAST_UPDATE_DATE,
418: hz_utility_pub.LAST_UPDATED_BY,
419: PC.PROJECT_ID
420: ,PC.CUSTOMER_ID

Line 417: hz_utility_pub.LAST_UPDATE_DATE,

413: req_id,
414: hz_utility_pub.CREATED_BY,
415: hz_utility_pub.CREATION_DATE,
416: hz_utility_pub.LAST_UPDATE_LOGIN,
417: hz_utility_pub.LAST_UPDATE_DATE,
418: hz_utility_pub.LAST_UPDATED_BY,
419: PC.PROJECT_ID
420: ,PC.CUSTOMER_ID
421: ,PC.LAST_UPDATE_DATE

Line 418: hz_utility_pub.LAST_UPDATED_BY,

414: hz_utility_pub.CREATED_BY,
415: hz_utility_pub.CREATION_DATE,
416: hz_utility_pub.LAST_UPDATE_LOGIN,
417: hz_utility_pub.LAST_UPDATE_DATE,
418: hz_utility_pub.LAST_UPDATED_BY,
419: PC.PROJECT_ID
420: ,PC.CUSTOMER_ID
421: ,PC.LAST_UPDATE_DATE
422: ,PC.LAST_UPDATED_BY

Line 491: hz_utility_pub.CREATED_BY,

487: PC.customer_bill_split,
488: PC.customer_bill_split+ var_customer_bill_split,
489: 'U',
490: req_id,
491: hz_utility_pub.CREATED_BY,
492: hz_utility_pub.CREATION_DATE,
493: hz_utility_pub.LAST_UPDATE_LOGIN,
494: hz_utility_pub.LAST_UPDATE_DATE,
495: hz_utility_pub.LAST_UPDATED_BY

Line 492: hz_utility_pub.CREATION_DATE,

488: PC.customer_bill_split+ var_customer_bill_split,
489: 'U',
490: req_id,
491: hz_utility_pub.CREATED_BY,
492: hz_utility_pub.CREATION_DATE,
493: hz_utility_pub.LAST_UPDATE_LOGIN,
494: hz_utility_pub.LAST_UPDATE_DATE,
495: hz_utility_pub.LAST_UPDATED_BY
496: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM

Line 493: hz_utility_pub.LAST_UPDATE_LOGIN,

489: 'U',
490: req_id,
491: hz_utility_pub.CREATED_BY,
492: hz_utility_pub.CREATION_DATE,
493: hz_utility_pub.LAST_UPDATE_LOGIN,
494: hz_utility_pub.LAST_UPDATE_DATE,
495: hz_utility_pub.LAST_UPDATED_BY
496: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
497: WHERE PC.PROJECT_ID = var_project_id

Line 494: hz_utility_pub.LAST_UPDATE_DATE,

490: req_id,
491: hz_utility_pub.CREATED_BY,
492: hz_utility_pub.CREATION_DATE,
493: hz_utility_pub.LAST_UPDATE_LOGIN,
494: hz_utility_pub.LAST_UPDATE_DATE,
495: hz_utility_pub.LAST_UPDATED_BY
496: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
497: WHERE PC.PROJECT_ID = var_project_id
498: AND PC.CUSTOMER_ID = new_customer_id

Line 495: hz_utility_pub.LAST_UPDATED_BY

491: hz_utility_pub.CREATED_BY,
492: hz_utility_pub.CREATION_DATE,
493: hz_utility_pub.LAST_UPDATE_LOGIN,
494: hz_utility_pub.LAST_UPDATE_DATE,
495: hz_utility_pub.LAST_UPDATED_BY
496: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
497: WHERE PC.PROJECT_ID = var_project_id
498: AND PC.CUSTOMER_ID = new_customer_id
499: AND RACM.DUPLICATE_ID = var_customer_id

Line 563: hz_utility_pub.CREATED_BY,

559: PC.bill_to_address_id,
560: RACM.CUSTOMER_ADDRESS_ID,
561: 'U',
562: req_id,
563: hz_utility_pub.CREATED_BY,
564: hz_utility_pub.CREATION_DATE,
565: hz_utility_pub.LAST_UPDATE_LOGIN,
566: hz_utility_pub.LAST_UPDATE_DATE,
567: hz_utility_pub.LAST_UPDATED_BY

Line 564: hz_utility_pub.CREATION_DATE,

560: RACM.CUSTOMER_ADDRESS_ID,
561: 'U',
562: req_id,
563: hz_utility_pub.CREATED_BY,
564: hz_utility_pub.CREATION_DATE,
565: hz_utility_pub.LAST_UPDATE_LOGIN,
566: hz_utility_pub.LAST_UPDATE_DATE,
567: hz_utility_pub.LAST_UPDATED_BY
568: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

Line 565: hz_utility_pub.LAST_UPDATE_LOGIN,

561: 'U',
562: req_id,
563: hz_utility_pub.CREATED_BY,
564: hz_utility_pub.CREATION_DATE,
565: hz_utility_pub.LAST_UPDATE_LOGIN,
566: hz_utility_pub.LAST_UPDATE_DATE,
567: hz_utility_pub.LAST_UPDATED_BY
568: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
569: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/

Line 566: hz_utility_pub.LAST_UPDATE_DATE,

562: req_id,
563: hz_utility_pub.CREATED_BY,
564: hz_utility_pub.CREATION_DATE,
565: hz_utility_pub.LAST_UPDATE_LOGIN,
566: hz_utility_pub.LAST_UPDATE_DATE,
567: hz_utility_pub.LAST_UPDATED_BY
568: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
569: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
570: AND RACM.DUPLICATE_ADDRESS_ID = PC.BILL_TO_ADDRESS_ID

Line 567: hz_utility_pub.LAST_UPDATED_BY

563: hz_utility_pub.CREATED_BY,
564: hz_utility_pub.CREATION_DATE,
565: hz_utility_pub.LAST_UPDATE_LOGIN,
566: hz_utility_pub.LAST_UPDATE_DATE,
567: hz_utility_pub.LAST_UPDATED_BY
568: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
569: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
570: AND RACM.DUPLICATE_ADDRESS_ID = PC.BILL_TO_ADDRESS_ID
571: AND RACM.PROCESS_FLAG = 'N'

Line 630: hz_utility_pub.CREATED_BY,

626: PC.ship_to_address_id,
627: RACM.CUSTOMER_ADDRESS_ID,
628: 'U',
629: req_id,
630: hz_utility_pub.CREATED_BY,
631: hz_utility_pub.CREATION_DATE,
632: hz_utility_pub.LAST_UPDATE_LOGIN,
633: hz_utility_pub.LAST_UPDATE_DATE,
634: hz_utility_pub.LAST_UPDATED_BY

Line 631: hz_utility_pub.CREATION_DATE,

627: RACM.CUSTOMER_ADDRESS_ID,
628: 'U',
629: req_id,
630: hz_utility_pub.CREATED_BY,
631: hz_utility_pub.CREATION_DATE,
632: hz_utility_pub.LAST_UPDATE_LOGIN,
633: hz_utility_pub.LAST_UPDATE_DATE,
634: hz_utility_pub.LAST_UPDATED_BY
635: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

Line 632: hz_utility_pub.LAST_UPDATE_LOGIN,

628: 'U',
629: req_id,
630: hz_utility_pub.CREATED_BY,
631: hz_utility_pub.CREATION_DATE,
632: hz_utility_pub.LAST_UPDATE_LOGIN,
633: hz_utility_pub.LAST_UPDATE_DATE,
634: hz_utility_pub.LAST_UPDATED_BY
635: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
636: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/

Line 633: hz_utility_pub.LAST_UPDATE_DATE,

629: req_id,
630: hz_utility_pub.CREATED_BY,
631: hz_utility_pub.CREATION_DATE,
632: hz_utility_pub.LAST_UPDATE_LOGIN,
633: hz_utility_pub.LAST_UPDATE_DATE,
634: hz_utility_pub.LAST_UPDATED_BY
635: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
636: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
637: AND RACM.DUPLICATE_ADDRESS_ID = PC.SHIP_TO_ADDRESS_ID

Line 634: hz_utility_pub.LAST_UPDATED_BY

630: hz_utility_pub.CREATED_BY,
631: hz_utility_pub.CREATION_DATE,
632: hz_utility_pub.LAST_UPDATE_LOGIN,
633: hz_utility_pub.LAST_UPDATE_DATE,
634: hz_utility_pub.LAST_UPDATED_BY
635: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
636: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
637: AND RACM.DUPLICATE_ADDRESS_ID = PC.SHIP_TO_ADDRESS_ID
638: AND RACM.PROCESS_FLAG = 'N'

Line 696: hz_utility_pub.CREATED_BY,

692: PC.bill_to_customer_id,
693: RACM.CUSTOMER_ID,
694: 'U',
695: req_id,
696: hz_utility_pub.CREATED_BY,
697: hz_utility_pub.CREATION_DATE,
698: hz_utility_pub.LAST_UPDATE_LOGIN,
699: hz_utility_pub.LAST_UPDATE_DATE,
700: hz_utility_pub.LAST_UPDATED_BY

Line 697: hz_utility_pub.CREATION_DATE,

693: RACM.CUSTOMER_ID,
694: 'U',
695: req_id,
696: hz_utility_pub.CREATED_BY,
697: hz_utility_pub.CREATION_DATE,
698: hz_utility_pub.LAST_UPDATE_LOGIN,
699: hz_utility_pub.LAST_UPDATE_DATE,
700: hz_utility_pub.LAST_UPDATED_BY
701: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

Line 698: hz_utility_pub.LAST_UPDATE_LOGIN,

694: 'U',
695: req_id,
696: hz_utility_pub.CREATED_BY,
697: hz_utility_pub.CREATION_DATE,
698: hz_utility_pub.LAST_UPDATE_LOGIN,
699: hz_utility_pub.LAST_UPDATE_DATE,
700: hz_utility_pub.LAST_UPDATED_BY
701: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
702: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/

Line 699: hz_utility_pub.LAST_UPDATE_DATE,

695: req_id,
696: hz_utility_pub.CREATED_BY,
697: hz_utility_pub.CREATION_DATE,
698: hz_utility_pub.LAST_UPDATE_LOGIN,
699: hz_utility_pub.LAST_UPDATE_DATE,
700: hz_utility_pub.LAST_UPDATED_BY
701: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
702: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
703: AND RACM.PROCESS_FLAG = 'N'

Line 700: hz_utility_pub.LAST_UPDATED_BY

696: hz_utility_pub.CREATED_BY,
697: hz_utility_pub.CREATION_DATE,
698: hz_utility_pub.LAST_UPDATE_LOGIN,
699: hz_utility_pub.LAST_UPDATE_DATE,
700: hz_utility_pub.LAST_UPDATED_BY
701: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
702: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
703: AND RACM.PROCESS_FLAG = 'N'
704: AND RACM.SET_NUMBER = set_no

Line 755: hz_utility_pub.CREATED_BY,

751: PC.ship_to_customer_id,
752: RACM.CUSTOMER_ID,
753: 'U',
754: req_id,
755: hz_utility_pub.CREATED_BY,
756: hz_utility_pub.CREATION_DATE,
757: hz_utility_pub.LAST_UPDATE_LOGIN,
758: hz_utility_pub.LAST_UPDATE_DATE,
759: hz_utility_pub.LAST_UPDATED_BY

Line 756: hz_utility_pub.CREATION_DATE,

752: RACM.CUSTOMER_ID,
753: 'U',
754: req_id,
755: hz_utility_pub.CREATED_BY,
756: hz_utility_pub.CREATION_DATE,
757: hz_utility_pub.LAST_UPDATE_LOGIN,
758: hz_utility_pub.LAST_UPDATE_DATE,
759: hz_utility_pub.LAST_UPDATED_BY
760: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

Line 757: hz_utility_pub.LAST_UPDATE_LOGIN,

753: 'U',
754: req_id,
755: hz_utility_pub.CREATED_BY,
756: hz_utility_pub.CREATION_DATE,
757: hz_utility_pub.LAST_UPDATE_LOGIN,
758: hz_utility_pub.LAST_UPDATE_DATE,
759: hz_utility_pub.LAST_UPDATED_BY
760: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
761: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/

Line 758: hz_utility_pub.LAST_UPDATE_DATE,

754: req_id,
755: hz_utility_pub.CREATED_BY,
756: hz_utility_pub.CREATION_DATE,
757: hz_utility_pub.LAST_UPDATE_LOGIN,
758: hz_utility_pub.LAST_UPDATE_DATE,
759: hz_utility_pub.LAST_UPDATED_BY
760: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
761: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
762: AND RACM.PROCESS_FLAG = 'N'

Line 759: hz_utility_pub.LAST_UPDATED_BY

755: hz_utility_pub.CREATED_BY,
756: hz_utility_pub.CREATION_DATE,
757: hz_utility_pub.LAST_UPDATE_LOGIN,
758: hz_utility_pub.LAST_UPDATE_DATE,
759: hz_utility_pub.LAST_UPDATED_BY
760: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM
761: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
762: AND RACM.PROCESS_FLAG = 'N'
763: AND RACM.SET_NUMBER = set_no

Line 818: hz_utility_pub.CREATED_BY,

814: PC.customer_id,
815: RACM.CUSTOMER_ID,
816: 'U',
817: req_id,
818: hz_utility_pub.CREATED_BY,
819: hz_utility_pub.CREATION_DATE,
820: hz_utility_pub.LAST_UPDATE_LOGIN,
821: hz_utility_pub.LAST_UPDATE_DATE,
822: hz_utility_pub.LAST_UPDATED_BY

Line 819: hz_utility_pub.CREATION_DATE,

815: RACM.CUSTOMER_ID,
816: 'U',
817: req_id,
818: hz_utility_pub.CREATED_BY,
819: hz_utility_pub.CREATION_DATE,
820: hz_utility_pub.LAST_UPDATE_LOGIN,
821: hz_utility_pub.LAST_UPDATE_DATE,
822: hz_utility_pub.LAST_UPDATED_BY
823: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM

Line 820: hz_utility_pub.LAST_UPDATE_LOGIN,

816: 'U',
817: req_id,
818: hz_utility_pub.CREATED_BY,
819: hz_utility_pub.CREATION_DATE,
820: hz_utility_pub.LAST_UPDATE_LOGIN,
821: hz_utility_pub.LAST_UPDATE_DATE,
822: hz_utility_pub.LAST_UPDATED_BY
823: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
824: WHERE RACM.DUPLICATE_ID = var_customer_id

Line 821: hz_utility_pub.LAST_UPDATE_DATE,

817: req_id,
818: hz_utility_pub.CREATED_BY,
819: hz_utility_pub.CREATION_DATE,
820: hz_utility_pub.LAST_UPDATE_LOGIN,
821: hz_utility_pub.LAST_UPDATE_DATE,
822: hz_utility_pub.LAST_UPDATED_BY
823: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
824: WHERE RACM.DUPLICATE_ID = var_customer_id
825: AND RACM.PROCESS_FLAG = 'N'

Line 822: hz_utility_pub.LAST_UPDATED_BY

818: hz_utility_pub.CREATED_BY,
819: hz_utility_pub.CREATION_DATE,
820: hz_utility_pub.LAST_UPDATE_LOGIN,
821: hz_utility_pub.LAST_UPDATE_DATE,
822: hz_utility_pub.LAST_UPDATED_BY
823: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM
824: WHERE RACM.DUPLICATE_ID = var_customer_id
825: AND RACM.PROCESS_FLAG = 'N'
826: AND RACM.SET_NUMBER = set_no

Line 900: hz_utility_pub.CREATED_BY,

896: PDI.CUSTOMER_ID,
897: RACM.CUSTOMER_ID,
898: 'U',
899: req_id,
900: hz_utility_pub.CREATED_BY,
901: hz_utility_pub.CREATION_DATE,
902: hz_utility_pub.LAST_UPDATE_LOGIN,
903: hz_utility_pub.LAST_UPDATE_DATE,
904: hz_utility_pub.LAST_UPDATED_BY

Line 901: hz_utility_pub.CREATION_DATE,

897: RACM.CUSTOMER_ID,
898: 'U',
899: req_id,
900: hz_utility_pub.CREATED_BY,
901: hz_utility_pub.CREATION_DATE,
902: hz_utility_pub.LAST_UPDATE_LOGIN,
903: hz_utility_pub.LAST_UPDATE_DATE,
904: hz_utility_pub.LAST_UPDATED_BY
905: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 902: hz_utility_pub.LAST_UPDATE_LOGIN,

898: 'U',
899: req_id,
900: hz_utility_pub.CREATED_BY,
901: hz_utility_pub.CREATION_DATE,
902: hz_utility_pub.LAST_UPDATE_LOGIN,
903: hz_utility_pub.LAST_UPDATE_DATE,
904: hz_utility_pub.LAST_UPDATED_BY
905: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
906: CUSTOMER_ID,

Line 903: hz_utility_pub.LAST_UPDATE_DATE,

899: req_id,
900: hz_utility_pub.CREATED_BY,
901: hz_utility_pub.CREATION_DATE,
902: hz_utility_pub.LAST_UPDATE_LOGIN,
903: hz_utility_pub.LAST_UPDATE_DATE,
904: hz_utility_pub.LAST_UPDATED_BY
905: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
906: CUSTOMER_ID,
907: DUPLICATE_ID

Line 904: hz_utility_pub.LAST_UPDATED_BY

900: hz_utility_pub.CREATED_BY,
901: hz_utility_pub.CREATION_DATE,
902: hz_utility_pub.LAST_UPDATE_LOGIN,
903: hz_utility_pub.LAST_UPDATE_DATE,
904: hz_utility_pub.LAST_UPDATED_BY
905: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
906: CUSTOMER_ID,
907: DUPLICATE_ID
908: FROM RA_CUSTOMER_MERGES

Line 960: hz_utility_pub.CREATED_BY,

956: PDI.BILL_TO_CUSTOMER_ID,
957: RACM.CUSTOMER_ID,
958: 'U',
959: req_id,
960: hz_utility_pub.CREATED_BY,
961: hz_utility_pub.CREATION_DATE,
962: hz_utility_pub.LAST_UPDATE_LOGIN,
963: hz_utility_pub.LAST_UPDATE_DATE,
964: hz_utility_pub.LAST_UPDATED_BY

Line 961: hz_utility_pub.CREATION_DATE,

957: RACM.CUSTOMER_ID,
958: 'U',
959: req_id,
960: hz_utility_pub.CREATED_BY,
961: hz_utility_pub.CREATION_DATE,
962: hz_utility_pub.LAST_UPDATE_LOGIN,
963: hz_utility_pub.LAST_UPDATE_DATE,
964: hz_utility_pub.LAST_UPDATED_BY
965: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 962: hz_utility_pub.LAST_UPDATE_LOGIN,

958: 'U',
959: req_id,
960: hz_utility_pub.CREATED_BY,
961: hz_utility_pub.CREATION_DATE,
962: hz_utility_pub.LAST_UPDATE_LOGIN,
963: hz_utility_pub.LAST_UPDATE_DATE,
964: hz_utility_pub.LAST_UPDATED_BY
965: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
966: CUSTOMER_ID,

Line 963: hz_utility_pub.LAST_UPDATE_DATE,

959: req_id,
960: hz_utility_pub.CREATED_BY,
961: hz_utility_pub.CREATION_DATE,
962: hz_utility_pub.LAST_UPDATE_LOGIN,
963: hz_utility_pub.LAST_UPDATE_DATE,
964: hz_utility_pub.LAST_UPDATED_BY
965: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
966: CUSTOMER_ID,
967: DUPLICATE_ID

Line 964: hz_utility_pub.LAST_UPDATED_BY

960: hz_utility_pub.CREATED_BY,
961: hz_utility_pub.CREATION_DATE,
962: hz_utility_pub.LAST_UPDATE_LOGIN,
963: hz_utility_pub.LAST_UPDATE_DATE,
964: hz_utility_pub.LAST_UPDATED_BY
965: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
966: CUSTOMER_ID,
967: DUPLICATE_ID
968: FROM RA_CUSTOMER_MERGES

Line 1020: hz_utility_pub.CREATED_BY,

1016: PDI.SHIP_TO_CUSTOMER_ID,
1017: RACM.CUSTOMER_ID,
1018: 'U',
1019: req_id,
1020: hz_utility_pub.CREATED_BY,
1021: hz_utility_pub.CREATION_DATE,
1022: hz_utility_pub.LAST_UPDATE_LOGIN,
1023: hz_utility_pub.LAST_UPDATE_DATE,
1024: hz_utility_pub.LAST_UPDATED_BY

Line 1021: hz_utility_pub.CREATION_DATE,

1017: RACM.CUSTOMER_ID,
1018: 'U',
1019: req_id,
1020: hz_utility_pub.CREATED_BY,
1021: hz_utility_pub.CREATION_DATE,
1022: hz_utility_pub.LAST_UPDATE_LOGIN,
1023: hz_utility_pub.LAST_UPDATE_DATE,
1024: hz_utility_pub.LAST_UPDATED_BY
1025: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1022: hz_utility_pub.LAST_UPDATE_LOGIN,

1018: 'U',
1019: req_id,
1020: hz_utility_pub.CREATED_BY,
1021: hz_utility_pub.CREATION_DATE,
1022: hz_utility_pub.LAST_UPDATE_LOGIN,
1023: hz_utility_pub.LAST_UPDATE_DATE,
1024: hz_utility_pub.LAST_UPDATED_BY
1025: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1026: CUSTOMER_ID,

Line 1023: hz_utility_pub.LAST_UPDATE_DATE,

1019: req_id,
1020: hz_utility_pub.CREATED_BY,
1021: hz_utility_pub.CREATION_DATE,
1022: hz_utility_pub.LAST_UPDATE_LOGIN,
1023: hz_utility_pub.LAST_UPDATE_DATE,
1024: hz_utility_pub.LAST_UPDATED_BY
1025: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1026: CUSTOMER_ID,
1027: DUPLICATE_ID

Line 1024: hz_utility_pub.LAST_UPDATED_BY

1020: hz_utility_pub.CREATED_BY,
1021: hz_utility_pub.CREATION_DATE,
1022: hz_utility_pub.LAST_UPDATE_LOGIN,
1023: hz_utility_pub.LAST_UPDATE_DATE,
1024: hz_utility_pub.LAST_UPDATED_BY
1025: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1026: CUSTOMER_ID,
1027: DUPLICATE_ID
1028: FROM RA_CUSTOMER_MERGES

Line 1081: hz_utility_pub.CREATED_BY,

1077: PDI.BILL_TO_ADDRESS_ID,
1078: RACM.CUSTOMER_ADDRESS_ID,
1079: 'U',
1080: req_id,
1081: hz_utility_pub.CREATED_BY,
1082: hz_utility_pub.CREATION_DATE,
1083: hz_utility_pub.LAST_UPDATE_LOGIN,
1084: hz_utility_pub.LAST_UPDATE_DATE,
1085: hz_utility_pub.LAST_UPDATED_BY

Line 1082: hz_utility_pub.CREATION_DATE,

1078: RACM.CUSTOMER_ADDRESS_ID,
1079: 'U',
1080: req_id,
1081: hz_utility_pub.CREATED_BY,
1082: hz_utility_pub.CREATION_DATE,
1083: hz_utility_pub.LAST_UPDATE_LOGIN,
1084: hz_utility_pub.LAST_UPDATE_DATE,
1085: hz_utility_pub.LAST_UPDATED_BY
1086: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

Line 1083: hz_utility_pub.LAST_UPDATE_LOGIN,

1079: 'U',
1080: req_id,
1081: hz_utility_pub.CREATED_BY,
1082: hz_utility_pub.CREATION_DATE,
1083: hz_utility_pub.LAST_UPDATE_LOGIN,
1084: hz_utility_pub.LAST_UPDATE_DATE,
1085: hz_utility_pub.LAST_UPDATED_BY
1086: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1087: WHERE

Line 1084: hz_utility_pub.LAST_UPDATE_DATE,

1080: req_id,
1081: hz_utility_pub.CREATED_BY,
1082: hz_utility_pub.CREATION_DATE,
1083: hz_utility_pub.LAST_UPDATE_LOGIN,
1084: hz_utility_pub.LAST_UPDATE_DATE,
1085: hz_utility_pub.LAST_UPDATED_BY
1086: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1087: WHERE
1088: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID

Line 1085: hz_utility_pub.LAST_UPDATED_BY

1081: hz_utility_pub.CREATED_BY,
1082: hz_utility_pub.CREATION_DATE,
1083: hz_utility_pub.LAST_UPDATE_LOGIN,
1084: hz_utility_pub.LAST_UPDATE_DATE,
1085: hz_utility_pub.LAST_UPDATED_BY
1086: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1087: WHERE
1088: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID
1089: AND RACM.PROCESS_FLAG = 'N'

Line 1142: hz_utility_pub.CREATED_BY,

1138: PDI.SHIP_TO_ADDRESS_ID,
1139: RACM.CUSTOMER_ADDRESS_ID,
1140: 'U',
1141: req_id,
1142: hz_utility_pub.CREATED_BY,
1143: hz_utility_pub.CREATION_DATE,
1144: hz_utility_pub.LAST_UPDATE_LOGIN,
1145: hz_utility_pub.LAST_UPDATE_DATE,
1146: hz_utility_pub.LAST_UPDATED_BY

Line 1143: hz_utility_pub.CREATION_DATE,

1139: RACM.CUSTOMER_ADDRESS_ID,
1140: 'U',
1141: req_id,
1142: hz_utility_pub.CREATED_BY,
1143: hz_utility_pub.CREATION_DATE,
1144: hz_utility_pub.LAST_UPDATE_LOGIN,
1145: hz_utility_pub.LAST_UPDATE_DATE,
1146: hz_utility_pub.LAST_UPDATED_BY
1147: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

Line 1144: hz_utility_pub.LAST_UPDATE_LOGIN,

1140: 'U',
1141: req_id,
1142: hz_utility_pub.CREATED_BY,
1143: hz_utility_pub.CREATION_DATE,
1144: hz_utility_pub.LAST_UPDATE_LOGIN,
1145: hz_utility_pub.LAST_UPDATE_DATE,
1146: hz_utility_pub.LAST_UPDATED_BY
1147: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1148: WHERE

Line 1145: hz_utility_pub.LAST_UPDATE_DATE,

1141: req_id,
1142: hz_utility_pub.CREATED_BY,
1143: hz_utility_pub.CREATION_DATE,
1144: hz_utility_pub.LAST_UPDATE_LOGIN,
1145: hz_utility_pub.LAST_UPDATE_DATE,
1146: hz_utility_pub.LAST_UPDATED_BY
1147: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1148: WHERE
1149: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID

Line 1146: hz_utility_pub.LAST_UPDATED_BY

1142: hz_utility_pub.CREATED_BY,
1143: hz_utility_pub.CREATION_DATE,
1144: hz_utility_pub.LAST_UPDATE_LOGIN,
1145: hz_utility_pub.LAST_UPDATE_DATE,
1146: hz_utility_pub.LAST_UPDATED_BY
1147: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1148: WHERE
1149: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID
1150: AND RACM.PROCESS_FLAG = 'N'

Line 1208: hz_utility_pub.CREATED_BY,

1204: PDII.ship_to_address_id,
1205: RACM.CUSTOMER_ADDRESS_ID,
1206: 'U',
1207: req_id,
1208: hz_utility_pub.CREATED_BY,
1209: hz_utility_pub.CREATION_DATE,
1210: hz_utility_pub.LAST_UPDATE_LOGIN,
1211: hz_utility_pub.LAST_UPDATE_DATE,
1212: hz_utility_pub.LAST_UPDATED_BY

Line 1209: hz_utility_pub.CREATION_DATE,

1205: RACM.CUSTOMER_ADDRESS_ID,
1206: 'U',
1207: req_id,
1208: hz_utility_pub.CREATED_BY,
1209: hz_utility_pub.CREATION_DATE,
1210: hz_utility_pub.LAST_UPDATE_LOGIN,
1211: hz_utility_pub.LAST_UPDATE_DATE,
1212: hz_utility_pub.LAST_UPDATED_BY
1213: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM

Line 1210: hz_utility_pub.LAST_UPDATE_LOGIN,

1206: 'U',
1207: req_id,
1208: hz_utility_pub.CREATED_BY,
1209: hz_utility_pub.CREATION_DATE,
1210: hz_utility_pub.LAST_UPDATE_LOGIN,
1211: hz_utility_pub.LAST_UPDATE_DATE,
1212: hz_utility_pub.LAST_UPDATED_BY
1213: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM
1214: WHERE RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID

Line 1211: hz_utility_pub.LAST_UPDATE_DATE,

1207: req_id,
1208: hz_utility_pub.CREATED_BY,
1209: hz_utility_pub.CREATION_DATE,
1210: hz_utility_pub.LAST_UPDATE_LOGIN,
1211: hz_utility_pub.LAST_UPDATE_DATE,
1212: hz_utility_pub.LAST_UPDATED_BY
1213: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM
1214: WHERE RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID
1215: AND RACM.PROCESS_FLAG = 'N'

Line 1212: hz_utility_pub.LAST_UPDATED_BY

1208: hz_utility_pub.CREATED_BY,
1209: hz_utility_pub.CREATION_DATE,
1210: hz_utility_pub.LAST_UPDATE_LOGIN,
1211: hz_utility_pub.LAST_UPDATE_DATE,
1212: hz_utility_pub.LAST_UPDATED_BY
1213: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM
1214: WHERE RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID
1215: AND RACM.PROCESS_FLAG = 'N'
1216: AND RACM.SET_NUMBER = set_no

Line 1281: hz_utility_pub.CREATED_BY,

1277: PT.Customer_ID,
1278: New_customer_ID,
1279: 'U',
1280: req_id,
1281: hz_utility_pub.CREATED_BY,
1282: hz_utility_pub.CREATION_DATE,
1283: hz_utility_pub.LAST_UPDATE_LOGIN,
1284: hz_utility_pub.LAST_UPDATE_DATE,
1285: hz_utility_pub.LAST_UPDATED_BY

Line 1282: hz_utility_pub.CREATION_DATE,

1278: New_customer_ID,
1279: 'U',
1280: req_id,
1281: hz_utility_pub.CREATED_BY,
1282: hz_utility_pub.CREATION_DATE,
1283: hz_utility_pub.LAST_UPDATE_LOGIN,
1284: hz_utility_pub.LAST_UPDATE_DATE,
1285: hz_utility_pub.LAST_UPDATED_BY
1286: FROM PA_TASKS PT, ra_customer_merges RACM

Line 1283: hz_utility_pub.LAST_UPDATE_LOGIN,

1279: 'U',
1280: req_id,
1281: hz_utility_pub.CREATED_BY,
1282: hz_utility_pub.CREATION_DATE,
1283: hz_utility_pub.LAST_UPDATE_LOGIN,
1284: hz_utility_pub.LAST_UPDATE_DATE,
1285: hz_utility_pub.LAST_UPDATED_BY
1286: FROM PA_TASKS PT, ra_customer_merges RACM
1287: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID

Line 1284: hz_utility_pub.LAST_UPDATE_DATE,

1280: req_id,
1281: hz_utility_pub.CREATED_BY,
1282: hz_utility_pub.CREATION_DATE,
1283: hz_utility_pub.LAST_UPDATE_LOGIN,
1284: hz_utility_pub.LAST_UPDATE_DATE,
1285: hz_utility_pub.LAST_UPDATED_BY
1286: FROM PA_TASKS PT, ra_customer_merges RACM
1287: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1288: AND RACM.PROCESS_FLAG = 'N'

Line 1285: hz_utility_pub.LAST_UPDATED_BY

1281: hz_utility_pub.CREATED_BY,
1282: hz_utility_pub.CREATION_DATE,
1283: hz_utility_pub.LAST_UPDATE_LOGIN,
1284: hz_utility_pub.LAST_UPDATE_DATE,
1285: hz_utility_pub.LAST_UPDATED_BY
1286: FROM PA_TASKS PT, ra_customer_merges RACM
1287: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1288: AND RACM.PROCESS_FLAG = 'N'
1289: AND RACM.SET_NUMBER = set_no

Line 1348: hz_utility_pub.CREATED_BY,

1344: PI.CUSTOMER_ID,
1345: RACM.CUSTOMER_ID,
1346: 'U',
1347: req_id,
1348: hz_utility_pub.CREATED_BY,
1349: hz_utility_pub.CREATION_DATE,
1350: hz_utility_pub.LAST_UPDATE_LOGIN,
1351: hz_utility_pub.LAST_UPDATE_DATE,
1352: hz_utility_pub.LAST_UPDATED_BY

Line 1349: hz_utility_pub.CREATION_DATE,

1345: RACM.CUSTOMER_ID,
1346: 'U',
1347: req_id,
1348: hz_utility_pub.CREATED_BY,
1349: hz_utility_pub.CREATION_DATE,
1350: hz_utility_pub.LAST_UPDATE_LOGIN,
1351: hz_utility_pub.LAST_UPDATE_DATE,
1352: hz_utility_pub.LAST_UPDATED_BY
1353: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1350: hz_utility_pub.LAST_UPDATE_LOGIN,

1346: 'U',
1347: req_id,
1348: hz_utility_pub.CREATED_BY,
1349: hz_utility_pub.CREATION_DATE,
1350: hz_utility_pub.LAST_UPDATE_LOGIN,
1351: hz_utility_pub.LAST_UPDATE_DATE,
1352: hz_utility_pub.LAST_UPDATED_BY
1353: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1354: CUSTOMER_ID,

Line 1351: hz_utility_pub.LAST_UPDATE_DATE,

1347: req_id,
1348: hz_utility_pub.CREATED_BY,
1349: hz_utility_pub.CREATION_DATE,
1350: hz_utility_pub.LAST_UPDATE_LOGIN,
1351: hz_utility_pub.LAST_UPDATE_DATE,
1352: hz_utility_pub.LAST_UPDATED_BY
1353: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1354: CUSTOMER_ID,
1355: DUPLICATE_ID

Line 1352: hz_utility_pub.LAST_UPDATED_BY

1348: hz_utility_pub.CREATED_BY,
1349: hz_utility_pub.CREATION_DATE,
1350: hz_utility_pub.LAST_UPDATE_LOGIN,
1351: hz_utility_pub.LAST_UPDATE_DATE,
1352: hz_utility_pub.LAST_UPDATED_BY
1353: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1354: CUSTOMER_ID,
1355: DUPLICATE_ID
1356: FROM RA_CUSTOMER_MERGES

Line 1419: hz_utility_pub.CREATED_BY,

1415: PR.CUSTOMER_ID,
1416: RACM.CUSTOMER_ID,
1417: 'U',
1418: req_id,
1419: hz_utility_pub.CREATED_BY,
1420: hz_utility_pub.CREATION_DATE,
1421: hz_utility_pub.LAST_UPDATE_LOGIN,
1422: hz_utility_pub.LAST_UPDATE_DATE,
1423: hz_utility_pub.LAST_UPDATED_BY

Line 1420: hz_utility_pub.CREATION_DATE,

1416: RACM.CUSTOMER_ID,
1417: 'U',
1418: req_id,
1419: hz_utility_pub.CREATED_BY,
1420: hz_utility_pub.CREATION_DATE,
1421: hz_utility_pub.LAST_UPDATE_LOGIN,
1422: hz_utility_pub.LAST_UPDATE_DATE,
1423: hz_utility_pub.LAST_UPDATED_BY
1424: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1421: hz_utility_pub.LAST_UPDATE_LOGIN,

1417: 'U',
1418: req_id,
1419: hz_utility_pub.CREATED_BY,
1420: hz_utility_pub.CREATION_DATE,
1421: hz_utility_pub.LAST_UPDATE_LOGIN,
1422: hz_utility_pub.LAST_UPDATE_DATE,
1423: hz_utility_pub.LAST_UPDATED_BY
1424: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1425: CUSTOMER_ID,

Line 1422: hz_utility_pub.LAST_UPDATE_DATE,

1418: req_id,
1419: hz_utility_pub.CREATED_BY,
1420: hz_utility_pub.CREATION_DATE,
1421: hz_utility_pub.LAST_UPDATE_LOGIN,
1422: hz_utility_pub.LAST_UPDATE_DATE,
1423: hz_utility_pub.LAST_UPDATED_BY
1424: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1425: CUSTOMER_ID,
1426: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

Line 1423: hz_utility_pub.LAST_UPDATED_BY

1419: hz_utility_pub.CREATED_BY,
1420: hz_utility_pub.CREATION_DATE,
1421: hz_utility_pub.LAST_UPDATE_LOGIN,
1422: hz_utility_pub.LAST_UPDATE_DATE,
1423: hz_utility_pub.LAST_UPDATED_BY
1424: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1425: CUSTOMER_ID,
1426: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1427: WHERE PROCESS_FLAG = 'N'

Line 1497: hz_utility_pub.CREATED_BY,

1493: PB.CUSTOMER_ID,
1494: RACM.CUSTOMER_ID,
1495: 'U',
1496: req_id,
1497: hz_utility_pub.CREATED_BY,
1498: hz_utility_pub.CREATION_DATE,
1499: hz_utility_pub.LAST_UPDATE_LOGIN,
1500: hz_utility_pub.LAST_UPDATE_DATE,
1501: hz_utility_pub.LAST_UPDATED_BY

Line 1498: hz_utility_pub.CREATION_DATE,

1494: RACM.CUSTOMER_ID,
1495: 'U',
1496: req_id,
1497: hz_utility_pub.CREATED_BY,
1498: hz_utility_pub.CREATION_DATE,
1499: hz_utility_pub.LAST_UPDATE_LOGIN,
1500: hz_utility_pub.LAST_UPDATE_DATE,
1501: hz_utility_pub.LAST_UPDATED_BY
1502: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1499: hz_utility_pub.LAST_UPDATE_LOGIN,

1495: 'U',
1496: req_id,
1497: hz_utility_pub.CREATED_BY,
1498: hz_utility_pub.CREATION_DATE,
1499: hz_utility_pub.LAST_UPDATE_LOGIN,
1500: hz_utility_pub.LAST_UPDATE_DATE,
1501: hz_utility_pub.LAST_UPDATED_BY
1502: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1503: CUSTOMER_ID,

Line 1500: hz_utility_pub.LAST_UPDATE_DATE,

1496: req_id,
1497: hz_utility_pub.CREATED_BY,
1498: hz_utility_pub.CREATION_DATE,
1499: hz_utility_pub.LAST_UPDATE_LOGIN,
1500: hz_utility_pub.LAST_UPDATE_DATE,
1501: hz_utility_pub.LAST_UPDATED_BY
1502: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1503: CUSTOMER_ID,
1504: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

Line 1501: hz_utility_pub.LAST_UPDATED_BY

1497: hz_utility_pub.CREATED_BY,
1498: hz_utility_pub.CREATION_DATE,
1499: hz_utility_pub.LAST_UPDATE_LOGIN,
1500: hz_utility_pub.LAST_UPDATE_DATE,
1501: hz_utility_pub.LAST_UPDATED_BY
1502: FROM PA_PROJ_RETN_BILL_RULES PB,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1503: CUSTOMER_ID,
1504: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1505: WHERE PROCESS_FLAG ='N'

Line 1579: hz_utility_pub.CREATED_BY,

1575: PS.CUSTOMER_ID,
1576: RACM.CUSTOMER_ID,
1577: 'U',
1578: req_id,
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY

Line 1580: hz_utility_pub.CREATION_DATE,

1576: RACM.CUSTOMER_ID,
1577: 'U',
1578: req_id,
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY
1584: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

Line 1581: hz_utility_pub.LAST_UPDATE_LOGIN,

1577: 'U',
1578: req_id,
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY
1584: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1585: CUSTOMER_ID,

Line 1582: hz_utility_pub.LAST_UPDATE_DATE,

1578: req_id,
1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY
1584: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1585: CUSTOMER_ID,
1586: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

Line 1583: hz_utility_pub.LAST_UPDATED_BY

1579: hz_utility_pub.CREATED_BY,
1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY
1584: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1585: CUSTOMER_ID,
1586: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1587: WHERE PROCESS_FLAG = 'N'