APPS.OKS_BILL_REC_PUB dependencies on OKS_BILL_SUB_LINE_DTLS

Line 330: FROM Oks_bill_sub_line_dtls

326: ,Attribute12
327: ,Attribute13
328: ,Attribute14
329: ,Attribute15
330: FROM Oks_bill_sub_line_dtls
331: WHERE bsl_id = p_bsl_id;
332:
333: Cursor check_bcl(p_date_billed_from IN DATE
334: ,p_date_billed_to IN DATE

Line 1122: FROM oks_bill_sub_line_dtls bsd,

1118: SELECT sum(bsd.result) ,
1119: sum(bsl.amount) ,
1120: max(bsl.date_billed_From),
1121: max(bsl.date_billed_to)
1122: FROM oks_bill_sub_line_dtls bsd,
1123: oks_bill_sub_lines bsl
1124: WHERE bsl.cle_id = p_cle_id
1125: AND bsd.bsl_id = bsl.id;
1126:

Line 1137: oks_bill_sub_line_dtls bsd

1133: bsl.amount,
1134: bsd.result
1135: FROM oks_bill_cont_lines bcl,
1136: oks_bill_sub_lines bsl,
1137: oks_bill_sub_line_dtls bsd
1138: WHERE bcl.id = bsl.bcl_id
1139: AND bsl.cle_id = p_cle_id
1140: AND bsd.bsl_id = bsl.id
1141: ORDER by bsl.date_billed_to desc;

Line 2372: FROM oks_bill_sub_line_dtls

2368: ,Attribute12
2369: ,Attribute13
2370: ,Attribute14
2371: ,Attribute15
2372: FROM oks_bill_sub_line_dtls
2373: WHERE bsl_id = id_in;
2374:
2375: Cursor Bcl_Csr Is
2376: SELECT Id

Line 3520: Select * from oks_bill_sub_line_dtls

3516: FROM oks_bill_sub_lines bsl
3517: WHERE bsl.bcl_id = p_id;
3518:
3519: Cursor bsd_cur (p_id in number) is
3520: Select * from oks_bill_sub_line_dtls
3521: where bsl_id = p_id;
3522:
3523:
3524: Cursor check_bcl(p_id in Number,

Line 5629: oks_bill_sub_line_dtls bsd

5625: Cursor l_tot_csr Is
5626: SELECT NVL(Sum(NVL(bsd.Result,0)),0)
5627: FROM oks_bill_cont_lines bcl,
5628: oks_bill_sub_lines bsl,
5629: oks_bill_sub_line_dtls bsd
5630: WHERE bsl.cle_id = p_cle_id
5631: AND bsl.bcl_id = bcl.id
5632: AND bcl.bill_action ='RI'
5633: AND bsd.bsl_id = bsl.id;

Line 5750: FROM oks_bill_sub_line_dtls bsd,

5746: WHERE cle_id = p_cle_id;
5747:
5748: CURSOR total_billed_qty (p_cle_id IN NUMBER) IS
5749: SELECT sum(result)
5750: FROM oks_bill_sub_line_dtls bsd,
5751: oks_bill_sub_lines bsl
5752: WHERE bsl.cle_id = p_cle_id
5753: AND bsd.bsl_id = bsl.id;
5754:

Line 6432: FROM Oks_bill_sub_line_dtls ldtl

6428: l_ctr_rec l_ctr_csr%rowtype;
6429:
6430: Cursor l_actual_counter_csr(p_cle_id IN NUMBER) Is
6431: SELECT nvl(end_reading,0) qty
6432: FROM Oks_bill_sub_line_dtls ldtl
6433: ,oks_bill_sub_lines line
6434: WHERE line.cle_id = p_cle_id
6435: AND ldtl.bsl_id = line.id
6436: AND nvl(end_reading,0) > 0

Line 6453: FROM Oks_bill_sub_line_dtls ldtl

6449:
6450:
6451: Cursor l_actual_csr(p_cle_id IN NUMBER) Is
6452: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6453: FROM Oks_bill_sub_line_dtls ldtl
6454: ,oks_bill_sub_lines line
6455: WHERE line.cle_id = p_cle_id
6456: AND ldtl.bsl_id = line.id
6457: ORDER BY date_billed_to desc ;

Line 6472: FROM Oks_bill_sub_line_dtls ldtl

6468:
6469:
6470: Cursor l_ccr_id_csr Is
6471: SELECT end_reading read,ccr_id,cgr_id
6472: FROM Oks_bill_sub_line_dtls ldtl
6473: ,oks_bill_sub_lines line
6474: WHERE line.cle_id = p_cle_id
6475: AND ldtl.bsl_id = line.id
6476: -- Bug#4730007 nechatur 1-Dec-2005

Line 6547: FROM Oks_bill_sub_line_dtls ldtl

6543: --Bug#5235116
6544:
6545: Cursor l_actual_term_csr(p_cle_id IN NUMBER) Is
6546: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6547: FROM Oks_bill_sub_line_dtls ldtl
6548: ,oks_bill_sub_lines line
6549: WHERE line.cle_id = p_cle_id
6550: AND ldtl.bsl_id = line.id
6551: AND trunc(date_billed_from) < trunc(p_start_date)

Line 7021: UPDATE oks_bill_sub_line_dtls

7017: SET amount = round_amount,
7018: average = 0
7019: WHERE id = p_bsl_id;
7020:
7021: UPDATE oks_bill_sub_line_dtls
7022: SET amount = round_amount
7023: WHERE bsl_id = p_bsl_id;
7024:
7025: ELSIF (P_PRV = 2) THEN

Line 10008: oks_bill_sub_line_dtls bsd

10004: bsl.amount,
10005: bsd.result
10006: FROM oks_bill_cont_lines bcl,
10007: oks_bill_sub_lines bsl,
10008: oks_bill_sub_line_dtls bsd
10009: WHERE bcl.id = bsl.bcl_id
10010: AND bsl.cle_id = p_cle_id
10011: AND bsd.bsl_id = bsl.id
10012: ORDER by bsl.date_billed_to desc;