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 2422: From oks_bill_sub_lines

2418:
2419:
2420: Cursor ar_date_cur(p_bcl_id NUMBER) IS
2421: Select min(date_to_interface)
2422: From oks_bill_sub_lines
2423: Where bcl_id = p_bcl_id;
2424:
2425: Cursor Cur_bsl(id_in In NUMBER) IS
2426: Select a.id,

Line 2438: From OKS_BILL_SUB_LINES a,

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

Line 2622: FROM oks_bill_sub_lines

2618: WHERE cdt_type = 'MDT';
2619:
2620: Cursor Bill_instance_cur(p_id IN NUMBER) IS
2621: SELECT average
2622: FROM oks_bill_sub_lines
2623: WHERE id = p_id;
2624:
2625:
2626: -- Modified the following cursor for perf bug#3489672

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

4873: -- p_billrep_tbl(p_billrep_tbl_idx).Successful_Lines:= p_billrep_tbl(p_billrep_tbl_idx).Successful_Lines - 1;
4874: END IF;
4875:
4876: IF (l_subline_failed) THEN
4877: select count(id) into l_subline_count from oks_bill_sub_lines where bcl_id = Bcl_rec.id;
4878: p_billrep_tbl(p_billrep_tbl_idx).Rejected_SubLines:= p_billrep_tbl(p_billrep_tbl_idx).Rejected_SubLines +l_subline_count;
4879: -- p_billrep_tbl(p_billrep_tbl_idx).Successful_SubLines:= p_billrep_tbl(p_billrep_tbl_idx).Successful_SubLines - l_subline_count;
4880: END IF;
4881:

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

4887: END IF;
4888: ELSE
4889: IF NOT l_subline_failed THEN
4890: if p_prv = 1 then
4891: select count(id) into l_subline_count from oks_bill_sub_lines where bcl_id = Bcl_rec.id;
4892: elsif p_prv = 2 then
4893: select count(id) into l_subline_count from oks_bsl_pr where bcl_id = Bcl_rec.id;
4894: end if;
4895: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.debug report'||l_subline_count);