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.RLM_CUST_MERGE dependencies on RLM_SCHEDULE_LINES

Line 698: FROM RLM_SCHEDULE_LINES il,

694: m.duplicate_site_id,
695: m.customer_site_id,
696: m.duplicate_id,
697: m.customer_id
698: FROM RLM_SCHEDULE_LINES il,
699: RA_CUSTOMER_MERGES m
700: WHERE m.process_flag = 'N'
701: AND m.request_id = req_id
702: AND m.set_number = set_num

Line 724: setARMessageLockTable('RLM_SCHEDULE_LINES');

720: arp_message.set_line('RLM_CUST_MERGE.Schedule_Lines()+' || getTimeStamp);
721: --
722: IF (process_mode = 'LOCK') THEN
723: --
724: setARMessageLockTable('RLM_SCHEDULE_LINES');
725: --
726: open cust_merge_cur;
727: --
728: close cust_merge_cur;

Line 764: RLM_SCHEDULE_LINES_LOG (

760: --
761: END LOOP;
762: --
763: /*2447493*/
764: RLM_SCHEDULE_LINES_LOG (
765: req_id => req_id,
766: set_num=>set_num,
767: process_mode=>process_mode) ;
768: /*2447493*/

Line 769: setARMessageUpdateTable('RLM_SCHEDULE_LINES');

765: req_id => req_id,
766: set_num=>set_num,
767: process_mode=>process_mode) ;
768: /*2447493*/
769: setARMessageUpdateTable('RLM_SCHEDULE_LINES');
770: --
771: FORALL i IN l_lineIdTab.FIRST..l_lineIdTab.LAST
772: --
773: UPDATE RLM_SCHEDULE_LINES

Line 773: UPDATE RLM_SCHEDULE_LINES

769: setARMessageUpdateTable('RLM_SCHEDULE_LINES');
770: --
771: FORALL i IN l_lineIdTab.FIRST..l_lineIdTab.LAST
772: --
773: UPDATE RLM_SCHEDULE_LINES
774: SET invoice_to_org_id = DECODE(invoice_to_org_id,
775: l_duplicateSiteIdTab(i),
776: l_customerSiteIdTab(i),
777: invoice_to_org_id

Line 2471: PROCEDURE RLM_SCHEDULE_LINES_LOG (

2467: RAISE;
2468: END RLM_SCHEDULE_HEADERS_LOG;
2469:
2470:
2471: PROCEDURE RLM_SCHEDULE_LINES_LOG (
2472: req_id NUMBER,
2473: set_num NUMBER,
2474: process_mode VARCHAR2) IS
2475:

Line 2482: RLM_SCHEDULE_LINES.LINE_ID%TYPE

2478: INDEX BY BINARY_INTEGER;
2479: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
2480:
2481: TYPE LINE_ID_LIST_TYPE IS TABLE OF
2482: RLM_SCHEDULE_LINES.LINE_ID%TYPE
2483: INDEX BY BINARY_INTEGER;
2484: PRIMARY_KEY_ID_LIST LINE_ID_LIST_TYPE;
2485:
2486: TYPE INTRMD_SHIP_TO_ID_LIST_TYPE IS TABLE OF

Line 2487: RLM_SCHEDULE_LINES.INTRMD_SHIP_TO_ID%TYPE

2483: INDEX BY BINARY_INTEGER;
2484: PRIMARY_KEY_ID_LIST LINE_ID_LIST_TYPE;
2485:
2486: TYPE INTRMD_SHIP_TO_ID_LIST_TYPE IS TABLE OF
2487: RLM_SCHEDULE_LINES.INTRMD_SHIP_TO_ID%TYPE
2488: INDEX BY BINARY_INTEGER;
2489: NUM_COL1_ORIG_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
2490: NUM_COL1_NEW_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
2491:

Line 2493: RLM_SCHEDULE_LINES.SHIP_TO_ADDRESS_ID%TYPE

2489: NUM_COL1_ORIG_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
2490: NUM_COL1_NEW_LIST INTRMD_SHIP_TO_ID_LIST_TYPE;
2491:
2492: TYPE SHIP_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
2493: RLM_SCHEDULE_LINES.SHIP_TO_ADDRESS_ID%TYPE
2494: INDEX BY BINARY_INTEGER;
2495: NUM_COL2_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
2496: NUM_COL2_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
2497:

Line 2499: RLM_SCHEDULE_LINES.BILL_TO_ADDRESS_ID%TYPE

2495: NUM_COL2_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
2496: NUM_COL2_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
2497:
2498: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
2499: RLM_SCHEDULE_LINES.BILL_TO_ADDRESS_ID%TYPE
2500: INDEX BY BINARY_INTEGER;
2501: NUM_COL3_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
2502: NUM_COL3_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
2503:

Line 2505: RLM_SCHEDULE_LINES.SHIP_TO_ORG_ID%TYPE

2501: NUM_COL3_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
2502: NUM_COL3_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
2503:
2504: TYPE SHIP_TO_ORG_ID_LIST_TYPE IS TABLE OF
2505: RLM_SCHEDULE_LINES.SHIP_TO_ORG_ID%TYPE
2506: INDEX BY BINARY_INTEGER;
2507: NUM_COL4_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
2508: NUM_COL4_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
2509:

Line 2511: RLM_SCHEDULE_LINES.INVOICE_TO_ORG_ID%TYPE

2507: NUM_COL4_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
2508: NUM_COL4_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
2509:
2510: TYPE INVOICE_TO_ORG_ID_LIST_TYPE IS TABLE OF
2511: RLM_SCHEDULE_LINES.INVOICE_TO_ORG_ID%TYPE
2512: INDEX BY BINARY_INTEGER;
2513: NUM_COL5_ORIG_LIST INVOICE_TO_ORG_ID_LIST_TYPE;
2514: NUM_COL5_NEW_LIST INVOICE_TO_ORG_ID_LIST_TYPE;
2515:

Line 2517: RLM_SCHEDULE_LINES.INTMED_SHIP_TO_ORG_ID%TYPE

2513: NUM_COL5_ORIG_LIST INVOICE_TO_ORG_ID_LIST_TYPE;
2514: NUM_COL5_NEW_LIST INVOICE_TO_ORG_ID_LIST_TYPE;
2515:
2516: TYPE INT_SHIP_TO_ORG_ID_LIST_TYPE IS TABLE OF
2517: RLM_SCHEDULE_LINES.INTMED_SHIP_TO_ORG_ID%TYPE
2518: INDEX BY BINARY_INTEGER;
2519: NUM_COL6_ORIG_LIST INT_SHIP_TO_ORG_ID_LIST_TYPE;
2520: NUM_COL6_NEW_LIST INT_SHIP_TO_ORG_ID_LIST_TYPE;
2521:

Line 2523: RLM_SCHEDULE_LINES.ITEM_NOTE_TEXT%TYPE

2519: NUM_COL6_ORIG_LIST INT_SHIP_TO_ORG_ID_LIST_TYPE;
2520: NUM_COL6_NEW_LIST INT_SHIP_TO_ORG_ID_LIST_TYPE;
2521:
2522: TYPE ITEM_NOTE_TEXT_LIST_TYPE IS TABLE OF
2523: RLM_SCHEDULE_LINES.ITEM_NOTE_TEXT%TYPE
2524: INDEX BY BINARY_INTEGER;
2525: VCHAR_COL1_ORIG_LIST ITEM_NOTE_TEXT_LIST_TYPE;
2526: VCHAR_COL1_NEW_LIST ITEM_NOTE_TEXT_LIST_TYPE;
2527:

Line 2538: FROM RLM_SCHEDULE_LINES yt, ra_customer_merges m

2534: ,SHIP_TO_ORG_ID
2535: ,INVOICE_TO_ORG_ID
2536: ,INTMED_SHIP_TO_ORG_ID
2537: ,ITEM_NOTE_TEXT
2538: FROM RLM_SCHEDULE_LINES yt, ra_customer_merges m
2539: WHERE (
2540: yt.INTRMD_SHIP_TO_ID = m.DUPLICATE_ADDRESS_ID
2541: OR yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
2542: OR yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 2555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_LINES',FALSE);

2551: IF process_mode='LOCK' THEN
2552: NULL;
2553: ELSE
2554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_LINES',FALSE);
2556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2557:
2558: open merged_records;
2559: LOOP

Line 2622: 'RLM_SCHEDULE_LINES',

2618: LAST_UPDATE_LOGIN,
2619: LAST_UPDATE_DATE,
2620: LAST_UPDATED_BY
2621: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
2622: 'RLM_SCHEDULE_LINES',
2623: MERGE_HEADER_ID_LIST(I),
2624: PRIMARY_KEY_ID_LIST(I),
2625: NUM_COL1_ORIG_LIST(I),
2626: NUM_COL1_NEW_LIST(I),

Line 2657: arp_message.set_line( 'RLM_SCHEDULE_LINES_LOG');

2653: END IF;
2654: EXCEPTION
2655:
2656: WHEN OTHERS THEN
2657: arp_message.set_line( 'RLM_SCHEDULE_LINES_LOG');
2658: RAISE;
2659: END RLM_SCHEDULE_LINES_LOG;
2660:
2661: /*2447493*/

Line 2659: END RLM_SCHEDULE_LINES_LOG;

2655:
2656: WHEN OTHERS THEN
2657: arp_message.set_line( 'RLM_SCHEDULE_LINES_LOG');
2658: RAISE;
2659: END RLM_SCHEDULE_LINES_LOG;
2660:
2661: /*2447493*/
2662:
2663: END RLM_CUST_MERGE;