DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on JMF_SHIKYU_ALLOCATIONS

Line 1852: FROM jmf_shikyu_allocations jsa

1848: SELECT jsc.subcontract_po_shipment_id
1849: , jsc.shikyu_component_id
1850: , sum(nvl(jsa.allocated_quantity,0))
1851: , max(nvl(wro.required_quantity,0))
1852: FROM jmf_shikyu_allocations jsa
1853: , jmf_shikyu_components jsc
1854: , jmf_subcontract_orders jso
1855: , wip_requirement_operations wro
1856: WHERE jso.subcontract_po_shipment_id = jsc.subcontract_po_shipment_id

Line 1881: FROM jmf_shikyu_allocations jsa

1877: , max(plla.need_by_date)
1878: , sum(nvl(jsa.allocated_quantity,0))
1879: , max(nvl(wro.required_quantity,0))
1880: , max(jsc.replen_so_creation_failed)
1881: FROM jmf_shikyu_allocations jsa
1882: , jmf_shikyu_components jsc
1883: , jmf_subcontract_orders jso
1884: , wip_requirement_operations wro
1885: , po_line_locations_all plla