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.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_STRM_TYPE_B

Line 38: okl_strm_type_b sty,

34: -- Begin bug 6456733
35: -- dcshanmu bug 6734738 start
36: SELECT NVL(SUM(AMOUNT),0) interest_billed_amount
37: FROM okl_bpd_ar_inv_lines_v lpt,
38: okl_strm_type_b sty,
39: ar_payment_schedules_all aps,
40: okl_k_headers_full_v khr
41: WHERE lpt.contract_id = cp_khr_id
42: AND (cp_kle_id IS NULL OR (cp_kle_id IS NOT NULL AND lpt.contract_line_id = cp_kle_id))

Line 128: okl_strm_type_b sty,

124: FROM
125: (
126: SELECT NVL(SUM(AMOUNT),0)- NVL(SUM(LINE_AMOUNT_REMAINING_WOTAX),0) interest_paid_amount
127: FROM okl_bpd_ar_inv_lines_v lpt1,
128: okl_strm_type_b sty,
129: ar_payment_schedules_all aps,
130: okc_k_headers_b khr
131: WHERE contract_id=cp_khr_id
132: AND lpt1.contract_id = khr.id

Line 714: okl_strm_type_b sty,

710: FROM
711: (
712: SELECT SUM(AMOUNT)- SUM(LINE_AMOUNT_REMAINING_WOTAX) principal_paid_amount
713: FROM okl_bpd_ar_inv_lines_v lpt1,
714: okl_strm_type_b sty,
715: ar_payment_schedules_all aps,
716: okc_k_headers_b khr
717: WHERE contract_id=cp_khr_id
718: AND lpt1.contract_id = khr.id

Line 759: okl_strm_type_b sty,

755: (
756: SELECT RECEIVABLES_INVOICE_ID
757: FROM
758: okl_bpd_ar_inv_lines_v lpt,
759: okl_strm_type_b sty,
760: ar_payment_schedules_all aps,
761: okl_k_headers_full_v khr
762: WHERE
763: lpt.contract_id = lpt1.contract_id

Line 1210: okl_strm_type_b sty,

1206: --(
1207: SELECT NVL(SUM(AMOUNT),0) principal_billed_amount --RECEIVABLES_INVOICE_ID
1208: -- dcshanmu bug 6734738 end
1209: FROM okl_bpd_ar_inv_lines_v lpt,
1210: okl_strm_type_b sty,
1211: ar_payment_schedules_all aps,
1212: okl_k_headers_full_v khr
1213: WHERE
1214: -- dcshanmu bug 6734738 start

Line 1233: --okl_strm_type_b sty,

1229:
1230: -- SELECT NVL(SUM(aps.amount_due_original), 0) principal_billed_amount
1231: --SELECT NVL(sum(aps.amount_line_items_original), 0) principal_billed_amount --End bug#5767426
1232: --FROM okl_bpd_tld_ar_lines_v tld,
1233: --okl_strm_type_b sty,
1234: --ar_payment_schedules_all aps,
1235: --okl_k_headers_full_v khr
1236: --WHERE tld.khr_id = cp_khr_id
1237: --AND tld.kle_id = NVL(cp_kle_id, tld.kle_id)

Line 1324: okl_strm_type_b sty,

1320: and RECEIVABLES_INVOICE_ID in
1321: (
1322: SELECT lpt.RECEIVABLES_INVOICE_ID
1323: FROM okl_bpd_ar_inv_lines_v lpt,
1324: okl_strm_type_b sty,
1325: ar_payment_schedules_all aps,
1326: okl_k_headers_full_v khr
1327: WHERE lpt.contract_id = lpt1.contract_id
1328: AND lpt.contract_number = khr.contract_number

Line 1337: --okl_strm_type_b sty,

1333: );
1334:
1335: --SELECT NVL(SUM(aps.amount_due_original), 0) interest_billed_amount
1336: --FROM okl_bpd_tld_ar_lines_v tld,
1337: --okl_strm_type_b sty,
1338: --ar_payment_schedules_all aps,
1339: --okc_k_headers_b khr
1340: --WHERE tld.khr_id = cp_khr_id
1341: --AND tld.khr_id = khr.id

Line 1425: okl_strm_type_b sty,

1421: and RECEIVABLES_INVOICE_ID in
1422: (
1423: SELECT lpt.RECEIVABLES_INVOICE_ID
1424: FROM okl_bpd_ar_inv_lines_v lpt,
1425: okl_strm_type_b sty,
1426: ar_payment_schedules_all aps,
1427: okl_k_headers_full_v khr
1428: WHERE lpt.contract_id = lpt1.contract_id
1429: AND lpt.contract_number = khr.contract_number

Line 1438: --okl_strm_type_b sty,

1434: );
1435:
1436: --SELECT NVL(SUM(aps.amount_due_original), 0) loan_billed_amount
1437: --FROM okl_bpd_tld_ar_lines_v tld,
1438: --okl_strm_type_b sty,
1439: --ar_payment_schedules_all aps,
1440: --okl_k_headers_full_v khr
1441: --WHERE tld.khr_id = cp_khr_id
1442: --AND tld.khr_id = khr.id

Line 1528: okl_strm_type_b sty,

1524: and RECEIVABLES_INVOICE_ID in
1525: (
1526: SELECT lpt.RECEIVABLES_INVOICE_ID
1527: FROM okl_bpd_ar_inv_lines_v lpt,
1528: okl_strm_type_b sty,
1529: ar_payment_schedules_all aps,
1530: okl_k_headers_full_v khr
1531: WHERE lpt.contract_id = lpt1.contract_id
1532: AND lpt.contract_number = khr.contract_number

Line 1833: okl_strm_type_b sty

1829: SELECT NVL(rul2.rule_information10,'N') arrears_yn
1830: FROM okc_rule_groups_b rgp,
1831: okc_rules_b rul1,
1832: okc_rules_b rul2,
1833: okl_strm_type_b sty
1834: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
1835: AND rul2.rule_information_category = 'LASLL'
1836: AND rul2.rgp_id = rgp.id
1837: AND rgp.cle_id IS NULL

Line 2125: okl_strm_type_b sty,

2121: lpt.TXD_ID tld_id,
2122: aps.customer_trx_id receivables_invoice_id
2123: FROM
2124: okl_bpd_ar_inv_lines_v lpt,
2125: okl_strm_type_b sty,
2126: ar_payment_schedules_all aps,
2127: okl_k_headers_full_v khr
2128: WHERE
2129: lpt.CONTRACT_ID = cp_khr_id

Line 2147: --okl_strm_type_b sty

2143: -- lsm.receivables_invoice_id
2144: --sch.customer_trx_id receivables_invoice_id
2145: --FROM okl_bpd_tld_ar_lines_v tld,
2146: --ar_payment_schedules_all sch,
2147: --okl_strm_type_b sty
2148: --WHERE sch.customer_trx_id = tld.customer_trx_id
2149: --AND sch.status = 'OP'
2150: --AND sch.class = 'INV'
2151: --AND tld.khr_id = cp_khr_id

Line 2520: ,okl_strm_type_b sty

2516: SELECT 'Y',
2517: chr.contract_number
2518: FROM okl_strm_elements sel
2519: ,okl_streams str
2520: ,okl_strm_type_b sty
2521: ,okc_k_headers_b chr
2522: WHERE chr.id = p_khr_id
2523: AND sel.stm_id = str.id
2524: AND str.khr_id = chr.id