APPS.OKS_ARFEEDER_PUB dependencies on OKS_BILL_SUB_LINES

Line 292: FROM OKS_BILL_SUB_LINES a

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

Line 313: SELECT average from oks_bill_sub_lines

309: ORDER BY c.extended_amount ;
310:
311:
312: Cursor bill_inst_number_cur(p_bcl_id in NUMBER) is
313: SELECT average from oks_bill_sub_lines
314: WHERE bcl_id = p_bcl_id;
315:
316: Cursor l_get_order_line_id(p_cle_id IN NUMBER) IS
317: SELECT object1_id1

Line 2403: From oks_bill_sub_lines

2399:
2400:
2401: Cursor ar_date_cur(p_bcl_id NUMBER) IS
2402: Select min(date_to_interface)
2403: From oks_bill_sub_lines
2404: Where bcl_id = p_bcl_id;
2405:
2406: Cursor Cur_bsl(id_in In NUMBER) IS
2407: Select a.id,

Line 2419: From OKS_BILL_SUB_LINES a,

2415: b.lse_id ,
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

Line 2603: FROM oks_bill_sub_lines

2599: WHERE cdt_type = 'MDT';
2600:
2601: Cursor Bill_instance_cur(p_id IN NUMBER) IS
2602: SELECT average
2603: FROM oks_bill_sub_lines
2604: WHERE id = p_id;
2605:
2606:
2607: -- Modified the following cursor for perf bug#3489672

Line 4725: select count(id) into l_subline_count from oks_bill_sub_lines where bcl_id = Bcl_rec.id;

4721: -- p_billrep_tbl(p_billrep_tbl_idx).Successful_Lines:= p_billrep_tbl(p_billrep_tbl_idx).Successful_Lines - 1;
4722: END IF;
4723:
4724: IF (l_subline_failed) THEN
4725: select count(id) into l_subline_count from oks_bill_sub_lines where bcl_id = Bcl_rec.id;
4726: p_billrep_tbl(p_billrep_tbl_idx).Rejected_SubLines:= p_billrep_tbl(p_billrep_tbl_idx).Rejected_SubLines +l_subline_count;
4727: -- p_billrep_tbl(p_billrep_tbl_idx).Successful_SubLines:= p_billrep_tbl(p_billrep_tbl_idx).Successful_SubLines - l_subline_count;
4728: END IF;
4729:

Line 4739: select count(id) into l_subline_count from oks_bill_sub_lines where bcl_id = Bcl_rec.id;

4735: END IF;
4736: ELSE
4737: IF NOT l_subline_failed THEN
4738: if p_prv = 1 then
4739: select count(id) into l_subline_count from oks_bill_sub_lines where bcl_id = Bcl_rec.id;
4740: elsif p_prv = 2 then
4741: select count(id) into l_subline_count from oks_bsl_pr where bcl_id = Bcl_rec.id;
4742: end if;
4743: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.debug report'||l_subline_count);