APPS.OKS_BILL_REC_PUB dependencies on OKS_BILL_SUB_LINE_DTLS

Line 327: FROM Oks_bill_sub_line_dtls

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

Line 1103: FROM oks_bill_sub_line_dtls bsd,

1099: SELECT sum(bsd.result) ,
1100: sum(bsl.amount) ,
1101: max(bsl.date_billed_From),
1102: max(bsl.date_billed_to)
1103: FROM oks_bill_sub_line_dtls bsd,
1104: oks_bill_sub_lines bsl
1105: WHERE bsl.cle_id = p_cle_id
1106: AND bsd.bsl_id = bsl.id;
1107:

Line 1118: oks_bill_sub_line_dtls bsd

1114: bsl.amount,
1115: bsd.result
1116: FROM oks_bill_cont_lines bcl,
1117: oks_bill_sub_lines bsl,
1118: oks_bill_sub_line_dtls bsd
1119: WHERE bcl.id = bsl.bcl_id
1120: AND bsl.cle_id = p_cle_id
1121: AND bsd.bsl_id = bsl.id
1122: ORDER by bsl.date_billed_to desc;

Line 2358: FROM oks_bill_sub_line_dtls

2354: ,Attribute12
2355: ,Attribute13
2356: ,Attribute14
2357: ,Attribute15
2358: FROM oks_bill_sub_line_dtls
2359: WHERE bsl_id = id_in;
2360:
2361: Cursor Bcl_Csr Is
2362: SELECT Id

Line 3494: Select * from oks_bill_sub_line_dtls

3490: FROM oks_bill_sub_lines bsl
3491: WHERE bsl.bcl_id = p_id;
3492:
3493: Cursor bsd_cur (p_id in number) is
3494: Select * from oks_bill_sub_line_dtls
3495: where bsl_id = p_id;
3496:
3497:
3498: Cursor check_bcl(p_id in Number,

Line 5603: oks_bill_sub_line_dtls bsd

5599: Cursor l_tot_csr Is
5600: SELECT NVL(Sum(NVL(bsd.Result,0)),0)
5601: FROM oks_bill_cont_lines bcl,
5602: oks_bill_sub_lines bsl,
5603: oks_bill_sub_line_dtls bsd
5604: WHERE bsl.cle_id = p_cle_id
5605: AND bsl.bcl_id = bcl.id
5606: AND bcl.bill_action ='RI'
5607: AND bsd.bsl_id = bsl.id;

Line 5724: FROM oks_bill_sub_line_dtls bsd,

5720: WHERE cle_id = p_cle_id;
5721:
5722: CURSOR total_billed_qty (p_cle_id IN NUMBER) IS
5723: SELECT sum(result)
5724: FROM oks_bill_sub_line_dtls bsd,
5725: oks_bill_sub_lines bsl
5726: WHERE bsl.cle_id = p_cle_id
5727: AND bsd.bsl_id = bsl.id;
5728:

Line 6406: FROM Oks_bill_sub_line_dtls ldtl

6402: l_ctr_rec l_ctr_csr%rowtype;
6403:
6404: Cursor l_actual_counter_csr(p_cle_id IN NUMBER) Is
6405: SELECT nvl(end_reading,0) qty
6406: FROM Oks_bill_sub_line_dtls ldtl
6407: ,oks_bill_sub_lines line
6408: WHERE line.cle_id = p_cle_id
6409: AND ldtl.bsl_id = line.id
6410: AND nvl(end_reading,0) > 0

Line 6427: FROM Oks_bill_sub_line_dtls ldtl

6423:
6424:
6425: Cursor l_actual_csr(p_cle_id IN NUMBER) Is
6426: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6427: FROM Oks_bill_sub_line_dtls ldtl
6428: ,oks_bill_sub_lines line
6429: WHERE line.cle_id = p_cle_id
6430: AND ldtl.bsl_id = line.id
6431: ORDER BY date_billed_to desc ;

Line 6446: FROM Oks_bill_sub_line_dtls ldtl

6442:
6443:
6444: Cursor l_ccr_id_csr Is
6445: SELECT end_reading read,ccr_id,cgr_id
6446: FROM Oks_bill_sub_line_dtls ldtl
6447: ,oks_bill_sub_lines line
6448: WHERE line.cle_id = p_cle_id
6449: AND ldtl.bsl_id = line.id
6450: -- Bug#4730007 nechatur 1-Dec-2005

Line 6519: FROM Oks_bill_sub_line_dtls ldtl

6515: --Bug#5235116
6516:
6517: Cursor l_actual_term_csr(p_cle_id IN NUMBER) Is
6518: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6519: FROM Oks_bill_sub_line_dtls ldtl
6520: ,oks_bill_sub_lines line
6521: WHERE line.cle_id = p_cle_id
6522: AND ldtl.bsl_id = line.id
6523: AND trunc(date_billed_from) < trunc(p_start_date)

Line 6989: UPDATE oks_bill_sub_line_dtls

6985: SET amount = round_amount,
6986: average = 0
6987: WHERE id = p_bsl_id;
6988:
6989: UPDATE oks_bill_sub_line_dtls
6990: SET amount = round_amount
6991: WHERE bsl_id = p_bsl_id;
6992:
6993: ELSIF (P_PRV = 2) THEN

Line 9918: oks_bill_sub_line_dtls bsd

9914: bsl.amount,
9915: bsd.result
9916: FROM oks_bill_cont_lines bcl,
9917: oks_bill_sub_lines bsl,
9918: oks_bill_sub_line_dtls bsd
9919: WHERE bcl.id = bsl.bcl_id
9920: AND bsl.cle_id = p_cle_id
9921: AND bsd.bsl_id = bsl.id
9922: ORDER by bsl.date_billed_to desc;