APPS.OKS_ARFEEDER_PUB dependencies on RA_CUSTOMER_TRX_ALL

Line 249: , ra_customer_trx_all d --Okx_customer_trx_v d

245: d.trx_date,
246: d.exchange_rate_type,d.exchange_date, d.exchange_rate
247: FROM OKS_BILL_CONT_LINES a
248: , oks_bill_txn_lines b
249: , ra_customer_trx_all d --Okx_customer_trx_v d
250: , ra_customer_trx_lines_all c --Okx_cust_trx_lines_v c
251: WHERE a.date_billed_to = p_date_billed_to -- Bcl_rec.date_billed_to
252: AND a.cle_id = p_id -- Bcl_rec.cle_id
253: AND a.id = b.bcl_id

Line 272: FROM ra_customer_trx_all d, --Okx_customer_trx_v d

268: SELECT c.Customer_trx_line_id,
269: --c.customer_trx_id,
270: d.trx_date,
271: d.exchange_rate_type,d.exchange_date, d.exchange_rate
272: FROM ra_customer_trx_all d, --Okx_customer_trx_v d
273: ra_customer_trx_lines_all c --Okx_cust_trx_lines_v c
274: WHERE c.interface_line_attribute1 = p_contract_number
275: AND nvl(c.interface_line_attribute2,'-') = nvl(p_contract_modifier ,'-')
276: AND c.Interface_line_attribute3 = to_char(p_bill_instance_number)

Line 295: , ra_customer_trx_all d

291: d.exchange_rate_type,d.exchange_date, d.exchange_rate
292: FROM OKS_BILL_SUB_LINES a
293: , oks_bill_cont_lines e
294: , oks_bill_txn_lines b
295: , ra_customer_trx_all d
296: , ra_customer_trx_lines_all c
297: WHERE a.DATE_Billed_to = p_date_to -- Bsl_rec.date_billed_to
298: AND a.cle_id = p_id -- Bsl_rec.cle_id
299: AND a.id = b.bsl_id

Line 327: FROM ra_customer_trx_all txh ,

323: ***/
324: Cursor l_get_ref_id (p_line_id IN NUMBER) IS
325: SELECT txl.customer_trx_line_id ,txh.trx_date trx_date,
326: txh.exchange_rate_type,txh.exchange_date, txh.exchange_rate
327: FROM ra_customer_trx_all txh ,
328: ra_customer_trx_lines_all txl ,
329: mtl_system_items mtl
330: WHERE txl.interface_line_attribute6 = to_char(p_line_id)
331: AND txl.interface_line_context = 'ORDER ENTRY'

Line 1951: FROM ra_customer_trx_all txh,

1947: txl.gross_extended_amount,
1948: txl.amount_includes_tax_flag,
1949: txl.customer_trx_line_id ,
1950: txh.trx_date
1951: FROM ra_customer_trx_all txh,
1952: ra_customer_trx_lines_all txl
1953: WHERE txl.interface_line_attribute1 = p_contract_number
1954: AND nvl(txl.interface_line_attribute2,'-') = nvl(p_contract_modifier,'-')
1955: AND txl.interface_line_attribute3 = p_bill_instance_number

Line 2614: FROM ra_customer_trx_all d, --Okx_customer_trx_v d

2610: p_contract_modifier IN VARCHAR2,
2611: p_bill_instance_number IN NUMBER)
2612: IS
2613: SELECT count(*)
2614: FROM ra_customer_trx_all d, --Okx_customer_trx_v d
2615: ra_customer_trx_lines_all c, --Okx_cust_trx_lines_v c
2616: ra_cust_trx_types_all types
2617: WHERE c.interface_line_attribute1 = p_contract_number
2618: AND nvl(c.interface_line_attribute2,'-') = nvl(p_contract_modifier ,'-')