DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on JMF_SHIKYU_ALLOCATIONS

Line 1681: FROM jmf_shikyu_allocations jsa

1677: SELECT jsc.subcontract_po_shipment_id
1678: , jsc.shikyu_component_id
1679: , sum(nvl(jsa.allocated_quantity,0))
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

Line 1708: FROM jmf_shikyu_allocations jsa

1704: , max(plla.need_by_date)
1705: , sum(nvl(jsa.allocated_quantity,0))
1706: , max(nvl(wro.required_quantity,0))
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