APPS.OKS_OCINT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 170: FROM mtl_system_items_b

166: l_organization_id NUMBER
167: )
168: IS
169: SELECT comms_nl_trackable_flag
170: FROM mtl_system_items_b
171: WHERE inventory_item_id = (SELECT inventory_item_id
172: FROM oe_order_lines_all
173: WHERE line_id = l_ref_order_line_id)
174: AND organization_id = l_organization_id

Line 182: From mtl_system_items_b mtl

178:
179: Cursor csi_ib_trackable(l_ref_order_line_id Number , l_organization_id Number)
180: Is
181: Select mtl.comms_nl_trackable_flag
182: From mtl_system_items_b mtl
183: ,csi_item_instances csi
184: Where csi.instance_id = l_ref_order_line_id
185: and mtl.inventory_item_id = csi.inventory_item_id
186: and mtl.organization_id = l_organization_id

Line 720: ,mtl_system_items_b mtl

716: ,c_organization_id NUMBER) IS
717: SELECT csi.instance_id cp_id
718: FROM csi_item_instances csi
719: ,csi_instance_statuses st
720: ,mtl_system_items_b mtl
721: WHERE csi.last_oe_order_line_id = p_ordlineid
722: AND csi.instance_status_id = st.instance_status_id
723: AND mtl.inventory_item_id = csi.inventory_item_id
724: AND mtl.organization_id = c_organization_id

Line 941: mtl_system_items_b_kfv b,

937: /*Added for CLOUD ER 16039680*/
938: CURSOR get_item_type(l_instance_id NUMBER) IS
939: SELECT b.contract_item_type_code
940: FROM csi_item_instances csi,oe_order_lines_all ol,
941: mtl_system_items_b_kfv b,
942: mtl_system_items_tl t
943: WHERE csi.last_oe_order_line_id=ol.line_id
944: AND csi.instance_id = l_instance_id
945: AND b.inventory_item_id = ol.inventory_item_id

Line 942: mtl_system_items_tl t

938: CURSOR get_item_type(l_instance_id NUMBER) IS
939: SELECT b.contract_item_type_code
940: FROM csi_item_instances csi,oe_order_lines_all ol,
941: mtl_system_items_b_kfv b,
942: mtl_system_items_tl t
943: WHERE csi.last_oe_order_line_id=ol.line_id
944: AND csi.instance_id = l_instance_id
945: AND b.inventory_item_id = ol.inventory_item_id
946: AND b.inventory_item_id = t.inventory_item_id

Line 4518: FROM mtl_system_items_b

4514: l_organization_id NUMBER
4515: )
4516: IS
4517: SELECT comms_nl_trackable_flag
4518: FROM mtl_system_items_b
4519: WHERE inventory_item_id = (SELECT inventory_item_id
4520: FROM oe_order_lines_all
4521: WHERE line_id = l_ref_order_line_id)
4522: AND organization_id = l_organization_id;

Line 4860: mtl_system_items MTL

4856: KI.number_of_items, KI.uom_code,
4857: NVL(MTL.contract_item_type_code,'NON-SUB'), MTL.coverage_schedule_id, MTL.comms_nl_trackable_flag
4858: From okc_k_lines_b KL,
4859: okc_k_items KI,
4860: mtl_system_items MTL
4861: Where KL.id = p_cle_id
4862: and KI.cle_id = p_cle_id
4863: and MTL.inventory_item_id = TO_NUMBER(KI.object1_id1)
4864: and MTL.organization_id = TO_NUMBER(KI.object1_id2);