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_STREAM_BILLING_PVT dependencies on OKC_K_LINES_B

Line 959: okc_k_lines_b kle,

955: OKL_STREAMS stm,
956: okl_strm_type_v sty,
957: okc_k_headers_b khr,
958: OKL_K_HEADERS khl,
959: okc_k_lines_b kle,
960: okc_statuses_b khs,
961: okc_statuses_b kls
962: WHERE ste.amount <> 0
963: AND stm.id = ste.stm_id

Line 1296: , okc_k_lines_b cle

1292: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
1293: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1294: FROM okc_k_headers_b khr
1295: , okx_cust_site_uses_v cs
1296: , okc_k_lines_b cle
1297: , hz_customer_profiles cp
1298: WHERE khr.id = p_khr_id
1299: AND cle.dnz_chr_id = khr.id
1300: AND cle.chr_id IS NOT NULL

Line 1307: , okc_k_lines_b cle

1303: AND khr.bill_to_site_use_id = cp.site_use_id(+)
1304: UNION
1305: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1306: FROM okc_k_headers_b khr
1307: , okc_k_lines_b cle
1308: , okc_k_items item
1309: , okc_k_lines_b linked_asset
1310: , okx_cust_site_uses_v cs
1311: , hz_customer_profiles cp

Line 1309: , okc_k_lines_b linked_asset

1305: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1306: FROM okc_k_headers_b khr
1307: , okc_k_lines_b cle
1308: , okc_k_items item
1309: , okc_k_lines_b linked_asset
1310: , okx_cust_site_uses_v cs
1311: , hz_customer_profiles cp
1312: WHERE khr.id = p_khr_id
1313: AND cle.dnz_chr_id = khr.id

Line 1343: FROM okc_k_lines_b cle

1339: rul.rule_information_category = 'LAPMTH' AND
1340: rgp.dnz_chr_id = p_khr_id
1341: UNION
1342: SELECT rul.object1_id1
1343: FROM okc_k_lines_b cle
1344: , okc_k_items_v item
1345: , okc_k_lines_b linked_asset
1346: , OKC_RULES_B rul
1347: , Okc_rule_groups_B rgp

Line 1345: , okc_k_lines_b linked_asset

1341: UNION
1342: SELECT rul.object1_id1
1343: FROM okc_k_lines_b cle
1344: , okc_k_items_v item
1345: , okc_k_lines_b linked_asset
1346: , OKC_RULES_B rul
1347: , Okc_rule_groups_B rgp
1348: WHERE cle.dnz_chr_id = p_khr_id AND
1349: cle.id = p_kle_id AND

Line 1394: FROM okc_k_lines_b cle

1390: rul.rule_information_category = 'LABACC' AND
1391: rgp.dnz_chr_id = p_khr_id
1392: UNION
1393: SELECT rul.object1_id1
1394: FROM okc_k_lines_b cle
1395: , okc_k_items_v item
1396: , okc_k_lines_b linked_asset
1397: , OKC_RULES_B rul
1398: , Okc_rule_groups_B rgp

Line 1396: , okc_k_lines_b linked_asset

1392: UNION
1393: SELECT rul.object1_id1
1394: FROM okc_k_lines_b cle
1395: , okc_k_items_v item
1396: , okc_k_lines_b linked_asset
1397: , OKC_RULES_B rul
1398: , Okc_rule_groups_B rgp
1399: WHERE cle.dnz_chr_id = p_khr_id AND
1400: cle.id = p_kle_id AND

Line 1543: , okc_k_lines_b cle

1539: CURSOR get_inv_cust_info(p_khr_id NUMBER, p_kle_id NUMBER) IS
1540: SELECT cle_inv.cust_acct_id, cs.cust_acct_site_id, hz.party_name
1541: FROM okc_k_headers_b khr
1542: , okx_cust_site_uses_v cs
1543: , okc_k_lines_b cle
1544: , okc_k_lines_b cle_inv
1545: , okc_k_party_roles_b cpl
1546: , okc_k_party_roles_b cpl_inv
1547: , hz_parties hz

Line 1544: , okc_k_lines_b cle_inv

1540: SELECT cle_inv.cust_acct_id, cs.cust_acct_site_id, hz.party_name
1541: FROM okc_k_headers_b khr
1542: , okx_cust_site_uses_v cs
1543: , okc_k_lines_b cle
1544: , okc_k_lines_b cle_inv
1545: , okc_k_party_roles_b cpl
1546: , okc_k_party_roles_b cpl_inv
1547: , hz_parties hz
1548: WHERE khr.id = p_khr_id

Line 2233: tld_tbl(l_tld_cnt).KLE_ID := p_bill_tbl(k).kle_id; -- cklee 3/22/07 - added okc_k_lines_b.id as FK directly

2229: -- rmunjulu R12 Fixes -- Populate NEW columns in tld_tbl -- start
2230: -- tld_tbl(l_tld_cnt).CONSOLIDATED_INVOICE_NUMBER := ; -- no need to populate as used for legacy data
2231: tld_tbl(l_tld_cnt).KHR_ID := p_bill_tbl(k).khr_id; -- need to populate this khr_id which is the denormalized one
2232: -- rmunjulu R12 Fixes -- Populate NEW columns in tld_tbl -- end
2233: tld_tbl(l_tld_cnt).KLE_ID := p_bill_tbl(k).kle_id; -- cklee 3/22/07 - added okc_k_lines_b.id as FK directly
2234:
2235: -- rmunjulu R12 Fixes -- Populate ADDITIONAL columns in tld_tbl -- start
2236:
2237: -- make call to get invoice format API to get the formats

Line 2398: okc_k_lines_b kle,

2394: OKL_STREAMS stm,
2395: okl_strm_type_v sty,
2396: okc_k_headers_b khr,
2397: OKL_K_HEADERS khl,
2398: okc_k_lines_b kle,
2399: okc_statuses_b khs,
2400: okc_statuses_b kls
2401: WHERE TRUNC(ste.stream_element_date) >=
2402: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2451: okc_k_lines_b kle,

2447: OKL_STREAMS stm,
2448: okl_strm_type_v sty,
2449: okc_k_headers_b khr,
2450: OKL_K_HEADERS khl,
2451: okc_k_lines_b kle,
2452: okc_statuses_b khs,
2453: okc_statuses_b kls,
2454: okc_k_lines_b cle
2455: WHERE TRUNC(ste.stream_element_date) >= TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2454: okc_k_lines_b cle

2450: OKL_K_HEADERS khl,
2451: okc_k_lines_b kle,
2452: okc_statuses_b khs,
2453: okc_statuses_b kls,
2454: okc_k_lines_b cle
2455: WHERE TRUNC(ste.stream_element_date) >= TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2456: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + nvl(get_printing_lead_days(stm.khr_id), 0)))
2457: AND ste.amount <> 0
2458: AND stm.id = ste.stm_id

Line 2499: okc_k_lines_b kle,

2495: OKL_STREAMS stm,
2496: okl_strm_type_v sty,
2497: okc_k_headers_b khr,
2498: OKL_K_HEADERS khl,
2499: okc_k_lines_b kle,
2500: okc_statuses_b khs,
2501: okc_statuses_b kls
2502: WHERE TRUNC(ste.stream_element_date) >=
2503: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2560: okc_k_lines_b kle,

2556: OKL_STREAMS stm,
2557: okl_strm_type_v sty,
2558: okc_k_headers_b khr,
2559: OKL_K_HEADERS khl,
2560: okc_k_lines_b kle,
2561: okc_statuses_b khs,
2562: okc_statuses_b kls
2563: WHERE TRUNC(ste.stream_element_date) >=
2564: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2620: okc_k_lines_b kle,

2616: OKL_STREAMS stm,
2617: okl_strm_type_v sty,
2618: okc_k_headers_b khr,
2619: OKL_K_HEADERS khl,
2620: okc_k_lines_b kle,
2621: okc_statuses_b khs,
2622: okc_statuses_b kls
2623: WHERE TRUNC(ste.stream_element_date) >=
2624: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2672: okc_k_lines_b kle,

2668: OKL_STREAMS stm,
2669: okl_strm_type_v sty,
2670: okc_k_headers_b khr,
2671: OKL_K_HEADERS khl,
2672: okc_k_lines_b kle,
2673: okc_statuses_b khs,
2674: okc_statuses_b kls,
2675: okc_k_lines_b cle
2676: WHERE TRUNC(ste.stream_element_date) >=

Line 2675: okc_k_lines_b cle

2671: OKL_K_HEADERS khl,
2672: okc_k_lines_b kle,
2673: okc_statuses_b khs,
2674: okc_statuses_b kls,
2675: okc_k_lines_b cle
2676: WHERE TRUNC(ste.stream_element_date) >=
2677: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2678: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))
2679: AND ste.amount <> 0

Line 2721: okc_k_lines_b kle,

2717: OKL_STREAMS stm,
2718: okl_strm_type_v sty,
2719: okc_k_headers_b khr,
2720: OKL_K_HEADERS khl,
2721: okc_k_lines_b kle,
2722: okc_statuses_b khs,
2723: okc_statuses_b kls
2724: WHERE TRUNC(ste.stream_element_date) >=
2725: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2781: okc_k_lines_b kle,

2777: OKL_STREAMS stm,
2778: okl_strm_type_v sty,
2779: okc_k_headers_b khr,
2780: OKL_K_HEADERS khl,
2781: okc_k_lines_b kle,
2782: okc_statuses_b khs,
2783: okc_statuses_b kls
2784: WHERE TRUNC(ste.stream_element_date) >=
2785: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2841: okc_k_lines_b kle,

2837: OKL_STREAMS stm,
2838: okl_strm_type_v sty,
2839: okc_k_headers_b khr,
2840: OKL_K_HEADERS khl,
2841: okc_k_lines_b kle,
2842: okc_statuses_b khs,
2843: okc_statuses_b kls,
2844: OKL_PARALLEL_PROCESSES pws
2845: WHERE TRUNC(ste.stream_element_date) >=

Line 2896: okc_k_lines_b kle,

2892: OKL_STREAMS stm,
2893: okl_strm_type_v sty,
2894: okc_k_headers_b khr,
2895: OKL_K_HEADERS khl,
2896: okc_k_lines_b kle,
2897: okc_statuses_b khs,
2898: okc_statuses_b kls,
2899: okc_k_lines_b cle,
2900: OKL_PARALLEL_PROCESSES pws

Line 2899: okc_k_lines_b cle,

2895: OKL_K_HEADERS khl,
2896: okc_k_lines_b kle,
2897: okc_statuses_b khs,
2898: okc_statuses_b kls,
2899: okc_k_lines_b cle,
2900: OKL_PARALLEL_PROCESSES pws
2901: WHERE TRUNC(ste.stream_element_date) >=
2902: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2903: AND TRUNC(ste.stream_element_date) <=

Line 2949: okc_k_lines_b kle,

2945: OKL_STREAMS stm,
2946: okl_strm_type_v sty,
2947: okc_k_headers_b khr,
2948: OKL_K_HEADERS khl,
2949: okc_k_lines_b kle,
2950: okc_statuses_b khs,
2951: okc_statuses_b kls,
2952: OKL_PARALLEL_PROCESSES pws
2953: WHERE TRUNC(ste.stream_element_date) >=

Line 3012: okc_k_lines_b kle,

3008: OKL_STREAMS stm,
3009: okl_strm_type_v sty,
3010: okc_k_headers_b khr,
3011: OKL_K_HEADERS khl,
3012: okc_k_lines_b kle,
3013: okc_statuses_b khs,
3014: okc_statuses_b kls,
3015: OKL_PARALLEL_PROCESSES pws
3016: WHERE TRUNC(ste.stream_element_date) >=