APPS.AR_AME_CM_ATTRIBUTES_API dependencies on RA_CM_REQUESTS

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 56: ra_cm_requests r

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';
60:

Line 61: l_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;

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';
60:
61: l_customer_trx_id ra_cm_requests.customer_trx_id%TYPE;
62:
63: BEGIN
64:
65: OPEN cust_t_id(p_transaction_id);

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 580: ra_cm_requests r,

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
584: AND r.cm_reason_code = l.lookup_code

Line 608: ra_cm_requests r,

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
612: AND l.lookup_type = 'CREDIT_MEMO_REASON'