APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_K_ITEMS

Line 96: , okc_k_items item

92: UNION
93: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
94: FROM okc_k_headers_b khr
95: , okc_k_lines_b cle
96: , okc_k_items item
97: , okc_k_lines_b linked_asset
98: , okx_cust_site_uses_v cs
99: , hz_customer_profiles cp
100: WHERE khr.id = p_khr_id

Line 132: , okc_k_items_v item

128: rgp.dnz_chr_id = p_khr_id
129: UNION
130: SELECT rul.object1_id1
131: FROM okc_k_lines_b cle
132: , okc_k_items_v item
133: , okc_k_lines_b linked_asset
134: , OKC_RULES_B rul
135: , Okc_rule_groups_B rgp
136: WHERE cle.dnz_chr_id = p_khr_id AND

Line 170: , okc_k_items_v item

166: rgp.dnz_chr_id = p_khr_id
167: UNION
168: SELECT rul.object1_id1
169: FROM okc_k_lines_b cle
170: , okc_k_items_v item
171: , okc_k_lines_b linked_asset
172: , OKC_RULES_B rul
173: , Okc_rule_groups_B rgp
174: WHERE cle.dnz_chr_id = p_khr_id AND

Line 697: OKC_K_ITEMS CIM,

693: OKC_K_LINES_B TOP_CLE,
694: OKC_LINE_STYLES_b TOP_LSE,
695: OKC_K_LINES_B SUB_CLE,
696: OKC_LINE_STYLES_b SUB_LSE,
697: OKC_K_ITEMS CIM,
698: OKC_K_LINES_V FA,
699: OKC_LINE_STYLES_B AST_LSE,
700: OKL_CNSLD_AR_STRMS_B LSM
701: WHERE

Line 730: okc_k_items cim,

726: --cim.object1_id2 "#",
727: csi.install_location_id
728: , csi.location_id
729: FROM csi_item_instances csi,
730: okc_k_items cim,
731: okc_k_lines_b inst,
732: okc_k_lines_b ib,
733: okc_line_styles_b lse
734: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)

Line 1153: OKC_K_ITEMS CIM,

1149: OKC_K_LINES_B TOP_CLE,
1150: OKC_LINE_STYLES_b TOP_LSE,
1151: OKC_K_LINES_B SUB_CLE,
1152: OKC_LINE_STYLES_b SUB_LSE,
1153: OKC_K_ITEMS CIM,
1154: OKC_K_LINES_V FA,
1155: OKC_LINE_STYLES_B AST_LSE,
1156: OKL_CNSLD_AR_STRMS_B LSM
1157: WHERE

Line 1186: okc_k_items cim,

1182: --cim.object1_id2 "#",
1183: csi.install_location_id
1184: , csi.location_id
1185: FROM csi_item_instances csi,
1186: okc_k_items cim,
1187: okc_k_lines_b inst,
1188: okc_k_lines_b ib,
1189: okc_line_styles_b lse
1190: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)

Line 1227: okc_k_items c

1223: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1224: SELECT c.object1_id1
1225: FROM okc_k_lines_v a,
1226: okc_line_styles_v b,
1227: okc_k_items c
1228: WHERE a.lse_id = b.id
1229: AND b.lty_code = 'SOLD_SERVICE'
1230: AND a.id = p_cle_id
1231: AND c.cle_id = a.id;

Line 1241: okc_k_items c

1237: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
1238: SELECT c.OBJECT1_ID1
1239: FROM okc_k_lines_b a,
1240: okc_line_styles_b b,
1241: okc_k_items c
1242: WHERE a.cle_id = p_fin_asset_line_id
1243: AND b.lty_code = 'ITEM'
1244: AND a.lse_id = b.id
1245: AND a.id = c.cle_id;