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.ARP_CMERGE_ARTRX dependencies on RA_INTERFACE_LINES

Line 816: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_CUSTOMER_ID%TYPE

812: INDEX BY BINARY_INTEGER;
813: PRIMARY_KEY1_LIST ROWID_LIST_TYPE;
814:
815: TYPE ORIG_BILL_CUST_ID_LIST_TYPE IS TABLE OF
816: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_CUSTOMER_ID%TYPE
817: INDEX BY BINARY_INTEGER;
818: NUM_COL1_ORIG_LIST ORIG_BILL_CUST_ID_LIST_TYPE;
819: NUM_COL1_NEW_LIST ORIG_BILL_CUST_ID_LIST_TYPE;
820:

Line 822: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_CUSTOMER_ID%TYPE

818: NUM_COL1_ORIG_LIST ORIG_BILL_CUST_ID_LIST_TYPE;
819: NUM_COL1_NEW_LIST ORIG_BILL_CUST_ID_LIST_TYPE;
820:
821: TYPE ORIG_SHIP_CUST_ID_LIST_TYPE IS TABLE OF
822: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_CUSTOMER_ID%TYPE
823: INDEX BY BINARY_INTEGER;
824: NUM_COL2_ORIG_LIST ORIG_SHIP_CUST_ID_LIST_TYPE;
825: NUM_COL2_NEW_LIST ORIG_SHIP_CUST_ID_LIST_TYPE;
826:

Line 828: RA_INTERFACE_LINES.ORIG_SYSTEM_SOLD_CUSTOMER_ID%TYPE

824: NUM_COL2_ORIG_LIST ORIG_SHIP_CUST_ID_LIST_TYPE;
825: NUM_COL2_NEW_LIST ORIG_SHIP_CUST_ID_LIST_TYPE;
826:
827: TYPE ORIG_SOLD_CUST_ID_LIST_TYPE IS TABLE OF
828: RA_INTERFACE_LINES.ORIG_SYSTEM_SOLD_CUSTOMER_ID%TYPE
829: INDEX BY BINARY_INTEGER;
830: NUM_COL3_ORIG_LIST ORIG_SOLD_CUST_ID_LIST_TYPE;
831: NUM_COL3_NEW_LIST ORIG_SOLD_CUST_ID_LIST_TYPE;
832:

Line 834: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ADDRESS_ID%TYPE

830: NUM_COL3_ORIG_LIST ORIG_SOLD_CUST_ID_LIST_TYPE;
831: NUM_COL3_NEW_LIST ORIG_SOLD_CUST_ID_LIST_TYPE;
832:
833: TYPE ORIG_BILL_ADD_ID_LIST_TYPE IS TABLE OF
834: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ADDRESS_ID%TYPE
835: INDEX BY BINARY_INTEGER;
836: NUM_COL4_ORIG_LIST ORIG_BILL_ADD_ID_LIST_TYPE;
837: NUM_COL4_NEW_LIST ORIG_BILL_ADD_ID_LIST_TYPE;
838:

Line 840: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ADDRESS_ID%TYPE

836: NUM_COL4_ORIG_LIST ORIG_BILL_ADD_ID_LIST_TYPE;
837: NUM_COL4_NEW_LIST ORIG_BILL_ADD_ID_LIST_TYPE;
838:
839: TYPE ORIG_SHIP_ADD_ID_LIST_TYPE IS TABLE OF
840: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ADDRESS_ID%TYPE
841: INDEX BY BINARY_INTEGER;
842: NUM_COL5_ORIG_LIST ORIG_SHIP_ADD_ID_LIST_TYPE;
843: NUM_COL5_NEW_LIST ORIG_SHIP_ADD_ID_LIST_TYPE;
844:

Line 846: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_CUSTOMER_REF%TYPE

842: NUM_COL5_ORIG_LIST ORIG_SHIP_ADD_ID_LIST_TYPE;
843: NUM_COL5_NEW_LIST ORIG_SHIP_ADD_ID_LIST_TYPE;
844:
845: TYPE ORIG_BILL_CUST_REF_LIST_TYPE IS TABLE OF
846: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_CUSTOMER_REF%TYPE
847: INDEX BY BINARY_INTEGER;
848: VCHAR_COL1_ORIG_LIST ORIG_BILL_CUST_REF_LIST_TYPE;
849: VCHAR_COL1_NEW_LIST ORIG_BILL_CUST_REF_LIST_TYPE;
850:

Line 852: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_CUSTOMER_REF%TYPE

848: VCHAR_COL1_ORIG_LIST ORIG_BILL_CUST_REF_LIST_TYPE;
849: VCHAR_COL1_NEW_LIST ORIG_BILL_CUST_REF_LIST_TYPE;
850:
851: TYPE ORIG_SHIP_CUST_REF_LIST_TYPE IS TABLE OF
852: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_CUSTOMER_REF%TYPE
853: INDEX BY BINARY_INTEGER;
854: VCHAR_COL2_ORIG_LIST ORIG_SHIP_CUST_REF_LIST_TYPE;
855: VCHAR_COL2_NEW_LIST ORIG_SHIP_CUST_REF_LIST_TYPE;
856:

Line 858: RA_INTERFACE_LINES.ORIG_SYSTEM_SOLD_CUSTOMER_REF%TYPE

854: VCHAR_COL2_ORIG_LIST ORIG_SHIP_CUST_REF_LIST_TYPE;
855: VCHAR_COL2_NEW_LIST ORIG_SHIP_CUST_REF_LIST_TYPE;
856:
857: TYPE ORIG_SOLD_CUST_REF_LIST_TYPE IS TABLE OF
858: RA_INTERFACE_LINES.ORIG_SYSTEM_SOLD_CUSTOMER_REF%TYPE
859: INDEX BY BINARY_INTEGER;
860: VCHAR_COL3_ORIG_LIST ORIG_SOLD_CUST_REF_LIST_TYPE;
861: VCHAR_COL3_NEW_LIST ORIG_SOLD_CUST_REF_LIST_TYPE;
862:

Line 864: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ADDRESS_REF%TYPE

860: VCHAR_COL3_ORIG_LIST ORIG_SOLD_CUST_REF_LIST_TYPE;
861: VCHAR_COL3_NEW_LIST ORIG_SOLD_CUST_REF_LIST_TYPE;
862:
863: TYPE ORIG_BILL_ADD_REF_LIST_TYPE IS TABLE OF
864: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ADDRESS_REF%TYPE
865: INDEX BY BINARY_INTEGER;
866: VCHAR_COL4_ORIG_LIST ORIG_BILL_ADD_REF_LIST_TYPE;
867: VCHAR_COL4_NEW_LIST ORIG_BILL_ADD_REF_LIST_TYPE;
868:

Line 870: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ADDRESS_REF%TYPE

866: VCHAR_COL4_ORIG_LIST ORIG_BILL_ADD_REF_LIST_TYPE;
867: VCHAR_COL4_NEW_LIST ORIG_BILL_ADD_REF_LIST_TYPE;
868:
869: TYPE ORIG_SHIP_ADD_REF_LIST_TYPE IS TABLE OF
870: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ADDRESS_REF%TYPE
871: INDEX BY BINARY_INTEGER;
872: VCHAR_COL5_ORIG_LIST ORIG_SHIP_ADD_REF_LIST_TYPE;
873: VCHAR_COL5_NEW_LIST ORIG_SHIP_ADD_REF_LIST_TYPE;
874:

Line 883: /Additional change for ra_interface_lines under bug2447449/

879: INDEX BY BINARY_INTEGER;
880: VCHAR_COL6_ORIG_LIST CUSTOMER_REF_LIST_TYPE;
881: VCHAR_COL6_NEW_LIST CUSTOMER_REF_LIST_TYPE;
882:
883: /*Additional change for ra_interface_lines under bug2447449*/
884: /* bug3667197: Modified the where clause of cursor merged_records to avoid
885: FTS on table ra_customer_merges */
886: /* bug4075234: Replaced 'exists' clause in CURSOR merged_records with 'IN' for performance
887: improvement */

Line 906: from ra_interface_lines rai,

902: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
903: ,ORIG_SYSTEM_BILL_ADDRESS_REF
904: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
905: ,m.CUSTOMER_REF
906: from ra_interface_lines rai,
907: ra_customer_merges m
908: where nvl(rai.interface_status,'N') <> 'P'
909: and m.process_flag = 'N'
910: and m.request_id = req_id

Line 927: from ra_interface_lines rai,

923: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
924: ,ORIG_SYSTEM_BILL_ADDRESS_REF
925: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
926: ,m.CUSTOMER_REF
927: from ra_interface_lines rai,
928: ra_customer_merges m
929: where nvl(rai.interface_status,'N') <> 'P'
930: and m.process_flag = 'N'
931: and m.request_id = req_id

Line 948: from ra_interface_lines rai,

944: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
945: ,ORIG_SYSTEM_BILL_ADDRESS_REF
946: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
947: ,m.CUSTOMER_REF
948: from ra_interface_lines rai,
949: ra_customer_merges m
950: where nvl(rai.interface_status,'N') <> 'P'
951: and m.process_flag = 'N'
952: and m.request_id = req_id

Line 969: from ra_interface_lines rai,

965: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
966: ,ORIG_SYSTEM_BILL_ADDRESS_REF
967: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
968: ,m.CUSTOMER_REF
969: from ra_interface_lines rai,
970: ra_customer_merges m
971: where nvl(rai.interface_status,'N') <> 'P'
972: and m.process_flag = 'N'
973: and m.request_id = req_id

Line 990: from ra_interface_lines rai,

986: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
987: ,ORIG_SYSTEM_BILL_ADDRESS_REF
988: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
989: ,m.CUSTOMER_REF
990: from ra_interface_lines rai,
991: ra_customer_merges m
992: where nvl(rai.interface_status,'N') <> 'P'
993: and m.process_flag = 'N'
994: and m.request_id = req_id

Line 1011: from ra_interface_lines rai,

1007: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
1008: ,ORIG_SYSTEM_BILL_ADDRESS_REF
1009: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
1010: ,m.CUSTOMER_REF
1011: from ra_interface_lines rai,
1012: ra_customer_merges m
1013: where nvl(rai.interface_status,'N') <> 'P'
1014: and m.process_flag = 'N'
1015: and m.request_id = req_id

Line 1032: from ra_interface_lines rai,

1028: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
1029: ,ORIG_SYSTEM_BILL_ADDRESS_REF
1030: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
1031: ,m.CUSTOMER_REF
1032: from ra_interface_lines rai,
1033: ra_customer_merges m
1034: where nvl(rai.interface_status,'N') <> 'P'
1035: and m.process_flag = 'N'
1036: and m.request_id = req_id

Line 1053: from ra_interface_lines rai,

1049: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
1050: ,ORIG_SYSTEM_BILL_ADDRESS_REF
1051: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
1052: ,m.CUSTOMER_REF
1053: from ra_interface_lines rai,
1054: ra_customer_merges m
1055: where nvl(rai.interface_status,'N') <> 'P'
1056: and m.process_flag = 'N'
1057: and m.request_id = req_id

Line 1074: from ra_interface_lines rai,

1070: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
1071: ,ORIG_SYSTEM_BILL_ADDRESS_REF
1072: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
1073: ,m.CUSTOMER_REF
1074: from ra_interface_lines rai,
1075: ra_customer_merges m
1076: where nvl(rai.interface_status,'N') <> 'P'
1077: and m.process_flag = 'N'
1078: and m.request_id = req_id

Line 1098: from ra_interface_lines rai,

1094: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
1095: ,ORIG_SYSTEM_BILL_ADDRESS_REF
1096: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
1097: ,m.CUSTOMER_REF
1098: from ra_interface_lines rai,
1099: ra_customer_merges m
1100: where nvl(rai.interface_status,'N') <> 'P'
1101: and m.process_flag = 'N'
1102: and m.request_id = req_id

Line 1119: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_INTERFACE_LINES',FALSE);

1115: IF process_mode='LOCK' THEN
1116: NULL;
1117: ELSE
1118: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1119: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_INTERFACE_LINES',FALSE);
1120: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1121: /*Additional change for ra_interface_lines under bug2447449*/
1122: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1123: open merged_records;

Line 1121: /Additional change for ra_interface_lines under bug2447449/

1117: ELSE
1118: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1119: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_INTERFACE_LINES',FALSE);
1120: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1121: /*Additional change for ra_interface_lines under bug2447449*/
1122: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1123: open merged_records;
1124: LOOP
1125: FETCH merged_records BULK COLLECT INTO

Line 1187: /Additional change for ra_interface_lines under bug2447449/

1183: END IF;
1184:
1185: END LOOP;
1186:
1187: /*Additional change for ra_interface_lines under bug2447449*/
1188: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1189: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1190: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1191: MERGE_LOG_ID,

Line 1223: 'RA_INTERFACE_LINES',

1219: LAST_UPDATE_LOGIN,
1220: LAST_UPDATE_DATE,
1221: LAST_UPDATED_BY
1222: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1223: 'RA_INTERFACE_LINES',
1224: MERGE_HEADER_ID_LIST(I),
1225: PRIMARY_KEY1_LIST(I),
1226: NUM_COL1_ORIG_LIST(I),
1227: NUM_COL1_NEW_LIST(I),

Line 1256: UPDATE RA_INTERFACE_LINES yt SET

1252: hz_utility_pub.LAST_UPDATED_BY
1253: );
1254:
1255: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1256: UPDATE RA_INTERFACE_LINES yt SET
1257: ORIG_SYSTEM_BILL_CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
1258: ,ORIG_SYSTEM_SHIP_CUSTOMER_ID=NUM_COL2_NEW_LIST(I)
1259: ,ORIG_SYSTEM_SOLD_CUSTOMER_ID=NUM_COL3_NEW_LIST(I)
1260: ,ORIG_SYSTEM_BILL_ADDRESS_ID=NUM_COL4_NEW_LIST(I)