DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1855: , wip_requirement_operations wro

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
1857: AND jsc.subcontract_po_shipment_id=jsa.subcontract_po_shipment_id(+)
1858: AND jsc.shikyu_component_id=jsa.shikyu_component_id(+)
1859: AND jso.interlock_status = 'P'

Line 1884: , wip_requirement_operations wro

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
1886: , po_lines_all pla
1887: , po_headers_all pha
1888: WHERE jso.subcontract_po_shipment_id = jsc.subcontract_po_shipment_id