APPS.OKS_ARFEEDER_PUB dependencies on OKS_BILL_TXN_LINES

Line 248: , oks_bill_txn_lines b

244: SELECT c.Customer_trx_line_id,
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

Line 294: , oks_bill_txn_lines b

290: d.trx_date,
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

Line 2055: UPDATE oks_bill_txn_lines

2051:
2052: EXIT When x_return_status <> 'S';
2053: END LOOP;
2054:
2055: UPDATE oks_bill_txn_lines
2056: SET cycle_refrence = l_int_att10||' for PB'
2057: WHERE bill_instance_number = TO_NUMBER(G_RAIL_REC.interface_line_attribute3);
2058:
2059: ELSIF (p_prv = 3) THEN

Line 2579: SELECT btl.bsl_id ,bcl.btn_id from oks_bill_txn_lines btl,

2575:
2576: Cursor check_summary_billed (p_cle_id IN NUMBER,
2577: p_date_from IN DATE,
2578: p_date_to IN DATE) IS
2579: SELECT btl.bsl_id ,bcl.btn_id from oks_bill_txn_lines btl,
2580: oks_bill_cont_lines bcl
2581: WHERE bcl.cle_id = p_cle_id
2582: AND trunc(bcl.date_billed_from) <= trunc(p_date_from)
2583: AND trunc(bcl.date_billed_to) = trunc(p_date_to)

Line 4105: UPDATE oks_bill_txn_lines

4101: END IF;
4102:
4103: IF P_PRV = 1 THEN
4104:
4105: UPDATE oks_bill_txn_lines
4106: SET cycle_refrence = G_RAIL_REC.interface_line_attribute10
4107: WHERE bill_instance_number = TO_NUMBER(G_RAIL_REC.interface_line_attribute3);
4108: END IF;
4109:

Line 4644: UPDATE oks_bill_txn_lines

4640:
4641:
4642: IF P_PRV = 1 THEN
4643:
4644: UPDATE oks_bill_txn_lines
4645: SET cycle_refrence = G_RAIL_REC.interface_line_attribute10
4646: WHERE bill_instance_number = TO_NUMBER(G_RAIL_REC.interface_line_attribute3);
4647: END IF;
4648:

Line 4989: oks_bill_txn_lines btl

4985: pb.unit_price,
4986: pb.amount,
4987: btl.bsl_id
4988: FROM OKS_PRICE_BREAKS pb,
4989: oks_bill_txn_lines btl
4990: WHERE pb.bsl_id = btl.bsl_id
4991: AND btl.bill_instance_number = p_bill_inst_no
4992: AND pb.amount > 0
4993: ORDER BY pb.quantity_from;