APPS.OKS_OCINT_PUB dependencies on MTL_SYSTEM_ITEMS_B

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 3874: FROM mtl_system_items_b

3870: l_organization_id NUMBER
3871: )
3872: IS
3873: SELECT comms_nl_trackable_flag
3874: FROM mtl_system_items_b
3875: WHERE inventory_item_id = (SELECT inventory_item_id
3876: FROM oe_order_lines_all
3877: WHERE line_id = l_ref_order_line_id)
3878: AND organization_id = l_organization_id;