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 2041: UPDATE oks_bill_txn_lines

2037:
2038: EXIT When x_return_status <> 'S';
2039: END LOOP;
2040:
2041: UPDATE oks_bill_txn_lines
2042: SET cycle_refrence = l_int_att10||' for PB'
2043: WHERE bill_instance_number = TO_NUMBER(G_RAIL_REC.interface_line_attribute3);
2044:
2045: ELSIF (p_prv = 3) THEN

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

2556:
2557: Cursor check_summary_billed (p_cle_id IN NUMBER,
2558: p_date_from IN DATE,
2559: p_date_to IN DATE) IS
2560: SELECT btl.bsl_id ,bcl.btn_id from oks_bill_txn_lines btl,
2561: oks_bill_cont_lines bcl
2562: WHERE bcl.cle_id = p_cle_id
2563: AND trunc(bcl.date_billed_from) <= trunc(p_date_from)
2564: AND trunc(bcl.date_billed_to) = trunc(p_date_to)

Line 4034: UPDATE oks_bill_txn_lines

4030: END IF;
4031:
4032: IF P_PRV = 1 THEN
4033:
4034: UPDATE oks_bill_txn_lines
4035: SET cycle_refrence = G_RAIL_REC.interface_line_attribute10
4036: WHERE bill_instance_number = TO_NUMBER(G_RAIL_REC.interface_line_attribute3);
4037: END IF;
4038:

Line 4519: UPDATE oks_bill_txn_lines

4515:
4516:
4517: IF P_PRV = 1 THEN
4518:
4519: UPDATE oks_bill_txn_lines
4520: SET cycle_refrence = G_RAIL_REC.interface_line_attribute10
4521: WHERE bill_instance_number = TO_NUMBER(G_RAIL_REC.interface_line_attribute3);
4522: END IF;
4523:

Line 4835: oks_bill_txn_lines btl

4831: pb.unit_price,
4832: pb.amount,
4833: btl.bsl_id
4834: FROM OKS_PRICE_BREAKS pb,
4835: oks_bill_txn_lines btl
4836: WHERE pb.bsl_id = btl.bsl_id
4837: AND btl.bill_instance_number = p_bill_inst_no
4838: AND pb.amount > 0
4839: ORDER BY pb.quantity_from;