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

Line 78: from okc_k_lines_b

74: l_khr_id okc_k_headers_b.id%type;
75:
76: CURSOR get_chr_id (p_kle_id NUMBER) IS
77: select dnz_chr_id
78: from okc_k_lines_b
79: where id = p_kle_id;
80:
81: -- nikshah -- Bug # 5484903 Fixed,
82: -- Changed CURSOR line_bill_to_csr SQL definition

Line 87: , okc_k_lines_b cle

83: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
84: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
85: FROM okc_k_headers_b khr
86: , okx_cust_site_uses_v cs
87: , okc_k_lines_b cle
88: , hz_customer_profiles cp
89: WHERE khr.id = p_khr_id
90: AND cle.dnz_chr_id = khr.id
91: AND cle.chr_id IS NOT NULL

Line 98: , okc_k_lines_b cle

94: AND khr.bill_to_site_use_id = cp.site_use_id(+)
95: UNION
96: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
97: FROM okc_k_headers_b khr
98: , okc_k_lines_b cle
99: , okc_k_items item
100: , okc_k_lines_b linked_asset
101: , okx_cust_site_uses_v cs
102: , hz_customer_profiles cp

Line 100: , okc_k_lines_b linked_asset

96: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
97: FROM okc_k_headers_b khr
98: , okc_k_lines_b cle
99: , okc_k_items item
100: , okc_k_lines_b linked_asset
101: , okx_cust_site_uses_v cs
102: , hz_customer_profiles cp
103: WHERE khr.id = p_khr_id
104: AND cle.dnz_chr_id = khr.id

Line 123: FROM okc_k_lines_b cle

119: rul.rule_information_category = 'LAPMTH' AND
120: rgp.dnz_chr_id = p_khr_id
121: UNION
122: SELECT rul.object1_id1
123: FROM okc_k_lines_b cle
124: , okc_k_items_v item
125: , okc_k_lines_b linked_asset
126: , OKC_RULES_B rul
127: , Okc_rule_groups_B rgp

Line 125: , okc_k_lines_b linked_asset

121: UNION
122: SELECT rul.object1_id1
123: FROM okc_k_lines_b cle
124: , okc_k_items_v item
125: , okc_k_lines_b linked_asset
126: , OKC_RULES_B rul
127: , Okc_rule_groups_B rgp
128: WHERE cle.dnz_chr_id = p_khr_id AND
129: cle.id = p_kle_id AND

Line 163: FROM okc_k_lines_b cle

159: rul.rule_information_category = 'LABACC' AND
160: rgp.dnz_chr_id = p_khr_id
161: UNION
162: SELECT rul.object1_id1
163: FROM okc_k_lines_b cle
164: , okc_k_items_v item
165: , okc_k_lines_b linked_asset
166: , OKC_RULES_B rul
167: , Okc_rule_groups_B rgp

Line 165: , okc_k_lines_b linked_asset

161: UNION
162: SELECT rul.object1_id1
163: FROM okc_k_lines_b cle
164: , okc_k_items_v item
165: , okc_k_lines_b linked_asset
166: , OKC_RULES_B rul
167: , Okc_rule_groups_B rgp
168: WHERE cle.dnz_chr_id = p_khr_id AND
169: cle.id = p_kle_id AND

Line 2259: FROM okc_k_lines_b kle

2255: is_top_line_flag boolean;
2256:
2257: CURSOR is_top_line ( p_cle_id NUMBER ) IS
2258: SELECT 1
2259: FROM okc_k_lines_b kle
2260: where kle.id = p_cle_id
2261: and kle.cle_id is null; -- it's top line
2262:
2263: CURSOR get_top_line ( p_cle_id NUMBER ) IS

Line 2265: from okc_k_lines_b cle--,

2261: and kle.cle_id is null; -- it's top line
2262:
2263: CURSOR get_top_line ( p_cle_id NUMBER ) IS
2264: select cle.id--, lse.lty_code
2265: from okc_k_lines_b cle--,
2266: -- okc_line_styles_b lse
2267: -- where lse.id = cle.lse_id
2268: -- and cle.cle_id is null
2269: where cle.cle_id is null -- it's top line

Line 2280: l_chr_id okc_k_lines_b.chr_id%TYPE;

2276: where cle.id = p_cle_id;
2277:
2278: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
2279:
2280: l_chr_id okc_k_lines_b.chr_id%TYPE;
2281:
2282: l_ship_to NUMBER;
2283:
2284: lx_customer_id NUMBER;

Line 2294: FROM okc_k_lines_b a,

2290:
2291: -- Code Changed for Bug 3044872
2292: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
2293: SELECT c.OBJECT1_ID1
2294: FROM okc_k_lines_b a,
2295: okc_line_styles_b b,
2296: okc_k_items c
2297: WHERE a.cle_id = p_fin_asset_line_id
2298: AND b.lty_code = 'ITEM'

Line 2321: okc_k_lines_b inst,

2317: csi.install_location_id
2318: , csi.location_id
2319: FROM csi_item_instances csi,
2320: okc_k_items cim,
2321: okc_k_lines_b inst,
2322: okc_k_lines_b ib,
2323: okc_line_styles_b lse
2324: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
2325: AND cim.cle_id = ib.id

Line 2322: okc_k_lines_b ib,

2318: , csi.location_id
2319: FROM csi_item_instances csi,
2320: okc_k_items cim,
2321: okc_k_lines_b inst,
2322: okc_k_lines_b ib,
2323: okc_line_styles_b lse
2324: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
2325: AND cim.cle_id = ib.id
2326: AND ib.cle_id = inst.id