DBA Data[Home] [Help]

APPS.WIP_OSP_SHP_I_WF dependencies on WIP_OPERATIONS

Line 600: wip_operations wo,

596: po_distributions_all pd,
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)

Line 663: wip_operations wo,

659: po_distributions_all pd,
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

Line 1443: wip_operations wo,

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,
1444: po_distributions_all pd2,
1445: po_distributions_all pd1
1446: where pd1.po_distribution_id = l_po_distribution_id
1447: and wo.wip_entity_id = pd1.wip_entity_id