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 1294: FROM okc_k_lines_b kle

1290: is_top_line_flag boolean;
1291:
1292: CURSOR is_top_line ( p_cle_id NUMBER ) IS
1293: SELECT 1
1294: FROM okc_k_lines_b kle
1295: where kle.id = p_cle_id
1296: and kle.cle_id is null; -- it's top line
1297:
1298: CURSOR get_top_line ( p_cle_id NUMBER ) IS

Line 1300: from okc_k_lines_b cle--,

1296: and kle.cle_id is null; -- it's top line
1297:
1298: CURSOR get_top_line ( p_cle_id NUMBER ) IS
1299: select cle.id--, lse.lty_code
1300: from okc_k_lines_b cle--,
1301: -- okc_line_styles_b lse
1302: -- where lse.id = cle.lse_id
1303: -- and cle.cle_id is null
1304: where cle.cle_id is null -- it's top line

Line 1315: l_chr_id okc_k_lines_b.chr_id%TYPE;

1311: where cle.id = p_cle_id;
1312:
1313: --end:| 06-Apr-2007 cklee -- Fixed kle_id, asset_number issues |
1314:
1315: l_chr_id okc_k_lines_b.chr_id%TYPE;
1316:
1317: l_ship_to NUMBER;
1318:
1319: lx_customer_id NUMBER;

Line 1328: FROM okc_k_lines_b a,

1324:
1325: -- Code Changed for Bug 3044872
1326: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
1327: SELECT c.OBJECT1_ID1
1328: FROM okc_k_lines_b a,
1329: okc_line_styles_b b,
1330: okc_k_items c
1331: WHERE a.cle_id = p_fin_asset_line_id
1332: AND b.lty_code = 'ITEM'

Line 1355: okc_k_lines_b inst,

1351: csi.install_location_id
1352: , csi.location_id
1353: FROM csi_item_instances csi,
1354: okc_k_items cim,
1355: okc_k_lines_b inst,
1356: okc_k_lines_b ib,
1357: okc_line_styles_b lse
1358: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
1359: AND cim.cle_id = ib.id

Line 1356: okc_k_lines_b ib,

1352: , csi.location_id
1353: FROM csi_item_instances csi,
1354: okc_k_items cim,
1355: okc_k_lines_b inst,
1356: okc_k_lines_b ib,
1357: okc_line_styles_b lse
1358: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
1359: AND cim.cle_id = ib.id
1360: AND ib.cle_id = inst.id