eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BILL_UTIL_PUB dependencies on OKS_BILL_SUB_LINES

Line 936: (select /+ push_subq no_unnest / 1 from oks_bill_sub_lines bsl /* Added hint for Bug#12416004*/

932: AND le.rul_id = str.id
933: AND le.date_completed IS NULL
934: AND trunc(nvl(le.date_to_interface,sysdate)) <= trunc(p_date)
935: AND not exists
936: (select /*+ push_subq no_unnest */ 1 from oks_bill_sub_lines bsl /* Added hint for Bug#12416004*/
937: where le.cle_id = bsl.cle_id
938: and trunc(le.date_start) >= trunc(bsl.date_billed_from)
939: and trunc(le.date_end) <= trunc(bsl.date_billed_to))
940: ORDER BY le.date_start;

Line 972: FROM oks_bill_sub_lines

968:
969:
970: Cursor l_bsl_csr(p_cle_id IN NUMBER) is
971: SELECT max(date_billed_to)
972: FROM oks_bill_sub_lines
973: WHERE cle_id = p_cle_id;
974:
975: level_element_rec L_CSR_LEVEL_ELEMENTS%ROWTYPE;
976: i NUMBER := 1;

Line 2271: FROM Oks_bill_cont_lines bcl, Oks_bill_sub_lines bsl

2267: IS
2268:
2269: CURSOR l_credit_amt_csr IS
2270: SELECT nvl(SUM(bsl.amount),0) tot_credit_amt
2271: FROM Oks_bill_cont_lines bcl, Oks_bill_sub_lines bsl
2272: WHERE bsl.Cle_id = p_cp_line_id
2273: AND bcl.id = bsl.bcl_id
2274: AND bcl.bill_action = 'TR';
2275:

Line 4012: FROM OKS_BILL_SUB_LINES

4008: WHERE cle_id = p_cp_id;
4009:
4010: CURSOR L_GET_BSL_CSR ( P_ID NUMBER ) IS
4011: SELECT 1
4012: FROM OKS_BILL_SUB_LINES
4013: WHERE CLE_ID = P_ID ;
4014:
4015: /*Added for ER 16039380*/
4016:

Line 4081: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.

4077: L_BSLV_REC_IN.DATE_BILLED_TO := l_end_date;
4078: L_BSLV_REC_IN.AMOUNT := L_TOTAL_AMOUNT;
4079: L_BSLV_REC_IN.AVERAGE := 0;
4080: ------------------------------------------------------------------------------
4081: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.
4082: ------------------------------------------------------------------------------
4083: OKS_BILLSUBLINE_PUB.INSERT_BILL_SUBLINE_PUB
4084: (
4085: P_API_VERSION => 1.0,

Line 4144: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.

4140: L_BSLV_REC_IN.DATE_BILLED_TO := L_GET_COVERED_LEVELS_REC.COVERED_LEVEL_END_DATE;
4141: L_BSLV_REC_IN.AMOUNT := L_GET_COVERED_LEVELS_REC.PRICE_NEGOTIATED;
4142: L_BSLV_REC_IN.AVERAGE := 0;
4143: ------------------------------------------------------------------------------
4144: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.
4145: ------------------------------------------------------------------------------
4146: OKS_BILLSUBLINE_PUB.INSERT_BILL_SUBLINE_PUB
4147: (
4148: P_API_VERSION => 1.0,

Line 4396: FROM OKS_BILL_SUB_LINES

4392: FROM okc_k_items
4393: WHERE cle_id = p_cp_id;
4394: CURSOR L_GET_BSL_CSR ( P_ID NUMBER ) IS
4395: SELECT 1
4396: FROM OKS_BILL_SUB_LINES
4397: WHERE CLE_ID = P_ID ;
4398: CURSOR L_Line_Type is
4399: SELECT lse_id
4400: FROM OKC_K_LINES_B

Line 4435: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.

4431: L_BSLV_REC_IN.DATE_BILLED_TO := P_DATE_TO;
4432: L_BSLV_REC_IN.AMOUNT := L_TOTAL_AMOUNT;
4433: L_BSLV_REC_IN.AVERAGE := 0;
4434: ------------------------------------------------------------------------------
4435: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.
4436: ------------------------------------------------------------------------------
4437: OKS_BILLSUBLINE_PUB.INSERT_BILL_SUBLINE_PUB
4438: (
4439: P_API_VERSION => 1.0,

Line 4506: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.

4502: L_BSLV_REC_IN.DATE_BILLED_TO := P_DATE_TO;
4503: L_BSLV_REC_IN.AMOUNT := L_TOTAL_AMOUNT;
4504: L_BSLV_REC_IN.AVERAGE := 0;
4505: ------------------------------------------------------------------------------
4506: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.
4507: ------------------------------------------------------------------------------
4508: OKS_BILLSUBLINE_PUB.INSERT_BILL_SUBLINE_PUB
4509: (
4510: P_API_VERSION => 1.0,

Line 4724: From oks_bill_sub_lines

4720: Where cle_id = p_id;
4721:
4722: Cursor l_bill_sub_line_csr IS
4723: Select Trunc(Max(date_billed_to))
4724: From oks_bill_sub_lines
4725: Where cle_id = p_id;
4726:
4727: l_billed_upto Date := Null;
4728: Begin

Line 4844: FROM oks_bill_sub_lines

4840: bcl_id, amount, average, date_to_interface,
4841: attribute_category,attribute1,attribute2,attribute3,attribute4 ,
4842: attribute5,attribute6,attribute7,attribute8,attribute9,
4843: attribute10,attribute11,attribute12,attribute13,attribute14,attribute15
4844: FROM oks_bill_sub_lines
4845: WHERE cle_id = p_old_cp_id
4846: ORDER BY date_billed_from;
4847:
4848: CURSOR l_bsd_csr (p_bsl_id NUMBER)IS

Line 4961: UPDATE oks_bill_sub_lines

4957: RAISE G_EXCEPTION_HALT_VALIDATION;
4958: END IF;
4959:
4960: ---update old bsl record
4961: UPDATE oks_bill_sub_lines
4962: SET amount = nvl(amount,0) - nvl(p_new_cp_lvl_tbl(l_index).amount, 0)
4963: WHERE id = l_bsl_rec.id;
4964:
4965: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

Line 5221: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl

5217:
5218:
5219: CURSOR l_bsl_csr (p_cp_id NUMBER) IS
5220: SELECT max(bsl.date_billed_to) max_billed_to , nvl(SUM(bsl.amount),0) bill_amt
5221: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl
5222: WHERE bsl.cle_id = p_cp_id
5223: AND bsl.bcl_id = bcl.id
5224: AND bcl.bill_action = 'RI';
5225: