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.AR_AME_CM_ATTRIBUTES_API dependencies on AR_LOOKUPS

Line 22: FROM ar_lookups l, ra_cm_requests r

18: WHERE rct.bill_to_customer_id = bill_to_cust.cust_account_id
19: AND bill_to_cust.party_id = party.party_id
20: AND rct.customer_trx_id =
21: (SELECT r.customer_trx_id
22: FROM ar_lookups l, ra_cm_requests r
23: WHERE r.request_id = p_txn_id
24: AND r.cm_reason_code = l.lookup_code
25: AND l.lookup_type = 'CREDIT_MEMO_REASON');
26:

Line 55: FROM ar_lookups l,

51: RETURN NUMBER IS
52:
53: CURSOR cust_t_id (p_txn_id NUMBER) IS
54: SELECT r.customer_trx_id
55: FROM ar_lookups l,
56: ra_cm_requests r
57: WHERE r.request_id = p_txn_id
58: AND r.cm_reason_code = l.lookup_code
59: AND l.lookup_type = 'CREDIT_MEMO_REASON';

Line 95: FROM ar_lookups l,ra_cm_requests r

91: WHERE rct.bill_to_customer_id = bill_to_cust.cust_account_id
92: AND bill_to_cust.party_id = party.party_id
93: AND rct.customer_trx_id =
94: (SELECT r.customer_trx_id
95: FROM ar_lookups l,ra_cm_requests r
96: WHERE r.request_id = p_txn_id
97: AND r.cm_reason_code = l.lookup_code
98: AND l.lookup_type = 'CREDIT_MEMO_REASON');
99:

Line 579: FROM ar_lookups l,

575:
576:
577: CURSOR trx_types IS
578: SELECT tt.name
579: FROM ar_lookups l,
580: ra_cm_requests r,
581: ra_customer_trx t,
582: ra_cust_trx_types tt
583: WHERE r.request_id = p_transaction_id

Line 607: FROM ar_lookups l,

603: RETURN VARCHAR2 IS
604:
605: CURSOR trx_types IS
606: SELECT interface_line_context
607: FROM ar_lookups l,
608: ra_cm_requests r,
609: ra_customer_trx_lines tl
610: WHERE r.request_id = p_transaction_id
611: AND r.cm_reason_code = l.lookup_code