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.

APPS.PAP_CMERGE dependencies on RA_CUSTOMER_MERGES

Line 13: FROM RA_CUSTOMER_MERGES RACM

9: BEGIN
10: --
11: SELECT DISTINCT RACM.CUSTOMER_ID, RACM.DUPLICATE_ID INTO new_customer_id,
12: old_customer_id
13: FROM RA_CUSTOMER_MERGES RACM
14: WHERE RACM.DUPLICATE_ID = var_customer_id
15: AND RACM.PROCESS_FLAG = 'N'
16: AND RACM.SET_NUMBER = set_no;
17: --

Line 51: FROM pa_project_customers PA,RA_CUSTOMER_MERGES RACM

47: PROCEDURE MERGE ( req_id IN NUMBER, set_no IN NUMBER, process_mode IN VARCHAR2 ) IS
48: --
49: /* CURSOR cursor_1 IS SELECT DISTINCT PA.PROJECT_ID, PA.CUSTOMER_ID, PA.BILL_TO_ADDRESS_ID,
50: PA.SHIP_TO_ADDRESS_ID,PA.BILL_TO_CUSTOMER_ID,PA.SHIP_TO_CUSTOMER_ID, DEFAULT_TOP_TASK_CUST_FLAG -- FP_M Changes
51: FROM pa_project_customers PA,RA_CUSTOMER_MERGES RACM
52: WHERE RACM.PROCESS_FLAG = 'N'
53: AND RACM.SET_NUMBER = set_no
54: AND (PA.CUSTOMER_ID=RACM.DUPLICATE_ID
55: OR PA.BILL_TO_CUSTOMER_ID=RACM.DUPLICATE_ID

Line 67: SELECT 1 FROM RA_CUSTOMER_MERGES RACM

63: CURSOR cursor_1 IS SELECT PA.PROJECT_ID, PA.CUSTOMER_ID, PA.BILL_TO_ADDRESS_ID,
64: PA.SHIP_TO_ADDRESS_ID,PA.BILL_TO_CUSTOMER_ID,PA.SHIP_TO_CUSTOMER_ID , DEFAULT_TOP_TASK_CUST_FLAG -- FP_M Changes
65: FROM pa_project_customers PA
66: WHERE EXISTS (
67: SELECT 1 FROM RA_CUSTOMER_MERGES RACM
68: WHERE RACM.PROCESS_FLAG = 'N'
69: AND RACM.SET_NUMBER = set_no
70: AND RACM.request_id = req_id
71: AND (PA.CUSTOMER_ID=RACM.DUPLICATE_ID

Line 79: FROM RA_CUSTOMER_MERGES

75: WHERE PROJECT_ID = PA.PROJECT_ID );
76:
77: /* Bug 3891382. Added the cursor to select the delete_duplicate_flag */
78: CURSOR cursor_2 IS SELECT DUPLICATE_ID,DELETE_DUPLICATE_FLAG,CUSTOMER_ID /* for bug 6732730*/
79: FROM RA_CUSTOMER_MERGES
80: WHERE PROCESS_FLAG = 'N'
81: AND SET_NUMBER = set_no;
82: --
83: CURSOR cursor_lock_1 IS

Line 87: FROM RA_CUSTOMER_MERGES RACM

83: CURSOR cursor_lock_1 IS
84: SELECT CUSTOMER_ID FROM pa_project_customers PC
85: WHERE
86: PC.CUSTOMER_ID IN ( SELECT DISTINCT RACM.DUPLICATE_ID
87: FROM RA_CUSTOMER_MERGES RACM
88: WHERE RACM.PROCESS_FLAG = 'N'
89: AND RACM.SET_NUMBER = set_no )
90: FOR UPDATE NOWAIT;
91: --

Line 96: FROM RA_CUSTOMER_MERGES RACM

92: CURSOR cursor_lock_2 IS
93: SELECT SHIP_TO_ADDRESS_ID FROM pa_draft_invoice_items PDII
94: WHERE
95: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
96: FROM RA_CUSTOMER_MERGES RACM
97: WHERE RACM.PROCESS_FLAG = 'N'
98: AND RACM.SET_NUMBER = set_no
99: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )
100: FOR UPDATE NOWAIT;

Line 106: FROM RA_CUSTOMER_MERGES RACM

102: CURSOR cursor_lock_3 IS
103: SELECT ADDRESS_ID FROM pa_tasks PT
104: WHERE
105: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
106: FROM RA_CUSTOMER_MERGES RACM
107: WHERE RACM.PROCESS_FLAG = 'N'
108: AND RACM.SET_NUMBER = set_no
109: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )
110: FOR UPDATE NOWAIT;

Line 116: FROM RA_CUSTOMER_MERGES RACM

112: CURSOR cursor_lock_4 IS
113: SELECT CUSTOMER_ID FROM pa_project_contacts PC
114: WHERE
115: PC.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
116: FROM RA_CUSTOMER_MERGES RACM
117: WHERE RACM.PROCESS_FLAG = 'N'
118: AND RACM.SET_NUMBER = set_no )
119: FOR UPDATE NOWAIT;
120: --

Line 125: FROM RA_CUSTOMER_MERGES RACM

121: CURSOR cursor_lock_5 IS
122: SELECT CUSTOMER_ID FROM pa_agreements PA
123: WHERE
124: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
125: FROM RA_CUSTOMER_MERGES RACM
126: WHERE RACM.PROCESS_FLAG = 'N'
127: AND RACM.SET_NUMBER = set_no )
128: FOR UPDATE NOWAIT;
129: --

Line 134: FROM RA_CUSTOMER_MERGES RACM

130: CURSOR cursor_lock_6 IS
131: SELECT CUSTOMER_ID FROM pa_implementations PA -- bug 3891382
132: WHERE
133: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
134: FROM RA_CUSTOMER_MERGES RACM
135: WHERE RACM.PROCESS_FLAG = 'N'
136: AND RACM.SET_NUMBER = set_no )
137: FOR UPDATE NOWAIT;
138: --

Line 143: FROM RA_CUSTOMER_MERGES RACM

139: CURSOR cursor_lock_7 IS
140: SELECT CUSTOMER_ID FROM pa_proj_retn_rules PA
141: WHERE
142: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
143: FROM RA_CUSTOMER_MERGES RACM
144: WHERE RACM.PROCESS_FLAG = 'N'
145: AND RACM.SET_NUMBER = set_no )
146: FOR UPDATE NOWAIT;
147: --

Line 152: FROM RA_CUSTOMER_MERGES RACM

148: CURSOR cursor_lock_8 IS
149: SELECT CUSTOMER_ID FROM pa_proj_retn_bill_rules PA
150: WHERE
151: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
152: FROM RA_CUSTOMER_MERGES RACM
153: WHERE RACM.PROCESS_FLAG = 'N'
154: AND RACM.SET_NUMBER = set_no )
155: FOR UPDATE NOWAIT;
156: --

Line 161: FROM RA_CUSTOMER_MERGES RACM

157: CURSOR cursor_lock_9 IS
158: SELECT CUSTOMER_ID FROM pa_summary_project_retn PA
159: WHERE
160: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
161: FROM RA_CUSTOMER_MERGES RACM
162: WHERE RACM.PROCESS_FLAG = 'N'
163: AND RACM.SET_NUMBER = set_no )
164: FOR UPDATE NOWAIT;
165: --

Line 176: var_dup_id ra_customer_merges.duplicate_id%TYPE;

172: records_locked EXCEPTION;
173: total_record_upd_count NUMBER := 0;
174: total_record_del_count NUMBER := 0;
175: PRAGMA EXCEPTION_INIT( records_locked, -00054 );
176: var_dup_id ra_customer_merges.duplicate_id%TYPE;
177: var_dup_flag ra_customer_merges.delete_duplicate_flag%TYPE;
178: var_count1 NUMBER := 0;
179: var_count2 NUMBER := 0;
180: /* Begin for Bug 6732730 */

Line 177: var_dup_flag ra_customer_merges.delete_duplicate_flag%TYPE;

173: total_record_upd_count NUMBER := 0;
174: total_record_del_count NUMBER := 0;
175: PRAGMA EXCEPTION_INIT( records_locked, -00054 );
176: var_dup_id ra_customer_merges.duplicate_id%TYPE;
177: var_dup_flag ra_customer_merges.delete_duplicate_flag%TYPE;
178: var_count1 NUMBER := 0;
179: var_count2 NUMBER := 0;
180: /* Begin for Bug 6732730 */
181: var_cust_id ra_customer_merges.customer_id%TYPE; /* Modified to var_cust_id for bug 7341412 */

Line 181: var_cust_id ra_customer_merges.customer_id%TYPE; /* Modified to var_cust_id for bug 7341412 */

177: var_dup_flag ra_customer_merges.delete_duplicate_flag%TYPE;
178: var_count1 NUMBER := 0;
179: var_count2 NUMBER := 0;
180: /* Begin for Bug 6732730 */
181: var_cust_id ra_customer_merges.customer_id%TYPE; /* Modified to var_cust_id for bug 7341412 */
182: /* End for Bug 6732730 */
183:
184: /* */
185: BEGIN

Line 443: FROM PA_PROJECT_CUSTOMERS pc,ra_customer_merges RACM

439: ,PC.RETENTION_LEVEL_CODE
440: ,PC.BILL_TO_CUSTOMER_ID
441: ,PC.SHIP_TO_CUSTOMER_ID
442: ,PC.Default_Top_Task_Cust_Flag -- FP_M Changes
443: FROM PA_PROJECT_CUSTOMERS pc,ra_customer_merges RACM
444: WHERE RACM.DUPLICATE_ID = var_customer_id
445: AND PC.PROJECT_ID=var_project_id
446: AND PC.CUSTOMER_ID = var_customer_id
447: AND RACM.PROCESS_FLAG = 'N'

Line 496: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM

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
500: AND RACM.PROCESS_FLAG = 'N'

Line 568: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

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'
572: AND RACM.SET_NUMBER = set_no

Line 582: FROM RA_CUSTOMER_MERGES RACM

578: /* End of TCA audit*/
579:
580: UPDATE pa_project_customers PC
581: SET ( BILL_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
582: FROM RA_CUSTOMER_MERGES RACM
583: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
584: AND RACM.DUPLICATE_ADDRESS_ID = PC.BILL_TO_ADDRESS_ID
585: AND RACM.PROCESS_FLAG = 'N'
586: AND RACM.SET_NUMBER = set_no

Line 593: FROM RA_CUSTOMER_MERGES RACM

589: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
590: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
591: WHERE
592: PC.BILL_TO_ADDRESS_ID IN ( SELECT DISTINCT RACM.DUPLICATE_ADDRESS_ID
593: FROM RA_CUSTOMER_MERGES RACM
594: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
595: AND RACM.PROCESS_FLAG = 'N'
596: AND RACM.SET_NUMBER = set_no
597: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' )

Line 635: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

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'
639: AND RACM.SET_NUMBER = set_no

Line 648: FROM RA_CUSTOMER_MERGES RACM

644: END IF;
645:
646: UPDATE pa_project_customers PC
647: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
648: FROM RA_CUSTOMER_MERGES RACM
649: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
650: AND RACM.DUPLICATE_ADDRESS_ID = PC.SHIP_TO_ADDRESS_ID
651: AND RACM.PROCESS_FLAG = 'N'
652: AND RACM.SET_NUMBER = set_no

Line 659: FROM RA_CUSTOMER_MERGES RACM

655: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
656: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
657: WHERE
658: PC.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
659: FROM RA_CUSTOMER_MERGES RACM
660: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
661: AND RACM.PROCESS_FLAG = 'N'
662: AND RACM.SET_NUMBER = set_no
663: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )

Line 701: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

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
705: AND PC.PROJECT_ID = var_project_id

Line 713: FROM RA_CUSTOMER_MERGES RACM

709: END IF;
710:
711: UPDATE pa_project_customers PC
712: SET ( BILL_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
713: FROM RA_CUSTOMER_MERGES RACM
714: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id
715: AND RACM.PROCESS_FLAG = 'N'
716: AND RACM.SET_NUMBER = set_no ),
717: LAST_UPDATE_DATE = SYSDATE,

Line 721: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

717: LAST_UPDATE_DATE = SYSDATE,
718: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
719: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
720: WHERE
721: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
722: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
723: AND RACM.PROCESS_FLAG = 'N'
724: AND RACM.SET_NUMBER = set_no )
725: AND PC.PROJECT_ID = var_project_id

Line 760: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

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
764: AND PC.PROJECT_ID = var_project_id

Line 772: FROM RA_CUSTOMER_MERGES RACM

768: END IF;
769:
770: UPDATE pa_project_customers PC
771: SET ( SHIP_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
772: FROM RA_CUSTOMER_MERGES RACM
773: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id
774: AND RACM.PROCESS_FLAG = 'N'
775: AND RACM.SET_NUMBER = set_no ),
776: LAST_UPDATE_DATE = SYSDATE,

Line 780: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

776: LAST_UPDATE_DATE = SYSDATE,
777: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
778: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
779: WHERE
780: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
781: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
782: AND RACM.PROCESS_FLAG = 'N'
783: AND RACM.SET_NUMBER = set_no )
784: AND PC.PROJECT_ID = var_project_id

Line 823: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM

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
827: AND PC.PROJECT_ID = var_project_id

Line 835: FROM RA_CUSTOMER_MERGES RACM

831:
832: END IF;
833: UPDATE pa_project_customers PC
834: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
835: FROM RA_CUSTOMER_MERGES RACM
836: WHERE RACM.DUPLICATE_ID = var_customer_id
837: AND RACM.PROCESS_FLAG = 'N'
838: AND RACM.SET_NUMBER = set_no ),
839: LAST_UPDATE_DATE = SYSDATE,

Line 843: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

839: LAST_UPDATE_DATE = SYSDATE,
840: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
841: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
842: WHERE
843: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
844: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
845: AND RACM.PROCESS_FLAG = 'N'
846: AND RACM.SET_NUMBER = set_no )
847: AND PC.PROJECT_ID = var_project_id

Line 908: FROM RA_CUSTOMER_MERGES

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
909: WHERE PROCESS_FLAG = 'N'
910: AND SET_NUMBER = set_no
911: AND CUSTOMER_ID<>DUPLICATE_ID ) RACM
912: WHERE

Line 920: FROM RA_CUSTOMER_MERGES RACM

916: END IF;
917:
918: UPDATE pa_draft_invoices PC -- bug 3891382
919: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
920: FROM RA_CUSTOMER_MERGES RACM
921: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
922: AND RACM.PROCESS_FLAG = 'N'
923: AND RACM.SET_NUMBER = set_no ),
924: LAST_UPDATE_DATE = SYSDATE,

Line 928: PC.CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM

924: LAST_UPDATE_DATE = SYSDATE,
925: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
926: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
927: WHERE
928: PC.CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
929: WHERE RACM.PROCESS_FLAG = 'N'
930: AND RACM.SET_NUMBER = set_no );
931:
932: IF g_audit_profile='Y' THEN

Line 968: FROM RA_CUSTOMER_MERGES

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
969: WHERE PROCESS_FLAG = 'N'
970: AND SET_NUMBER = set_no
971: AND CUSTOMER_ID<>DUPLICATE_ID ) RACM
972: WHERE

Line 980: FROM RA_CUSTOMER_MERGES RACM

976: END IF;
977:
978: UPDATE pa_draft_invoices PC -- bug 3891382
979: SET ( BILL_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
980: FROM RA_CUSTOMER_MERGES RACM
981: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
982: AND RACM.PROCESS_FLAG = 'N'
983: AND RACM.SET_NUMBER = set_no ),
984: LAST_UPDATE_DATE = SYSDATE,

Line 988: PC.BILL_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM

984: LAST_UPDATE_DATE = SYSDATE,
985: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
986: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
987: WHERE
988: PC.BILL_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
989: WHERE RACM.PROCESS_FLAG = 'N'
990: AND RACM.SET_NUMBER = set_no );
991:
992: IF g_audit_profile='Y' THEN

Line 1028: FROM RA_CUSTOMER_MERGES

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
1029: WHERE PROCESS_FLAG = 'N'
1030: AND SET_NUMBER = set_no
1031: AND CUSTOMER_ID<>DUPLICATE_ID ) RACM
1032: WHERE

Line 1040: FROM RA_CUSTOMER_MERGES RACM

1036: END IF;
1037:
1038: UPDATE pa_draft_invoices PC -- bug 3891382
1039: SET ( SHIP_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1040: FROM RA_CUSTOMER_MERGES RACM
1041: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
1042: AND RACM.PROCESS_FLAG = 'N'
1043: AND RACM.SET_NUMBER = set_no ),
1044: LAST_UPDATE_DATE = SYSDATE,

Line 1048: PC.SHIP_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM

1044: LAST_UPDATE_DATE = SYSDATE,
1045: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1046: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1047: WHERE
1048: PC.SHIP_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1049: WHERE RACM.PROCESS_FLAG = 'N'
1050: AND RACM.SET_NUMBER = set_no );
1051:
1052:

Line 1086: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

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'
1090: AND RACM.SET_NUMBER = set_no

Line 1098: FROM RA_CUSTOMER_MERGES RACM

1094: END IF;
1095:
1096: UPDATE pa_draft_invoices PDI -- bug 3891382
1097: SET ( BILL_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1098: FROM RA_CUSTOMER_MERGES RACM
1099: WHERE
1100: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID
1101: AND RACM.PROCESS_FLAG = 'N'
1102: AND RACM.SET_NUMBER = set_no

Line 1109: FROM RA_CUSTOMER_MERGES RACM

1105: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1106: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1107: WHERE
1108: PDI.BILL_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1109: FROM RA_CUSTOMER_MERGES RACM
1110: WHERE RACM.PROCESS_FLAG = 'N'
1111: AND RACM.SET_NUMBER = set_no
1112: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' );
1113:

Line 1147: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

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'
1151: AND RACM.SET_NUMBER = set_no

Line 1159: FROM RA_CUSTOMER_MERGES RACM

1155: END IF;
1156:
1157: UPDATE pa_draft_invoices PDI -- bug 3891382
1158: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1159: FROM RA_CUSTOMER_MERGES RACM
1160: WHERE
1161: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID
1162: AND RACM.PROCESS_FLAG = 'N'
1163: AND RACM.SET_NUMBER = set_no

Line 1170: FROM RA_CUSTOMER_MERGES RACM

1166: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1167: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1168: WHERE
1169: PDI.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1170: FROM RA_CUSTOMER_MERGES RACM
1171: WHERE RACM.PROCESS_FLAG = 'N'
1172: AND RACM.SET_NUMBER = set_no
1173: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1174:

Line 1213: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM

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
1217: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');

Line 1223: FROM RA_CUSTOMER_MERGES RACM

1219: END IF;
1220:
1221: UPDATE pa_draft_invoice_items PDII
1222: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1223: FROM RA_CUSTOMER_MERGES RACM
1224: WHERE
1225: RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID
1226: AND RACM.PROCESS_FLAG = 'N'
1227: AND RACM.SET_NUMBER = set_no

Line 1234: FROM RA_CUSTOMER_MERGES RACM

1230: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1231: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1232: WHERE
1233: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1234: FROM RA_CUSTOMER_MERGES RACM
1235: WHERE RACM.PROCESS_FLAG = 'N'
1236: AND RACM.SET_NUMBER = set_no
1237: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1238: --

Line 1286: FROM PA_TASKS PT, ra_customer_merges RACM

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
1290: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');

Line 1295: FROM RA_CUSTOMER_MERGES RACM

1291: END IF;
1292:
1293: UPDATE pa_tasks PT
1294: SET ( ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1295: FROM RA_CUSTOMER_MERGES RACM
1296: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1297: AND RACM.PROCESS_FLAG = 'N'
1298: AND RACM.SET_NUMBER = set_no
1299: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),

Line 1305: FROM RA_CUSTOMER_MERGES RACM

1301: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1302: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1303: WHERE
1304: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1305: FROM RA_CUSTOMER_MERGES RACM
1306: WHERE RACM.PROCESS_FLAG = 'N'
1307: AND RACM.SET_NUMBER = set_no
1308: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1309: --

Line 1356: FROM RA_CUSTOMER_MERGES

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
1357: WHERE PROCESS_FLAG = 'N'
1358: AND SET_NUMBER = set_no
1359: AND CUSTOMER_ID<>DUPLICATE_ID ) RACM
1360: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID);

Line 1366: FROM RA_CUSTOMER_MERGES RACM

1362: END IF;
1363:
1364: UPDATE PA_IMPLEMENTATIONS PI -- Bug 3891382
1365: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1366: FROM RA_CUSTOMER_MERGES RACM
1367: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1368: AND RACM.PROCESS_FLAG = 'N'
1369: AND RACM.SET_NUMBER = set_no ),
1370: LAST_UPDATE_DATE = SYSDATE,

Line 1374: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

1370: LAST_UPDATE_DATE = SYSDATE,
1371: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1372: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1373: WHERE
1374: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1375: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1376: AND RACM.PROCESS_FLAG = 'N'
1377: AND RACM.SET_NUMBER = set_no );
1378: --

Line 1426: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

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'
1428: AND SET_NUMBER = set_no
1429: AND CUSTOMER_ID<>DUPLICATE_ID) RACM
1430: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID

Line 1441: FROM RA_CUSTOMER_MERGES RACM

1437: END IF;
1438: --
1439: UPDATE PA_PROJ_RETN_RULES PR
1440: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1441: FROM RA_CUSTOMER_MERGES RACM
1442: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1443: AND RACM.PROCESS_FLAG = 'N'
1444: AND RACM.SET_NUMBER = set_no ),
1445: LAST_UPDATE_DATE = SYSDATE,

Line 1448: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

1444: AND RACM.SET_NUMBER = set_no ),
1445: LAST_UPDATE_DATE = SYSDATE,
1446: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1447: WHERE
1448: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1449: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1450: AND RACM.PROCESS_FLAG = 'N'
1451: AND RACM.SET_NUMBER = set_no
1452: /* bug 3891382 */

Line 1504: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

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'
1506: AND SET_NUMBER = set_no
1507: AND CUSTOMER_ID<>DUPLICATE_ID) RACM
1508: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID

Line 1519: FROM RA_CUSTOMER_MERGES RACM

1515: END IF;
1516:
1517: UPDATE PA_PROJ_RETN_BILL_RULES PB
1518: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1519: FROM RA_CUSTOMER_MERGES RACM
1520: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1521: AND RACM.PROCESS_FLAG = 'N'
1522: AND RACM.SET_NUMBER = set_no ),
1523: LAST_UPDATE_DATE = SYSDATE,

Line 1526: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

1522: AND RACM.SET_NUMBER = set_no ),
1523: LAST_UPDATE_DATE = SYSDATE,
1524: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1525: WHERE
1526: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1527: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1528: AND RACM.PROCESS_FLAG = 'N'
1529: AND RACM.SET_NUMBER = set_no
1530: /* bug 3891382 */

Line 1586: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

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'
1588: AND SET_NUMBER = set_no
1589: AND DUPLICATE_ID<>CUSTOMER_ID)RACM
1590: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID

Line 1600: FROM RA_CUSTOMER_MERGES RACM

1596:
1597: END IF;
1598: UPDATE PA_SUMMARY_PROJECT_RETN PS
1599: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1600: FROM RA_CUSTOMER_MERGES RACM
1601: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1602: AND RACM.PROCESS_FLAG = 'N'
1603: AND RACM.SET_NUMBER = set_no ),
1604: LAST_UPDATE_DATE = SYSDATE,

Line 1607: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

1603: AND RACM.SET_NUMBER = set_no ),
1604: LAST_UPDATE_DATE = SYSDATE,
1605: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1606: WHERE
1607: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1608: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1609: AND RACM.PROCESS_FLAG = 'N'
1610: AND RACM.SET_NUMBER = set_no
1611: /* bug 3891382 */