DBA Data[Home] [Help]

APPS.JMF_SHIKYU_INV_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 562: FROM wip_requirement_operations wro,

558: SELECT wro.supply_subinventory,
559: wro.supply_locator_id
560: INTO l_subinventory_code,
561: l_locator_id
562: FROM wip_requirement_operations wro,
563: jmf_subcontract_orders jso
564: WHERE wro.wip_entity_id = jso.wip_entity_id
565: AND wro.inventory_item_id = p_item_id
566: AND wro.organization_id = jso.tp_organization_id

Line 578: FROM WIP_REQUIREMENT_OPERATIONS wro,

574: WHERE ORGANIZATION_ID = l_organization_id;
575:
576: SELECT wro.supply_locator_id
577: INTO l_locator_id
578: FROM WIP_REQUIREMENT_OPERATIONS wro,
579: jmf_subcontract_orders jso
580: WHERE wro.wip_entity_id = jso.wip_entity_id
581: AND wro.organization_id = jso.tp_organization_id
582: AND wro.ORGANIZATION_ID = l_organization_id