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_CUSTOMER_TRX

Line 284: RA_CUSTOMER_TRX.customer_trx_id%TYPE

280: INDEX BY BINARY_INTEGER;
281: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
282:
283: TYPE customer_trx_id_LIST_TYPE IS TABLE OF
284: RA_CUSTOMER_TRX.customer_trx_id%TYPE
285: INDEX BY BINARY_INTEGER;
286: PRIMARY_KEY_ID_LIST customer_trx_id_LIST_TYPE;
287:
288: TYPE bill_to_customer_id_LIST_TYPE IS TABLE OF

Line 289: RA_CUSTOMER_TRX.bill_to_customer_id%TYPE

285: INDEX BY BINARY_INTEGER;
286: PRIMARY_KEY_ID_LIST customer_trx_id_LIST_TYPE;
287:
288: TYPE bill_to_customer_id_LIST_TYPE IS TABLE OF
289: RA_CUSTOMER_TRX.bill_to_customer_id%TYPE
290: INDEX BY BINARY_INTEGER;
291: NUM_COL1_ORIG_LIST bill_to_customer_id_LIST_TYPE;
292: NUM_COL1_NEW_LIST bill_to_customer_id_LIST_TYPE;
293:

Line 295: RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE

291: NUM_COL1_ORIG_LIST bill_to_customer_id_LIST_TYPE;
292: NUM_COL1_NEW_LIST bill_to_customer_id_LIST_TYPE;
293:
294: TYPE bill_to_site_use_id_LIST_TYPE IS TABLE OF
295: RA_CUSTOMER_TRX.bill_to_site_use_id%TYPE
296: INDEX BY BINARY_INTEGER;
297: NUM_COL2_ORIG_LIST bill_to_site_use_id_LIST_TYPE;
298: NUM_COL2_NEW_LIST bill_to_site_use_id_LIST_TYPE;
299:

Line 301: RA_CUSTOMER_TRX.paying_customer_id%TYPE

297: NUM_COL2_ORIG_LIST bill_to_site_use_id_LIST_TYPE;
298: NUM_COL2_NEW_LIST bill_to_site_use_id_LIST_TYPE;
299:
300: TYPE paying_customer_id_LIST_TYPE IS TABLE OF
301: RA_CUSTOMER_TRX.paying_customer_id%TYPE
302: INDEX BY BINARY_INTEGER;
303: NUM_COL3_ORIG_LIST paying_customer_id_LIST_TYPE;
304: NUM_COL3_NEW_LIST paying_customer_id_LIST_TYPE;
305:

Line 307: RA_CUSTOMER_TRX.paying_site_use_id%TYPE

303: NUM_COL3_ORIG_LIST paying_customer_id_LIST_TYPE;
304: NUM_COL3_NEW_LIST paying_customer_id_LIST_TYPE;
305:
306: TYPE paying_site_use_id_LIST_TYPE IS TABLE OF
307: RA_CUSTOMER_TRX.paying_site_use_id%TYPE
308: INDEX BY BINARY_INTEGER;
309: NUM_COL4_ORIG_LIST paying_site_use_id_LIST_TYPE;
310: NUM_COL4_NEW_LIST paying_site_use_id_LIST_TYPE;
311:

Line 313: RA_CUSTOMER_TRX.ship_to_customer_id%TYPE

309: NUM_COL4_ORIG_LIST paying_site_use_id_LIST_TYPE;
310: NUM_COL4_NEW_LIST paying_site_use_id_LIST_TYPE;
311:
312: TYPE ship_to_customer_id_LIST_TYPE IS TABLE OF
313: RA_CUSTOMER_TRX.ship_to_customer_id%TYPE
314: INDEX BY BINARY_INTEGER;
315: NUM_COL5_ORIG_LIST ship_to_customer_id_LIST_TYPE;
316: NUM_COL5_NEW_LIST ship_to_customer_id_LIST_TYPE;
317:

Line 319: RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE

315: NUM_COL5_ORIG_LIST ship_to_customer_id_LIST_TYPE;
316: NUM_COL5_NEW_LIST ship_to_customer_id_LIST_TYPE;
317:
318: TYPE ship_to_site_use_id_LIST_TYPE IS TABLE OF
319: RA_CUSTOMER_TRX.ship_to_site_use_id%TYPE
320: INDEX BY BINARY_INTEGER;
321: NUM_COL6_ORIG_LIST ship_to_site_use_id_LIST_TYPE;
322: NUM_COL6_NEW_LIST ship_to_site_use_id_LIST_TYPE;
323:

Line 325: RA_CUSTOMER_TRX.sold_to_customer_id%TYPE

321: NUM_COL6_ORIG_LIST ship_to_site_use_id_LIST_TYPE;
322: NUM_COL6_NEW_LIST ship_to_site_use_id_LIST_TYPE;
323:
324: TYPE sold_to_customer_id_LIST_TYPE IS TABLE OF
325: RA_CUSTOMER_TRX.sold_to_customer_id%TYPE
326: INDEX BY BINARY_INTEGER;
327: NUM_COL7_ORIG_LIST sold_to_customer_id_LIST_TYPE;
328: NUM_COL7_NEW_LIST sold_to_customer_id_LIST_TYPE;
329:

Line 331: RA_CUSTOMER_TRX.sold_to_site_use_id%TYPE

327: NUM_COL7_ORIG_LIST sold_to_customer_id_LIST_TYPE;
328: NUM_COL7_NEW_LIST sold_to_customer_id_LIST_TYPE;
329:
330: TYPE sold_to_site_use_id_LIST_TYPE IS TABLE OF
331: RA_CUSTOMER_TRX.sold_to_site_use_id%TYPE
332: INDEX BY BINARY_INTEGER;
333: NUM_COL8_ORIG_LIST sold_to_site_use_id_LIST_TYPE;
334: NUM_COL8_NEW_LIST sold_to_site_use_id_LIST_TYPE;
335:

Line 338: RA_CUSTOMER_TRX.drawee_id%TYPE

334: NUM_COL8_NEW_LIST sold_to_site_use_id_LIST_TYPE;
335:
336: /* Bug 10030466 */
337: TYPE drawee_id_LIST_TYPE IS TABLE OF
338: RA_CUSTOMER_TRX.drawee_id%TYPE
339: INDEX BY BINARY_INTEGER;
340: NUM_COL9_ORIG_LIST drawee_id_LIST_TYPE;
341: NUM_COL9_NEW_LIST drawee_id_LIST_TYPE;
342:

Line 344: RA_CUSTOMER_TRX.drawee_site_use_id%TYPE

340: NUM_COL9_ORIG_LIST drawee_id_LIST_TYPE;
341: NUM_COL9_NEW_LIST drawee_id_LIST_TYPE;
342:
343: TYPE drawee_site_use_id_LIST_TYPE IS TABLE OF
344: RA_CUSTOMER_TRX.drawee_site_use_id%TYPE
345: INDEX BY BINARY_INTEGER;
346: NUM_COL10_ORIG_LIST drawee_site_use_id_LIST_TYPE;
347: NUM_COL10_NEW_LIST drawee_site_use_id_LIST_TYPE;
348:

Line 363: FROM RA_CUSTOMER_TRX yt, ra_customer_merges m

359: ,sold_to_customer_id
360: ,sold_to_site_use_id
361: ,DRAWEE_ID
362: ,DRAWEE_SITE_USE_ID
363: FROM RA_CUSTOMER_TRX yt, ra_customer_merges m
364: WHERE ( (yt.bill_to_customer_id = m.DUPLICATE_ID AND
365: yt.bill_to_site_use_id = m.DUPLICATE_SITE_ID)
366: OR (yt.paying_customer_id = m.DUPLICATE_ID AND
367: yt.paying_site_use_id = m.DUPLICATE_SITE_ID)

Line 384: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX',FALSE);

380: IF process_mode='LOCK' THEN
381: NULL;
382: ELSE
383: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
384: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX',FALSE);
385: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
386: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
387:
388: open merged_records;

Line 457: 'RA_CUSTOMER_TRX',

453: LAST_UPDATE_LOGIN,
454: LAST_UPDATE_DATE,
455: LAST_UPDATED_BY
456: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
457: 'RA_CUSTOMER_TRX',
458: MERGE_HEADER_ID_LIST(I),
459: PRIMARY_KEY_ID_LIST(I),
460: NUM_COL1_ORIG_LIST(I),
461: NUM_COL1_NEW_LIST(I),

Line 489: UPDATE RA_CUSTOMER_TRX yt SET

485: hz_utility_pub.LAST_UPDATE_DATE,
486: hz_utility_pub.LAST_UPDATED_BY
487: );
488: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
489: UPDATE RA_CUSTOMER_TRX yt SET
490: bill_to_customer_id=NUM_COL1_NEW_LIST(I)
491: ,bill_to_site_use_id=NUM_COL2_NEW_LIST(I)
492: ,paying_customer_id=NUM_COL3_NEW_LIST(I)
493: ,paying_site_use_id=NUM_COL4_NEW_LIST(I)

Line 537: RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE

533: INDEX BY BINARY_INTEGER;
534: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
535:
536: TYPE customer_trx_line_id_LIST_TYPE IS TABLE OF
537: RA_CUSTOMER_TRX_LINES.customer_trx_line_id%TYPE
538: INDEX BY BINARY_INTEGER;
539: PRIMARY_KEY_ID_LIST customer_trx_line_id_LIST_TYPE;
540:
541: TYPE ship_to_customer_id_LIST_TYPE IS TABLE OF

Line 542: RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE

538: INDEX BY BINARY_INTEGER;
539: PRIMARY_KEY_ID_LIST customer_trx_line_id_LIST_TYPE;
540:
541: TYPE ship_to_customer_id_LIST_TYPE IS TABLE OF
542: RA_CUSTOMER_TRX_LINES.ship_to_customer_id%TYPE
543: INDEX BY BINARY_INTEGER;
544: NUM_COL1_ORIG_LIST ship_to_customer_id_LIST_TYPE;
545: NUM_COL1_NEW_LIST ship_to_customer_id_LIST_TYPE;
546:

Line 548: RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE

544: NUM_COL1_ORIG_LIST ship_to_customer_id_LIST_TYPE;
545: NUM_COL1_NEW_LIST ship_to_customer_id_LIST_TYPE;
546:
547: TYPE ship_to_site_use_id_LIST_TYPE IS TABLE OF
548: RA_CUSTOMER_TRX_LINES.ship_to_site_use_id%TYPE
549: INDEX BY BINARY_INTEGER;
550: NUM_COL2_ORIG_LIST ship_to_site_use_id_LIST_TYPE;
551: NUM_COL2_NEW_LIST ship_to_site_use_id_LIST_TYPE;
552:

Line 561: FROM RA_CUSTOMER_TRX_LINES yt , ra_customer_merges m

557: ,customer_trx_line_id
558: ,ship_to_customer_id
559: ,ship_to_site_use_id
560:
561: FROM RA_CUSTOMER_TRX_LINES yt , ra_customer_merges m
562: WHERE
563: yt.ship_to_customer_id = m.DUPLICATE_ID AND
564: nvl(yt.ship_to_site_use_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID
565:

Line 576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX_LINES',FALSE);

572: IF process_mode='LOCK' THEN
573: NULL;
574: ELSE
575: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
576: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX_LINES',FALSE);
577: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
578: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
579:
580: open merged_records;

Line 620: 'RA_CUSTOMER_TRX_LINES',

616: LAST_UPDATE_LOGIN,
617: LAST_UPDATE_DATE,
618: LAST_UPDATED_BY
619: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
620: 'RA_CUSTOMER_TRX_LINES',
621: MERGE_HEADER_ID_LIST(I),
622: PRIMARY_KEY_ID_LIST(I),
623: NUM_COL1_ORIG_LIST(I),
624: NUM_COL1_NEW_LIST(I),

Line 636: UPDATE RA_CUSTOMER_TRX_LINES yt SET

632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: );
635: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
636: UPDATE RA_CUSTOMER_TRX_LINES yt SET
637:
638: ship_to_customer_id=NUM_COL1_NEW_LIST(I)
639: ,ship_to_site_use_id=NUM_COL2_NEW_LIST(I)
640: , LAST_UPDATE_DATE=SYSDATE