DBA Data[Home] [Help]

APPS.WIP_OSP_SHP_I_WF dependencies on WIP_OPERATIONS

Line 557: wip_operations wo,

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
561: and nvl(pd.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)

Line 620: wip_operations wo,

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
624: and pd.wip_operation_seq_num = l_osp_operation_num

Line 1400: wip_operations wo,

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,
1401: po_distributions_all pd2,
1402: po_distributions_all pd1
1403: where pd1.po_distribution_id = l_po_distribution_id
1404: and wo.wip_entity_id = pd1.wip_entity_id