APPS.AR_AME_CM_ATTRIBUTES_API dependencies on RA_CUSTOMER_TRX

Line 17: ra_customer_trx rct

13: CURSOR cust_id (p_txn_id NUMBER) IS
14: SELECT rct.bill_to_customer_id
15: FROM hz_cust_accounts bill_to_cust,
16: hz_parties party,
17: ra_customer_trx rct
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

Line 28: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

24: AND r.cm_reason_code = l.lookup_code
25: AND l.lookup_type = 'CREDIT_MEMO_REASON');
26:
27:
28: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
29:
30: BEGIN
31:
32: OPEN cust_id (p_transaction_id);

Line 90: ra_customer_trx rct

86: CURSOR bill_id (p_txn_id NUMBER) IS
87: SELECT rct.bill_to_site_use_id
88: FROM hz_cust_accounts bill_to_cust,
89: hz_parties party,
90: ra_customer_trx rct
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

Line 100: l_bill_to_use_id ra_customer_trx.bill_to_site_use_id%TYPE;

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:
100: l_bill_to_use_id ra_customer_trx.bill_to_site_use_id%TYPE;
101:
102: BEGIN
103:
104: OPEN bill_id(p_transaction_id);

Line 143: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

139: -- as shown below to work with dynamic pre-approver
140: -- SELECT 'first:pre:person_id:' || col.employee_id
141:
142:
143: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
144: l_bill_to_use_id ra_customer_trx.bill_to_site_use_id%TYPE;
145: -- l_collector_id ar_collectors.employee_id%TYPE;
146: l_collector_id VARCHAR2(50);
147: l_site_use_id VARCHAR2(50);

Line 144: l_bill_to_use_id ra_customer_trx.bill_to_site_use_id%TYPE;

140: -- SELECT 'first:pre:person_id:' || col.employee_id
141:
142:
143: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
144: l_bill_to_use_id ra_customer_trx.bill_to_site_use_id%TYPE;
145: -- l_collector_id ar_collectors.employee_id%TYPE;
146: l_collector_id VARCHAR2(50);
147: l_site_use_id VARCHAR2(50);
148:

Line 581: ra_customer_trx t,

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

Line 609: ra_customer_trx_lines tl

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'
613: AND tl.customer_trx_id = r.customer_trx_id