DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1684: , wip_requirement_operations wro

1680: , max(nvl(wro.required_quantity,0))
1681: FROM jmf_shikyu_allocations jsa
1682: , jmf_shikyu_components jsc
1683: , jmf_subcontract_orders jso
1684: , wip_requirement_operations wro
1685: WHERE jso.subcontract_po_shipment_id = jsc.subcontract_po_shipment_id
1686: AND jsc.subcontract_po_shipment_id=jsa.subcontract_po_shipment_id(+)
1687: AND jsc.shikyu_component_id=jsa.shikyu_component_id(+)
1688: AND jso.interlock_status = 'P'

Line 1711: , wip_requirement_operations wro

1707: , max(jsc.replen_so_creation_failed)
1708: FROM jmf_shikyu_allocations jsa
1709: , jmf_shikyu_components jsc
1710: , jmf_subcontract_orders jso
1711: , wip_requirement_operations wro
1712: , po_line_locations_all plla
1713: , po_lines_all pla
1714: , po_headers_all pha
1715: WHERE jso.subcontract_po_shipment_id = jsc.subcontract_po_shipment_id