DBA Data[Home] [Help]

APPS.WIP_OSP_SHP_I_WF dependencies on WIP_OPERATION_RESOURCES

Line 44: , wip_operation_resources wor

40: , l_osp_item_id
41: , l_osp_item
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

Line 556: wip_operation_resources wor,

552: po_lines_all pl,
553: po_distributions_all pd,
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

Line 619: wip_operation_resources wor,

615: po_line_locations_all ps,
616: po_distributions_all pd,
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