DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ADJUSTMENT_PROC dependencies on JMF_SHIKYU_COMPONENTS

Line 1282: ,jmf_shikyu_components jsc

1278: FROM po_headers_all ph
1279: ,po_lines_all pl
1280: ,po_line_locations_all pll
1281: ,mtl_system_items_b_kfv item_kfv
1282: ,jmf_shikyu_components jsc
1283: WHERE pl.po_line_id = pll.po_line_id
1284: AND ph.po_header_id = pll.po_header_id
1285: AND pll.ship_to_organization_id = item_kfv.organization_id
1286: AND jsc.shikyu_component_id = item_kfv.inventory_item_id

Line 1438: ,jmf_shikyu_components jsc

1434: INTO l_wip_consumed_qty
1435: ,l_wip_consumed_uom
1436: FROM wip_requirement_operations wro
1437: ,jmf_subcontract_orders jso
1438: ,jmf_shikyu_components jsc
1439: WHERE wro.wip_entity_id = jso.wip_entity_id
1440: AND wro.organization_id = jso.tp_organization_id
1441: AND wro.inventory_item_id = jsc.shikyu_component_id
1442: AND wro.repetitive_schedule_id IS NULL