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 2242: OKS_BILL_CONT_LINES a,

2238: b.cust_acct_id,
2239: KLN.trxn_extension_id,
2240: b.line_number top_line_number
2241: From OKC_LINE_STYLES_V c,
2242: OKS_BILL_CONT_LINES a,
2243: OKC_K_LINES_B b,
2244: OKS_K_LINES_B KLN
2245: Where a.btn_id Is Null
2246: And a.amount Is Not Null

Line 2287: --added parallel hint on oks_bill_cont_lines

2283: And a.bill_action not in ('AV','TR','STR')
2284: And p_cle_id is not null;
2285:
2286: --19-NOV-2003 Mani
2287: --added parallel hint on oks_bill_cont_lines
2288:
2289: --mchoudha bug#4638641
2290: --added RI also in the bill_action condition of where clause
2291: CURSOR cur_bcl_term IS

Line 2312: OKS_BILL_CONT_LINES a,

2308: KLN.trxn_extension_id,
2309: b.line_number top_line_number
2310: From
2311: OKC_LINE_STYLES_V c,
2312: OKS_BILL_CONT_LINES a,
2313: OKC_K_LINES_B b,
2314: OKS_K_LINES_B KLN
2315: Where a.btn_id is null
2316: And a.amount Is Not Null

Line 2420: OKS_BILL_CONT_LINES c,

2416: rline.invoice_text,
2417: rline.inv_print_flag,
2418: b.line_number sub_line_number
2419: From OKS_BILL_SUB_LINES a,
2420: OKS_BILL_CONT_LINES c,
2421: OKS_K_LINES_V rline,
2422: OKC_K_LINES_B b
2423: Where a.bcl_id = id_in
2424: AND c.id = a.bcl_id

Line 2561: oks_bill_cont_lines bcl

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

Line 3079: --Update OKS_BILL_CONT_LINES with the BTN ID

3075: IF (l_ret_stat = 'S') THEN
3076:
3077: IF ((p_prv = 1) OR (p_prv = 3)) THEN
3078:
3079: --Update OKS_BILL_CONT_LINES with the BTN ID
3080:
3081: UPDATE oks_bill_cont_lines
3082: SET btn_id = l_btnv_tbl_out(1).id
3083: WHERE id = bcl_rec.id ;

Line 3081: UPDATE oks_bill_cont_lines

3077: IF ((p_prv = 1) OR (p_prv = 3)) THEN
3078:
3079: --Update OKS_BILL_CONT_LINES with the BTN ID
3080:
3081: UPDATE oks_bill_cont_lines
3082: SET btn_id = l_btnv_tbl_out(1).id
3083: WHERE id = bcl_rec.id ;
3084:
3085: If G_LOG_YES_NO = 'YES' then

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

3082: SET btn_id = l_btnv_tbl_out(1).id
3083: WHERE id = bcl_rec.id ;
3084:
3085: If G_LOG_YES_NO = 'YES' then
3086: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Updating btn_id of oks_bill_cont_lines');
3087: End If;
3088:
3089: l_btlv_tbl_in(1).btn_id := l_btnv_tbl_out(1).id;
3090: l_btlv_tbl_in(1).bcl_id := bcl_rec.id;