APPS.OKS_ARFEEDER_PUB dependencies on OKS_BILL_CONT_LINES

Line 247: FROM OKS_BILL_CONT_LINES a

243: p_con_modifier IN VARCHAR2)IS
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

Line 293: , oks_bill_cont_lines e

289: --c.customer_trx_id,
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

Line 2260: OKS_BILL_CONT_LINES a,

2256: b.cust_acct_id,
2257: KLN.trxn_extension_id,
2258: b.line_number top_line_number
2259: From OKC_LINE_STYLES_V c,
2260: OKS_BILL_CONT_LINES a,
2261: OKC_K_LINES_B b,
2262: OKS_K_LINES_B KLN
2263: Where a.btn_id Is Null
2264: And a.amount Is Not Null

Line 2305: --added parallel hint on oks_bill_cont_lines

2301: And a.bill_action not in ('AV','TR','STR')
2302: And p_cle_id is not null;
2303:
2304: --19-NOV-2003 Mani
2305: --added parallel hint on oks_bill_cont_lines
2306:
2307: --mchoudha bug#4638641
2308: --added RI also in the bill_action condition of where clause
2309: CURSOR cur_bcl_term IS

Line 2330: OKS_BILL_CONT_LINES a,

2326: KLN.trxn_extension_id,
2327: b.line_number top_line_number
2328: From
2329: OKC_LINE_STYLES_V c,
2330: OKS_BILL_CONT_LINES a,
2331: OKC_K_LINES_B b,
2332: OKS_K_LINES_B KLN
2333: Where a.btn_id is null
2334: And a.amount Is Not Null

Line 2439: OKS_BILL_CONT_LINES c,

2435: rline.invoice_text,
2436: rline.inv_print_flag,
2437: b.line_number sub_line_number
2438: From OKS_BILL_SUB_LINES a,
2439: OKS_BILL_CONT_LINES c,
2440: OKS_K_LINES_V rline,
2441: OKC_K_LINES_B b
2442: Where a.bcl_id = id_in
2443: AND c.id = a.bcl_id

Line 2580: oks_bill_cont_lines bcl

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)
2584: AND bcl.bill_action = 'RI'

Line 3128: --Update OKS_BILL_CONT_LINES with the BTN ID

3124: IF (l_ret_stat = 'S') THEN
3125:
3126: IF ((p_prv = 1) OR (p_prv = 3)) THEN
3127:
3128: --Update OKS_BILL_CONT_LINES with the BTN ID
3129:
3130: UPDATE oks_bill_cont_lines
3131: SET btn_id = l_btnv_tbl_out(1).id
3132: WHERE id = bcl_rec.id ;

Line 3130: UPDATE oks_bill_cont_lines

3126: IF ((p_prv = 1) OR (p_prv = 3)) THEN
3127:
3128: --Update OKS_BILL_CONT_LINES with the BTN ID
3129:
3130: UPDATE oks_bill_cont_lines
3131: SET btn_id = l_btnv_tbl_out(1).id
3132: WHERE id = bcl_rec.id ;
3133:
3134: If G_LOG_YES_NO = 'YES' then

Line 3135: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Updating btn_id of oks_bill_cont_lines');

3131: SET btn_id = l_btnv_tbl_out(1).id
3132: WHERE id = bcl_rec.id ;
3133:
3134: If G_LOG_YES_NO = 'YES' then
3135: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Updating btn_id of oks_bill_cont_lines');
3136: End If;
3137:
3138: l_btlv_tbl_in(1).btn_id := l_btnv_tbl_out(1).id;
3139: l_btlv_tbl_in(1).bcl_id := bcl_rec.id;