APPS.WIP_OSP_SHP_I_WF dependencies on MTL_SYSTEM_ITEMS

Line 49: , mtl_system_items_kfv msik

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

Line 50: , mtl_system_items_kfv msik2

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

Line 601: mtl_system_items msi

597: po_vendors pv,
598: po_vendor_sites_all pvs,
599: wip_operation_resources wor,
600: wip_operations wo,
601: mtl_system_items msi
602: where pd.wip_entity_id = l_wip_entity_id
603: and pd.wip_operation_seq_num = l_osp_operation_num
604: and nvl(pd.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)
605: and pd.po_header_id = ph.po_header_id

Line 664: mtl_system_items msi

660: po_vendors pv,
661: po_vendor_sites_all pvs,
662: wip_operation_resources wor,
663: wip_operations wo,
664: mtl_system_items msi
665: where ph.type_lookup_code = 'BLANKET'
666: and pd.wip_entity_id = l_wip_entity_id
667: and pd.wip_operation_seq_num = l_osp_operation_num
668: and nvl(pd.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)

Line 1439: mtl_system_items_kfv msik2,

1435: msik2.description,
1436: pr.release_num
1437: from po_releases_all pr,
1438: po_location_associations_all pla,
1439: mtl_system_items_kfv msik2,
1440: po_lines_all pl2,
1441: po_line_locations_all ps1,
1442: po_headers_all ph2,
1443: wip_operations wo,