APPS.WIP_OSP_SHP_I_WF dependencies on MTL_SYSTEM_ITEMS

Line 46: , mtl_system_items_kfv msik

42: , l_osp_item_desc
43: from wip_entities we
44: , wip_operation_resources wor
45: , bom_resources br
46: , mtl_system_items_kfv msik
47: , mtl_system_items_kfv msik2
48: where we.wip_entity_id = p_wip_entity_id
49: and we.organization_id = p_organization_id
50: and msik.inventory_item_id(+) = we.primary_item_id

Line 47: , mtl_system_items_kfv msik2

43: from wip_entities we
44: , wip_operation_resources wor
45: , bom_resources br
46: , mtl_system_items_kfv msik
47: , mtl_system_items_kfv msik2
48: where we.wip_entity_id = p_wip_entity_id
49: and we.organization_id = p_organization_id
50: and msik.inventory_item_id(+) = we.primary_item_id
51: and msik.organization_id(+) = we.organization_id

Line 558: mtl_system_items msi

554: po_vendors pv,
555: po_vendor_sites_all pvs,
556: wip_operation_resources wor,
557: wip_operations wo,
558: mtl_system_items msi
559: where pd.wip_entity_id = l_wip_entity_id
560: and pd.wip_operation_seq_num = l_osp_operation_num
561: and nvl(pd.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)
562: and pd.po_header_id = ph.po_header_id

Line 621: mtl_system_items msi

617: po_vendors pv,
618: po_vendor_sites_all pvs,
619: wip_operation_resources wor,
620: wip_operations wo,
621: mtl_system_items msi
622: where ph.type_lookup_code = 'BLANKET'
623: and pd.wip_entity_id = l_wip_entity_id
624: and pd.wip_operation_seq_num = l_osp_operation_num
625: and nvl(pd.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)

Line 1396: mtl_system_items_kfv msik2,

1392: msik2.description,
1393: pr.release_num
1394: from po_releases_all pr,
1395: po_location_associations_all pla,
1396: mtl_system_items_kfv msik2,
1397: po_lines_all pl2,
1398: po_line_locations_all ps1,
1399: po_headers_all ph2,
1400: wip_operations wo,