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 1021: okc_k_lines_b kle,

1017: OKL_STREAMS stm,
1018: okl_strm_type_v sty,
1019: okc_k_headers_b khr,
1020: OKL_K_HEADERS khl,
1021: okc_k_lines_b kle,
1022: okc_statuses_b khs,
1023: okc_statuses_b kls
1024: WHERE ste.amount <> 0
1025: AND stm.id = ste.stm_id

Line 1358: , okc_k_lines_b cle

1354: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
1355: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1356: FROM okc_k_headers_b khr
1357: , okx_cust_site_uses_v cs
1358: , okc_k_lines_b cle
1359: , hz_customer_profiles cp
1360: WHERE khr.id = p_khr_id
1361: AND cle.dnz_chr_id = khr.id
1362: AND cle.chr_id IS NOT NULL

Line 1369: , okc_k_lines_b cle

1365: AND khr.bill_to_site_use_id = cp.site_use_id(+)
1366: UNION
1367: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1368: FROM okc_k_headers_b khr
1369: , okc_k_lines_b cle
1370: , okc_k_items item
1371: , okc_k_lines_b linked_asset
1372: , okx_cust_site_uses_v cs
1373: , hz_customer_profiles cp

Line 1371: , okc_k_lines_b linked_asset

1367: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1368: FROM okc_k_headers_b khr
1369: , okc_k_lines_b cle
1370: , okc_k_items item
1371: , okc_k_lines_b linked_asset
1372: , okx_cust_site_uses_v cs
1373: , hz_customer_profiles cp
1374: WHERE khr.id = p_khr_id
1375: AND cle.dnz_chr_id = khr.id

Line 1405: FROM okc_k_lines_b cle

1401: rul.rule_information_category = 'LAPMTH' AND
1402: rgp.dnz_chr_id = p_khr_id
1403: UNION
1404: SELECT rul.object1_id1
1405: FROM okc_k_lines_b cle
1406: , okc_k_items_v item
1407: , okc_k_lines_b linked_asset
1408: , OKC_RULES_B rul
1409: , Okc_rule_groups_B rgp

Line 1407: , okc_k_lines_b linked_asset

1403: UNION
1404: SELECT rul.object1_id1
1405: FROM okc_k_lines_b cle
1406: , okc_k_items_v item
1407: , okc_k_lines_b linked_asset
1408: , OKC_RULES_B rul
1409: , Okc_rule_groups_B rgp
1410: WHERE cle.dnz_chr_id = p_khr_id AND
1411: cle.id = p_kle_id AND

Line 1456: FROM okc_k_lines_b cle

1452: rul.rule_information_category = 'LABACC' AND
1453: rgp.dnz_chr_id = p_khr_id
1454: UNION
1455: SELECT rul.object1_id1
1456: FROM okc_k_lines_b cle
1457: , okc_k_items_v item
1458: , okc_k_lines_b linked_asset
1459: , OKC_RULES_B rul
1460: , Okc_rule_groups_B rgp

Line 1458: , okc_k_lines_b linked_asset

1454: UNION
1455: SELECT rul.object1_id1
1456: FROM okc_k_lines_b cle
1457: , okc_k_items_v item
1458: , okc_k_lines_b linked_asset
1459: , OKC_RULES_B rul
1460: , Okc_rule_groups_B rgp
1461: WHERE cle.dnz_chr_id = p_khr_id AND
1462: cle.id = p_kle_id AND

Line 1607: , okc_k_lines_b cle

1603: SELECT cle_inv.cust_acct_id, cs.cust_acct_site_id, hz.party_name
1604: ,hz.party_id -- Added by Venkatho as part of Bug# 15959293
1605: FROM okc_k_headers_b khr
1606: , okx_cust_site_uses_v cs
1607: , okc_k_lines_b cle
1608: , okc_k_lines_b cle_inv
1609: , okc_k_party_roles_b cpl
1610: , okc_k_party_roles_b cpl_inv
1611: , hz_parties hz

Line 1608: , okc_k_lines_b cle_inv

1604: ,hz.party_id -- Added by Venkatho as part of Bug# 15959293
1605: FROM okc_k_headers_b khr
1606: , okx_cust_site_uses_v cs
1607: , okc_k_lines_b cle
1608: , okc_k_lines_b cle_inv
1609: , okc_k_party_roles_b cpl
1610: , okc_k_party_roles_b cpl_inv
1611: , hz_parties hz
1612: WHERE khr.id = p_khr_id

Line 2414: 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

2410: -- rmunjulu R12 Fixes -- Populate NEW columns in tld_tbl -- start
2411: -- tld_tbl(l_tld_cnt).CONSOLIDATED_INVOICE_NUMBER := ; -- no need to populate as used for legacy data
2412: tld_tbl(l_tld_cnt).KHR_ID := p_bill_tbl(k).khr_id; -- need to populate this khr_id which is the denormalized one
2413: -- rmunjulu R12 Fixes -- Populate NEW columns in tld_tbl -- end
2414: 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
2415:
2416: -- rmunjulu R12 Fixes -- Populate ADDITIONAL columns in tld_tbl -- start
2417:
2418: -- make call to get invoice format API to get the formats

Line 2582: okc_k_lines_b kle,

2578: OKL_STREAMS stm,
2579: okl_strm_type_v sty,
2580: okc_k_headers_b khr,
2581: OKL_K_HEADERS khl,
2582: okc_k_lines_b kle,
2583: okc_statuses_b khs,
2584: okc_statuses_b kls
2585: WHERE TRUNC(ste.stream_element_date) >=
2586: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2635: okc_k_lines_b kle,

2631: OKL_STREAMS stm,
2632: okl_strm_type_v sty,
2633: okc_k_headers_b khr,
2634: OKL_K_HEADERS khl,
2635: okc_k_lines_b kle,
2636: okc_statuses_b khs,
2637: okc_statuses_b kls,
2638: okc_k_lines_b cle
2639: WHERE TRUNC(ste.stream_element_date) >= TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2638: okc_k_lines_b cle

2634: OKL_K_HEADERS khl,
2635: okc_k_lines_b kle,
2636: okc_statuses_b khs,
2637: okc_statuses_b kls,
2638: okc_k_lines_b cle
2639: WHERE TRUNC(ste.stream_element_date) >= TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2640: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + nvl(get_printing_lead_days(stm.khr_id), 0)))
2641: AND ste.amount <> 0
2642: AND stm.id = ste.stm_id

Line 2683: okc_k_lines_b kle,

2679: OKL_STREAMS stm,
2680: okl_strm_type_v sty,
2681: okc_k_headers_b khr,
2682: OKL_K_HEADERS khl,
2683: okc_k_lines_b kle,
2684: okc_statuses_b khs,
2685: okc_statuses_b kls
2686: WHERE TRUNC(ste.stream_element_date) >=
2687: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2744: okc_k_lines_b kle,

2740: OKL_STREAMS stm,
2741: okl_strm_type_v sty,
2742: okc_k_headers_b khr,
2743: OKL_K_HEADERS khl,
2744: okc_k_lines_b kle,
2745: okc_statuses_b khs,
2746: okc_statuses_b kls
2747: WHERE TRUNC(ste.stream_element_date) >=
2748: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2807: okc_k_lines_b kle,

2803: OKL_STREAMS stm,
2804: okl_strm_type_v sty,
2805: okc_k_headers_b khr,
2806: OKL_K_HEADERS khl,
2807: okc_k_lines_b kle,
2808: okc_statuses_b khs,
2809: okc_statuses_b kls
2810: WHERE TRUNC(ste.stream_element_date) >=
2811: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2859: okc_k_lines_b kle,

2855: OKL_STREAMS stm,
2856: okl_strm_type_v sty,
2857: okc_k_headers_b khr,
2858: OKL_K_HEADERS khl,
2859: okc_k_lines_b kle,
2860: okc_statuses_b khs,
2861: okc_statuses_b kls,
2862: okc_k_lines_b cle
2863: WHERE TRUNC(ste.stream_element_date) >=

Line 2862: okc_k_lines_b cle

2858: OKL_K_HEADERS khl,
2859: okc_k_lines_b kle,
2860: okc_statuses_b khs,
2861: okc_statuses_b kls,
2862: okc_k_lines_b cle
2863: WHERE TRUNC(ste.stream_element_date) >=
2864: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
2865: AND TRUNC(ste.stream_element_date) <= TRUNC((NVL (p_to_bill_date, SYSDATE) + get_printing_lead_days(stm.khr_id)))
2866: AND ste.amount <> 0

Line 2908: okc_k_lines_b kle,

2904: OKL_STREAMS stm,
2905: okl_strm_type_v sty,
2906: okc_k_headers_b khr,
2907: OKL_K_HEADERS khl,
2908: okc_k_lines_b kle,
2909: okc_statuses_b khs,
2910: okc_statuses_b kls
2911: WHERE TRUNC(ste.stream_element_date) >=
2912: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 2968: okc_k_lines_b kle,

2964: OKL_STREAMS stm,
2965: okl_strm_type_v sty,
2966: okc_k_headers_b khr,
2967: OKL_K_HEADERS khl,
2968: okc_k_lines_b kle,
2969: okc_statuses_b khs,
2970: okc_statuses_b kls
2971: WHERE TRUNC(ste.stream_element_date) >=
2972: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))

Line 3031: okc_k_lines_b kle,

3027: OKL_STREAMS stm,
3028: okl_strm_type_v sty,
3029: okc_k_headers_b khr,
3030: OKL_K_HEADERS khl,
3031: okc_k_lines_b kle,
3032: okc_statuses_b khs,
3033: okc_statuses_b kls,
3034: OKL_PARALLEL_PROCESSES pws
3035: WHERE TRUNC(ste.stream_element_date) >=

Line 3086: okc_k_lines_b kle,

3082: OKL_STREAMS stm,
3083: okl_strm_type_v sty,
3084: okc_k_headers_b khr,
3085: OKL_K_HEADERS khl,
3086: okc_k_lines_b kle,
3087: okc_statuses_b khs,
3088: okc_statuses_b kls,
3089: okc_k_lines_b cle,
3090: OKL_PARALLEL_PROCESSES pws

Line 3089: okc_k_lines_b cle,

3085: OKL_K_HEADERS khl,
3086: okc_k_lines_b kle,
3087: okc_statuses_b khs,
3088: okc_statuses_b kls,
3089: okc_k_lines_b cle,
3090: OKL_PARALLEL_PROCESSES pws
3091: WHERE TRUNC(ste.stream_element_date) >=
3092: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
3093: AND TRUNC(ste.stream_element_date) <=

Line 3139: okc_k_lines_b kle,

3135: OKL_STREAMS stm,
3136: okl_strm_type_v sty,
3137: okc_k_headers_b khr,
3138: OKL_K_HEADERS khl,
3139: okc_k_lines_b kle,
3140: okc_statuses_b khs,
3141: okc_statuses_b kls,
3142: OKL_PARALLEL_PROCESSES pws
3143: WHERE TRUNC(ste.stream_element_date) >=

Line 3202: okc_k_lines_b kle,

3198: OKL_STREAMS stm,
3199: okl_strm_type_v sty,
3200: okc_k_headers_b khr,
3201: OKL_K_HEADERS khl,
3202: okc_k_lines_b kle,
3203: okc_statuses_b khs,
3204: okc_statuses_b kls,
3205: OKL_PARALLEL_PROCESSES pws
3206: WHERE TRUNC(ste.stream_element_date) >=