APPS.OKS_ARFEEDER_PUB dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 250: , ra_customer_trx_lines_all c --Okx_cust_trx_lines_v c

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
254: AND a.bill_action = 'RI'

Line 273: ra_customer_trx_lines_all c --Okx_cust_trx_lines_v c

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)
277: AND c.sales_order = p_contract_number||

Line 296: , ra_customer_trx_lines_all c

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
300: AND a.bcl_id = e.id

Line 328: ra_customer_trx_lines_all txl ,

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'
332: AND txh.customer_trx_id = txl.customer_trx_id

Line 338: FROM ra_customer_trx_lines_all rl

334: AND mtl.service_item_flag = 'Y';
335:
336: Cursor comm_id_cur (p_comm_id IN NUMBER)IS
337: SELECT rl.Customer_trx_line_id
338: FROM ra_customer_trx_lines_all rl
339: WHERE rl.customer_trx_id = p_comm_id;
340:
341:
342:

Line 924: FROM ra_customer_trx_lines_all rl

920: IS
921:
922: Cursor comm_id_cur (p_comm_id IN NUMBER, p_org_id IN NUMBER)IS
923: SELECT rl.Customer_trx_line_id
924: FROM ra_customer_trx_lines_all rl
925: WHERE rl.customer_trx_id = p_comm_id
926: AND rl.org_id = p_org_id;
927:
928: Cursor cur_cust_account(p_bill_to_site_use_id IN NUMBER,

Line 1952: ra_customer_trx_lines_all txl

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
1956: AND txl.interface_line_context = 'OKS CONTRACTS'

Line 1964: FROM RA_CUSTOMER_TRX_LINES_ALL

1960: ORDER BY abs(txl.extended_amount);
1961:
1962: Cursor get_tax (p_customer_trx_line_id IN NUMBER) IS
1963: SELECT extended_amount tax_amount
1964: FROM RA_CUSTOMER_TRX_LINES_ALL
1965: WHERE line_type = 'TAX'
1966: AND link_to_cust_trx_line_id = p_customer_trx_line_id;
1967:
1968: Price_breaks_rec Price_breaks_cur%ROWTYPE;

Line 2615: ra_customer_trx_lines_all c, --Okx_cust_trx_lines_v c

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 ,'-')
2619: AND c.Interface_line_attribute3 = to_char(p_bill_instance_number)