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 508: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_CUSTOMER_ID%TYPE

504: INDEX BY BINARY_INTEGER;
505: PRIMARY_KEY1_LIST ROWID_LIST_TYPE;
506:
507: TYPE ORIG_BILL_CUST_ID_LIST_TYPE IS TABLE OF
508: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_CUSTOMER_ID%TYPE
509: INDEX BY BINARY_INTEGER;
510: NUM_COL1_ORIG_LIST ORIG_BILL_CUST_ID_LIST_TYPE;
511: NUM_COL1_NEW_LIST ORIG_BILL_CUST_ID_LIST_TYPE;
512:

Line 514: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_CUSTOMER_ID%TYPE

510: NUM_COL1_ORIG_LIST ORIG_BILL_CUST_ID_LIST_TYPE;
511: NUM_COL1_NEW_LIST ORIG_BILL_CUST_ID_LIST_TYPE;
512:
513: TYPE ORIG_SHIP_CUST_ID_LIST_TYPE IS TABLE OF
514: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_CUSTOMER_ID%TYPE
515: INDEX BY BINARY_INTEGER;
516: NUM_COL2_ORIG_LIST ORIG_SHIP_CUST_ID_LIST_TYPE;
517: NUM_COL2_NEW_LIST ORIG_SHIP_CUST_ID_LIST_TYPE;
518:

Line 520: RA_INTERFACE_LINES.ORIG_SYSTEM_SOLD_CUSTOMER_ID%TYPE

516: NUM_COL2_ORIG_LIST ORIG_SHIP_CUST_ID_LIST_TYPE;
517: NUM_COL2_NEW_LIST ORIG_SHIP_CUST_ID_LIST_TYPE;
518:
519: TYPE ORIG_SOLD_CUST_ID_LIST_TYPE IS TABLE OF
520: RA_INTERFACE_LINES.ORIG_SYSTEM_SOLD_CUSTOMER_ID%TYPE
521: INDEX BY BINARY_INTEGER;
522: NUM_COL3_ORIG_LIST ORIG_SOLD_CUST_ID_LIST_TYPE;
523: NUM_COL3_NEW_LIST ORIG_SOLD_CUST_ID_LIST_TYPE;
524:

Line 526: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ADDRESS_ID%TYPE

522: NUM_COL3_ORIG_LIST ORIG_SOLD_CUST_ID_LIST_TYPE;
523: NUM_COL3_NEW_LIST ORIG_SOLD_CUST_ID_LIST_TYPE;
524:
525: TYPE ORIG_BILL_ADD_ID_LIST_TYPE IS TABLE OF
526: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ADDRESS_ID%TYPE
527: INDEX BY BINARY_INTEGER;
528: NUM_COL4_ORIG_LIST ORIG_BILL_ADD_ID_LIST_TYPE;
529: NUM_COL4_NEW_LIST ORIG_BILL_ADD_ID_LIST_TYPE;
530:

Line 532: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ADDRESS_ID%TYPE

528: NUM_COL4_ORIG_LIST ORIG_BILL_ADD_ID_LIST_TYPE;
529: NUM_COL4_NEW_LIST ORIG_BILL_ADD_ID_LIST_TYPE;
530:
531: TYPE ORIG_SHIP_ADD_ID_LIST_TYPE IS TABLE OF
532: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ADDRESS_ID%TYPE
533: INDEX BY BINARY_INTEGER;
534: NUM_COL5_ORIG_LIST ORIG_SHIP_ADD_ID_LIST_TYPE;
535: NUM_COL5_NEW_LIST ORIG_SHIP_ADD_ID_LIST_TYPE;
536:

Line 538: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_CUSTOMER_REF%TYPE

534: NUM_COL5_ORIG_LIST ORIG_SHIP_ADD_ID_LIST_TYPE;
535: NUM_COL5_NEW_LIST ORIG_SHIP_ADD_ID_LIST_TYPE;
536:
537: TYPE ORIG_BILL_CUST_REF_LIST_TYPE IS TABLE OF
538: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_CUSTOMER_REF%TYPE
539: INDEX BY BINARY_INTEGER;
540: VCHAR_COL1_ORIG_LIST ORIG_BILL_CUST_REF_LIST_TYPE;
541: VCHAR_COL1_NEW_LIST ORIG_BILL_CUST_REF_LIST_TYPE;
542:

Line 544: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_CUSTOMER_REF%TYPE

540: VCHAR_COL1_ORIG_LIST ORIG_BILL_CUST_REF_LIST_TYPE;
541: VCHAR_COL1_NEW_LIST ORIG_BILL_CUST_REF_LIST_TYPE;
542:
543: TYPE ORIG_SHIP_CUST_REF_LIST_TYPE IS TABLE OF
544: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_CUSTOMER_REF%TYPE
545: INDEX BY BINARY_INTEGER;
546: VCHAR_COL2_ORIG_LIST ORIG_SHIP_CUST_REF_LIST_TYPE;
547: VCHAR_COL2_NEW_LIST ORIG_SHIP_CUST_REF_LIST_TYPE;
548:

Line 550: RA_INTERFACE_LINES.ORIG_SYSTEM_SOLD_CUSTOMER_REF%TYPE

546: VCHAR_COL2_ORIG_LIST ORIG_SHIP_CUST_REF_LIST_TYPE;
547: VCHAR_COL2_NEW_LIST ORIG_SHIP_CUST_REF_LIST_TYPE;
548:
549: TYPE ORIG_SOLD_CUST_REF_LIST_TYPE IS TABLE OF
550: RA_INTERFACE_LINES.ORIG_SYSTEM_SOLD_CUSTOMER_REF%TYPE
551: INDEX BY BINARY_INTEGER;
552: VCHAR_COL3_ORIG_LIST ORIG_SOLD_CUST_REF_LIST_TYPE;
553: VCHAR_COL3_NEW_LIST ORIG_SOLD_CUST_REF_LIST_TYPE;
554:

Line 556: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ADDRESS_REF%TYPE

552: VCHAR_COL3_ORIG_LIST ORIG_SOLD_CUST_REF_LIST_TYPE;
553: VCHAR_COL3_NEW_LIST ORIG_SOLD_CUST_REF_LIST_TYPE;
554:
555: TYPE ORIG_BILL_ADD_REF_LIST_TYPE IS TABLE OF
556: RA_INTERFACE_LINES.ORIG_SYSTEM_BILL_ADDRESS_REF%TYPE
557: INDEX BY BINARY_INTEGER;
558: VCHAR_COL4_ORIG_LIST ORIG_BILL_ADD_REF_LIST_TYPE;
559: VCHAR_COL4_NEW_LIST ORIG_BILL_ADD_REF_LIST_TYPE;
560:

Line 562: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ADDRESS_REF%TYPE

558: VCHAR_COL4_ORIG_LIST ORIG_BILL_ADD_REF_LIST_TYPE;
559: VCHAR_COL4_NEW_LIST ORIG_BILL_ADD_REF_LIST_TYPE;
560:
561: TYPE ORIG_SHIP_ADD_REF_LIST_TYPE IS TABLE OF
562: RA_INTERFACE_LINES.ORIG_SYSTEM_SHIP_ADDRESS_REF%TYPE
563: INDEX BY BINARY_INTEGER;
564: VCHAR_COL5_ORIG_LIST ORIG_SHIP_ADD_REF_LIST_TYPE;
565: VCHAR_COL5_NEW_LIST ORIG_SHIP_ADD_REF_LIST_TYPE;
566:

Line 575: /Additional change for ra_interface_lines under bug2447449/

571: INDEX BY BINARY_INTEGER;
572: VCHAR_COL6_ORIG_LIST CUSTOMER_REF_LIST_TYPE;
573: VCHAR_COL6_NEW_LIST CUSTOMER_REF_LIST_TYPE;
574:
575: /*Additional change for ra_interface_lines under bug2447449*/
576: /* bug3667197: Modified the where clause of cursor merged_records to avoid
577: FTS on table ra_customer_merges */
578: /* bug4075234: Replaced 'exists' clause in CURSOR merged_records with 'IN' for performance
579: improvement */

Line 596: from ra_interface_lines rai,

592: ,ORIG_SYSTEM_SOLD_CUSTOMER_REF
593: ,ORIG_SYSTEM_BILL_ADDRESS_REF
594: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
595: ,m.CUSTOMER_REF
596: from ra_interface_lines rai,
597: ra_customer_merges m
598: where nvl(rai.interface_status,'N') <> 'P' /* bug 1611619 : check interface_status */
599: and (
600: m.duplicate_id = rai.orig_system_bill_customer_id

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

629: IF process_mode='LOCK' THEN
630: NULL;
631: ELSE
632: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
633: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_INTERFACE_LINES',FALSE);
634: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
635: /*Additional change for ra_interface_lines under bug2447449*/
636: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
637: open merged_records;

Line 635: /Additional change for ra_interface_lines under bug2447449/

631: ELSE
632: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
633: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_INTERFACE_LINES',FALSE);
634: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
635: /*Additional change for ra_interface_lines under bug2447449*/
636: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
637: open merged_records;
638: LOOP
639: FETCH merged_records BULK COLLECT INTO

Line 701: /Additional change for ra_interface_lines under bug2447449/

697: END IF;
698:
699: END LOOP;
700:
701: /*Additional change for ra_interface_lines under bug2447449*/
702: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
703: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
704: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
705: MERGE_LOG_ID,

Line 737: 'RA_INTERFACE_LINES',

733: LAST_UPDATE_LOGIN,
734: LAST_UPDATE_DATE,
735: LAST_UPDATED_BY
736: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
737: 'RA_INTERFACE_LINES',
738: MERGE_HEADER_ID_LIST(I),
739: PRIMARY_KEY1_LIST(I),
740: NUM_COL1_ORIG_LIST(I),
741: NUM_COL1_NEW_LIST(I),

Line 770: UPDATE RA_INTERFACE_LINES yt SET

766: hz_utility_pub.LAST_UPDATED_BY
767: );
768:
769: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
770: UPDATE RA_INTERFACE_LINES yt SET
771: ORIG_SYSTEM_BILL_CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
772: ,ORIG_SYSTEM_SHIP_CUSTOMER_ID=NUM_COL2_NEW_LIST(I)
773: ,ORIG_SYSTEM_SOLD_CUSTOMER_ID=NUM_COL3_NEW_LIST(I)
774: ,ORIG_SYSTEM_BILL_ADDRESS_ID=NUM_COL4_NEW_LIST(I)