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 81: /+ INDEX (racm RA_CUSTOMER_MERGES_N5) /

77: /* Bug 3891382. Added the cursor to select the delete_duplicate_flag */
78: /* Added hint for bug 13787566 */
79: CURSOR cursor_1 IS WITH MERGE_DUPS AS
80: (SELECT
81: /*+ INDEX (racm RA_CUSTOMER_MERGES_N5) */
82: DISTINCT RACM.DUPLICATE_ID
83: FROM RA_CUSTOMER_MERGES RACM
84: WHERE RACM.PROCESS_FLAG = 'N'
85: AND RACM.SET_NUMBER = set_no

Line 83: FROM RA_CUSTOMER_MERGES RACM

79: CURSOR cursor_1 IS WITH MERGE_DUPS AS
80: (SELECT
81: /*+ INDEX (racm RA_CUSTOMER_MERGES_N5) */
82: DISTINCT RACM.DUPLICATE_ID
83: FROM RA_CUSTOMER_MERGES RACM
84: WHERE RACM.PROCESS_FLAG = 'N'
85: AND RACM.SET_NUMBER = set_no
86: AND RACM.REQUEST_ID = req_id
87: )

Line 111: FROM RA_CUSTOMER_MERGES

107: WHERE PP.PROJECT_ID = PA.PROJECT_ID
108: );
109: /* Added hint for bug 13787566 */
110: CURSOR cursor_2 IS SELECT DUPLICATE_ID,DELETE_DUPLICATE_FLAG,CUSTOMER_ID /* for bug 6732730*/
111: FROM RA_CUSTOMER_MERGES
112: WHERE PROCESS_FLAG = 'N'
113: AND SET_NUMBER = set_no;
114: --
115: CURSOR cursor_lock_1 IS

Line 119: FROM RA_CUSTOMER_MERGES RACM

115: CURSOR cursor_lock_1 IS
116: SELECT CUSTOMER_ID FROM pa_project_customers PC
117: WHERE
118: PC.CUSTOMER_ID IN ( SELECT DISTINCT RACM.DUPLICATE_ID
119: FROM RA_CUSTOMER_MERGES RACM
120: WHERE RACM.PROCESS_FLAG = 'N'
121: AND RACM.SET_NUMBER = set_no )
122: FOR UPDATE NOWAIT;
123: --

Line 128: FROM RA_CUSTOMER_MERGES RACM

124: CURSOR cursor_lock_2 IS
125: SELECT SHIP_TO_ADDRESS_ID FROM pa_draft_invoice_items PDII
126: WHERE
127: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
128: FROM RA_CUSTOMER_MERGES RACM
129: WHERE RACM.PROCESS_FLAG = 'N'
130: AND RACM.SET_NUMBER = set_no
131: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )
132: FOR UPDATE NOWAIT;

Line 138: FROM RA_CUSTOMER_MERGES RACM

134: CURSOR cursor_lock_3 IS
135: SELECT ADDRESS_ID FROM pa_tasks PT
136: WHERE
137: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
138: FROM RA_CUSTOMER_MERGES RACM
139: WHERE RACM.PROCESS_FLAG = 'N'
140: AND RACM.SET_NUMBER = set_no
141: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )
142: FOR UPDATE NOWAIT;

Line 148: FROM RA_CUSTOMER_MERGES RACM

144: CURSOR cursor_lock_4 IS
145: SELECT CUSTOMER_ID FROM pa_project_contacts PC
146: WHERE
147: PC.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
148: FROM RA_CUSTOMER_MERGES RACM
149: WHERE RACM.PROCESS_FLAG = 'N'
150: AND RACM.SET_NUMBER = set_no )
151: FOR UPDATE NOWAIT;
152: --

Line 157: FROM RA_CUSTOMER_MERGES RACM

153: CURSOR cursor_lock_5 IS
154: SELECT CUSTOMER_ID FROM pa_agreements PA
155: WHERE
156: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
157: FROM RA_CUSTOMER_MERGES RACM
158: WHERE RACM.PROCESS_FLAG = 'N'
159: AND RACM.SET_NUMBER = set_no )
160: FOR UPDATE NOWAIT;
161: --

Line 166: FROM RA_CUSTOMER_MERGES RACM

162: CURSOR cursor_lock_6 IS
163: SELECT CUSTOMER_ID FROM pa_implementations PA -- bug 3891382
164: WHERE
165: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
166: FROM RA_CUSTOMER_MERGES RACM
167: WHERE RACM.PROCESS_FLAG = 'N'
168: AND RACM.SET_NUMBER = set_no )
169: FOR UPDATE NOWAIT;
170: --

Line 175: FROM RA_CUSTOMER_MERGES RACM

171: CURSOR cursor_lock_7 IS
172: SELECT CUSTOMER_ID FROM pa_proj_retn_rules PA
173: WHERE
174: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
175: FROM RA_CUSTOMER_MERGES RACM
176: WHERE RACM.PROCESS_FLAG = 'N'
177: AND RACM.SET_NUMBER = set_no )
178: FOR UPDATE NOWAIT;
179: --

Line 184: FROM RA_CUSTOMER_MERGES RACM

180: CURSOR cursor_lock_8 IS
181: SELECT CUSTOMER_ID FROM pa_proj_retn_bill_rules PA
182: WHERE
183: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
184: FROM RA_CUSTOMER_MERGES RACM
185: WHERE RACM.PROCESS_FLAG = 'N'
186: AND RACM.SET_NUMBER = set_no )
187: FOR UPDATE NOWAIT;
188: --

Line 193: FROM RA_CUSTOMER_MERGES RACM

189: CURSOR cursor_lock_9 IS
190: SELECT CUSTOMER_ID FROM pa_summary_project_retn PA
191: WHERE
192: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
193: FROM RA_CUSTOMER_MERGES RACM
194: WHERE RACM.PROCESS_FLAG = 'N'
195: AND RACM.SET_NUMBER = set_no )
196: FOR UPDATE NOWAIT;
197: --

Line 208: var_dup_id ra_customer_merges.duplicate_id%TYPE;

204: records_locked EXCEPTION;
205: total_record_upd_count NUMBER := 0;
206: total_record_del_count NUMBER := 0;
207: PRAGMA EXCEPTION_INIT( records_locked, -00054 );
208: var_dup_id ra_customer_merges.duplicate_id%TYPE;
209: var_dup_flag ra_customer_merges.delete_duplicate_flag%TYPE;
210: var_count1 NUMBER := 0;
211: var_count2 NUMBER := 0;
212: /* Begin for Bug 6732730 */

Line 209: var_dup_flag ra_customer_merges.delete_duplicate_flag%TYPE;

205: total_record_upd_count NUMBER := 0;
206: total_record_del_count NUMBER := 0;
207: PRAGMA EXCEPTION_INIT( records_locked, -00054 );
208: var_dup_id ra_customer_merges.duplicate_id%TYPE;
209: var_dup_flag ra_customer_merges.delete_duplicate_flag%TYPE;
210: var_count1 NUMBER := 0;
211: var_count2 NUMBER := 0;
212: /* Begin for Bug 6732730 */
213: var_cust_id ra_customer_merges.customer_id%TYPE; /* Modified to var_cust_id for bug 7341412 */

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

209: var_dup_flag ra_customer_merges.delete_duplicate_flag%TYPE;
210: var_count1 NUMBER := 0;
211: var_count2 NUMBER := 0;
212: /* Begin for Bug 6732730 */
213: var_cust_id ra_customer_merges.customer_id%TYPE; /* Modified to var_cust_id for bug 7341412 */
214: /* End for Bug 6732730 */
215:
216: /* */
217: BEGIN

Line 475: FROM PA_PROJECT_CUSTOMERS pc,ra_customer_merges RACM

471: ,PC.RETENTION_LEVEL_CODE
472: ,PC.BILL_TO_CUSTOMER_ID
473: ,PC.SHIP_TO_CUSTOMER_ID
474: ,PC.Default_Top_Task_Cust_Flag -- FP_M Changes
475: FROM PA_PROJECT_CUSTOMERS pc,ra_customer_merges RACM
476: WHERE RACM.DUPLICATE_ID = var_customer_id
477: AND PC.PROJECT_ID=var_project_id
478: AND PC.CUSTOMER_ID = var_customer_id
479: AND RACM.PROCESS_FLAG = 'N'

Line 528: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM

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

Line 600: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

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

Line 614: FROM RA_CUSTOMER_MERGES RACM

610: /* End of TCA audit*/
611:
612: UPDATE pa_project_customers PC
613: SET ( BILL_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
614: FROM RA_CUSTOMER_MERGES RACM
615: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
616: AND RACM.DUPLICATE_ADDRESS_ID = PC.BILL_TO_ADDRESS_ID
617: AND RACM.PROCESS_FLAG = 'N'
618: AND RACM.SET_NUMBER = set_no

Line 625: FROM RA_CUSTOMER_MERGES RACM

621: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
622: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
623: WHERE
624: PC.BILL_TO_ADDRESS_ID IN ( SELECT DISTINCT RACM.DUPLICATE_ADDRESS_ID
625: FROM RA_CUSTOMER_MERGES RACM
626: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/
627: AND RACM.PROCESS_FLAG = 'N'
628: AND RACM.SET_NUMBER = set_no
629: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' )

Line 667: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

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

Line 680: FROM RA_CUSTOMER_MERGES RACM

676: END IF;
677:
678: UPDATE pa_project_customers PC
679: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
680: FROM RA_CUSTOMER_MERGES RACM
681: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
682: AND RACM.DUPLICATE_ADDRESS_ID = PC.SHIP_TO_ADDRESS_ID
683: AND RACM.PROCESS_FLAG = 'N'
684: AND RACM.SET_NUMBER = set_no

Line 691: FROM RA_CUSTOMER_MERGES RACM

687: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
688: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
689: WHERE
690: PC.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
691: FROM RA_CUSTOMER_MERGES RACM
692: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/
693: AND RACM.PROCESS_FLAG = 'N'
694: AND RACM.SET_NUMBER = set_no
695: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )

Line 733: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

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

Line 745: FROM RA_CUSTOMER_MERGES RACM

741: END IF;
742:
743: UPDATE pa_project_customers PC
744: SET ( BILL_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
745: FROM RA_CUSTOMER_MERGES RACM
746: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id
747: AND RACM.PROCESS_FLAG = 'N'
748: AND RACM.SET_NUMBER = set_no ),
749: LAST_UPDATE_DATE = SYSDATE,

Line 753: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

749: LAST_UPDATE_DATE = SYSDATE,
750: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
751: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
752: WHERE
753: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
754: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
755: AND RACM.PROCESS_FLAG = 'N'
756: AND RACM.SET_NUMBER = set_no )
757: AND PC.PROJECT_ID = var_project_id

Line 792: FROM PA_PROJECT_CUSTOMERS PC, RA_CUSTOMER_MERGES RACM

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

Line 804: FROM RA_CUSTOMER_MERGES RACM

800: END IF;
801:
802: UPDATE pa_project_customers PC
803: SET ( SHIP_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
804: FROM RA_CUSTOMER_MERGES RACM
805: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id
806: AND RACM.PROCESS_FLAG = 'N'
807: AND RACM.SET_NUMBER = set_no ),
808: LAST_UPDATE_DATE = SYSDATE,

Line 812: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

808: LAST_UPDATE_DATE = SYSDATE,
809: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
810: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
811: WHERE
812: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
813: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
814: AND RACM.PROCESS_FLAG = 'N'
815: AND RACM.SET_NUMBER = set_no )
816: AND PC.PROJECT_ID = var_project_id

Line 855: FROM PA_PROJECT_CUSTOMERS PC, ra_customer_merges RACM

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

Line 867: FROM RA_CUSTOMER_MERGES RACM

863:
864: END IF;
865: UPDATE pa_project_customers PC
866: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
867: FROM RA_CUSTOMER_MERGES RACM
868: WHERE RACM.DUPLICATE_ID = var_customer_id
869: AND RACM.PROCESS_FLAG = 'N'
870: AND RACM.SET_NUMBER = set_no ),
871: LAST_UPDATE_DATE = SYSDATE,

Line 875: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

871: LAST_UPDATE_DATE = SYSDATE,
872: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
873: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
874: WHERE
875: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
876: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
877: AND RACM.PROCESS_FLAG = 'N'
878: AND RACM.SET_NUMBER = set_no )
879: AND PC.PROJECT_ID = var_project_id

Line 940: FROM RA_CUSTOMER_MERGES

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
941: WHERE PROCESS_FLAG = 'N'
942: AND SET_NUMBER = set_no
943: AND CUSTOMER_ID<>DUPLICATE_ID ) RACM
944: WHERE

Line 952: FROM RA_CUSTOMER_MERGES RACM

948: END IF;
949:
950: UPDATE pa_draft_invoices PC -- bug 3891382
951: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
952: FROM RA_CUSTOMER_MERGES RACM
953: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
954: AND RACM.PROCESS_FLAG = 'N'
955: AND RACM.SET_NUMBER = set_no ),
956: LAST_UPDATE_DATE = SYSDATE,

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

956: LAST_UPDATE_DATE = SYSDATE,
957: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
958: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
959: WHERE
960: PC.CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
961: WHERE RACM.PROCESS_FLAG = 'N'
962: AND RACM.SET_NUMBER = set_no );
963:
964: IF g_audit_profile='Y' THEN

Line 1000: FROM RA_CUSTOMER_MERGES

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
1001: WHERE PROCESS_FLAG = 'N'
1002: AND SET_NUMBER = set_no
1003: AND CUSTOMER_ID<>DUPLICATE_ID ) RACM
1004: WHERE

Line 1012: FROM RA_CUSTOMER_MERGES RACM

1008: END IF;
1009:
1010: UPDATE pa_draft_invoices PC -- bug 3891382
1011: SET ( BILL_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1012: FROM RA_CUSTOMER_MERGES RACM
1013: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
1014: AND RACM.PROCESS_FLAG = 'N'
1015: AND RACM.SET_NUMBER = set_no ),
1016: LAST_UPDATE_DATE = SYSDATE,

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

1016: LAST_UPDATE_DATE = SYSDATE,
1017: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1018: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1019: WHERE
1020: PC.BILL_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1021: WHERE RACM.PROCESS_FLAG = 'N'
1022: AND RACM.SET_NUMBER = set_no );
1023:
1024: IF g_audit_profile='Y' THEN

Line 1060: FROM RA_CUSTOMER_MERGES

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
1061: WHERE PROCESS_FLAG = 'N'
1062: AND SET_NUMBER = set_no
1063: AND CUSTOMER_ID<>DUPLICATE_ID ) RACM
1064: WHERE

Line 1072: FROM RA_CUSTOMER_MERGES RACM

1068: END IF;
1069:
1070: UPDATE pa_draft_invoices PC -- bug 3891382
1071: SET ( SHIP_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1072: FROM RA_CUSTOMER_MERGES RACM
1073: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
1074: AND RACM.PROCESS_FLAG = 'N'
1075: AND RACM.SET_NUMBER = set_no ),
1076: LAST_UPDATE_DATE = SYSDATE,

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

1076: LAST_UPDATE_DATE = SYSDATE,
1077: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1078: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1079: WHERE
1080: PC.SHIP_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1081: WHERE RACM.PROCESS_FLAG = 'N'
1082: AND RACM.SET_NUMBER = set_no );
1083:
1084:

Line 1118: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

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

Line 1131: FROM RA_CUSTOMER_MERGES RACM

1127: END IF;
1128:
1129: UPDATE pa_draft_invoices PDI -- bug 3891382
1130: SET ( BILL_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1131: FROM RA_CUSTOMER_MERGES RACM
1132: WHERE
1133: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID
1134: AND RACM.DUPLICATE_ID = PDI.BILL_TO_CUSTOMER_ID /* for bug 11842127 */
1135: AND RACM.PROCESS_FLAG = 'N'

Line 1144: FROM RA_CUSTOMER_MERGES RACM

1140: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1141: WHERE
1142: (PDI.BILL_TO_CUSTOMER_ID,PDI.BILL_TO_ADDRESS_ID) IN /* for bug 11842127 */
1143: ( SELECT RACM.DUPLICATE_ID,RACM.DUPLICATE_ADDRESS_ID
1144: FROM RA_CUSTOMER_MERGES RACM
1145: WHERE RACM.PROCESS_FLAG = 'N'
1146: AND RACM.SET_NUMBER = set_no
1147: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' );
1148:

Line 1182: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

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

Line 1195: FROM RA_CUSTOMER_MERGES RACM

1191: END IF;
1192:
1193: UPDATE pa_draft_invoices PDI -- bug 3891382
1194: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1195: FROM RA_CUSTOMER_MERGES RACM
1196: WHERE
1197: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID
1198: AND RACM.DUPLICATE_ID = PDI.SHIP_TO_CUSTOMER_ID /* for bug 11842127 */
1199: AND RACM.PROCESS_FLAG = 'N'

Line 1208: FROM RA_CUSTOMER_MERGES RACM

1204: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1205: WHERE
1206: (PDI.SHIP_TO_CUSTOMER_ID,PDI.SHIP_TO_ADDRESS_ID) IN /* for bug 11842127 */
1207: ( SELECT RACM.DUPLICATE_ID,RACM.DUPLICATE_ADDRESS_ID
1208: FROM RA_CUSTOMER_MERGES RACM
1209: WHERE RACM.PROCESS_FLAG = 'N'
1210: AND RACM.SET_NUMBER = set_no
1211: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1212:

Line 1251: FROM PA_DRAFT_INVOICE_ITEMS PDII, ra_customer_merges RACM

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

Line 1261: FROM RA_CUSTOMER_MERGES RACM

1257: END IF;
1258:
1259: UPDATE pa_draft_invoice_items PDII
1260: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1261: FROM RA_CUSTOMER_MERGES RACM
1262: WHERE
1263: RACM.DUPLICATE_ADDRESS_ID = PDII.SHIP_TO_ADDRESS_ID
1264: AND RACM.PROCESS_FLAG = 'N'
1265: AND RACM.SET_NUMBER = set_no

Line 1272: FROM RA_CUSTOMER_MERGES RACM

1268: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1269: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1270: WHERE
1271: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1272: FROM RA_CUSTOMER_MERGES RACM
1273: WHERE RACM.PROCESS_FLAG = 'N'
1274: AND RACM.SET_NUMBER = set_no
1275: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1276: --

Line 1324: FROM PA_TASKS PT, ra_customer_merges RACM

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

Line 1333: FROM RA_CUSTOMER_MERGES RACM

1329: END IF;
1330:
1331: UPDATE pa_tasks PT
1332: SET ( ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1333: FROM RA_CUSTOMER_MERGES RACM
1334: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1335: AND RACM.PROCESS_FLAG = 'N'
1336: AND RACM.SET_NUMBER = set_no
1337: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),

Line 1343: FROM RA_CUSTOMER_MERGES RACM

1339: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1340: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1341: WHERE
1342: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1343: FROM RA_CUSTOMER_MERGES RACM
1344: WHERE RACM.PROCESS_FLAG = 'N'
1345: AND RACM.SET_NUMBER = set_no
1346: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' );
1347: --

Line 1394: FROM RA_CUSTOMER_MERGES

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
1395: WHERE PROCESS_FLAG = 'N'
1396: AND SET_NUMBER = set_no
1397: AND CUSTOMER_ID<>DUPLICATE_ID ) RACM
1398: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID);

Line 1404: FROM RA_CUSTOMER_MERGES RACM

1400: END IF;
1401:
1402: UPDATE PA_IMPLEMENTATIONS PI -- Bug 3891382
1403: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1404: FROM RA_CUSTOMER_MERGES RACM
1405: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1406: AND RACM.PROCESS_FLAG = 'N'
1407: AND RACM.SET_NUMBER = set_no ),
1408: LAST_UPDATE_DATE = SYSDATE,

Line 1412: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

1408: LAST_UPDATE_DATE = SYSDATE,
1409: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1410: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1411: WHERE
1412: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1413: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1414: AND RACM.PROCESS_FLAG = 'N'
1415: AND RACM.SET_NUMBER = set_no );
1416: --

Line 1464: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

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'
1466: AND SET_NUMBER = set_no
1467: AND CUSTOMER_ID<>DUPLICATE_ID) RACM
1468: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID

Line 1479: FROM RA_CUSTOMER_MERGES RACM

1475: END IF;
1476: --
1477: UPDATE PA_PROJ_RETN_RULES PR
1478: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1479: FROM RA_CUSTOMER_MERGES RACM
1480: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1481: AND RACM.PROCESS_FLAG = 'N'
1482: AND RACM.SET_NUMBER = set_no ),
1483: LAST_UPDATE_DATE = SYSDATE,

Line 1486: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

1482: AND RACM.SET_NUMBER = set_no ),
1483: LAST_UPDATE_DATE = SYSDATE,
1484: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1485: WHERE
1486: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1487: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1488: AND RACM.PROCESS_FLAG = 'N'
1489: AND RACM.SET_NUMBER = set_no
1490: /* bug 3891382 */

Line 1542: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

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'
1544: AND SET_NUMBER = set_no
1545: AND CUSTOMER_ID<>DUPLICATE_ID) RACM
1546: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID

Line 1557: FROM RA_CUSTOMER_MERGES RACM

1553: END IF;
1554:
1555: UPDATE PA_PROJ_RETN_BILL_RULES PB
1556: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1557: FROM RA_CUSTOMER_MERGES RACM
1558: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1559: AND RACM.PROCESS_FLAG = 'N'
1560: AND RACM.SET_NUMBER = set_no ),
1561: LAST_UPDATE_DATE = SYSDATE,

Line 1564: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

1560: AND RACM.SET_NUMBER = set_no ),
1561: LAST_UPDATE_DATE = SYSDATE,
1562: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1563: WHERE
1564: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1565: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1566: AND RACM.PROCESS_FLAG = 'N'
1567: AND RACM.SET_NUMBER = set_no
1568: /* bug 3891382 */

Line 1624: DUPLICATE_ID FROM RA_CUSTOMER_MERGES

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'
1626: AND SET_NUMBER = set_no
1627: AND DUPLICATE_ID<>CUSTOMER_ID)RACM
1628: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID

Line 1638: FROM RA_CUSTOMER_MERGES RACM

1634:
1635: END IF;
1636: UPDATE PA_SUMMARY_PROJECT_RETN PS
1637: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1638: FROM RA_CUSTOMER_MERGES RACM
1639: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1640: AND RACM.PROCESS_FLAG = 'N'
1641: AND RACM.SET_NUMBER = set_no ),
1642: LAST_UPDATE_DATE = SYSDATE,

Line 1645: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM

1641: AND RACM.SET_NUMBER = set_no ),
1642: LAST_UPDATE_DATE = SYSDATE,
1643: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1644: WHERE
1645: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1646: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1647: AND RACM.PROCESS_FLAG = 'N'
1648: AND RACM.SET_NUMBER = set_no
1649: /* bug 3891382 */