DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on MTL_ITEM_LOCATIONS

Line 143: MTL_ITEM_LOCATIONS L,

139: eam_material_allocqty_pkg.allocated_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID) as "REQALLOCATEDQUANTITY")) Material
140: FROM
141: mtl_system_items_b_kfv msikfv,
142: MTL_SYSTEM_ITEMS M,
143: MTL_ITEM_LOCATIONS L,
144: MFG_LOOKUPS LU,
145: WIP_REQUIREMENT_OPERATIONS WRO,
146: MTL_ITEM_LOCATIONS_KFV milk
147: WHERE

Line 146: MTL_ITEM_LOCATIONS_KFV milk

142: MTL_SYSTEM_ITEMS M,
143: MTL_ITEM_LOCATIONS L,
144: MFG_LOOKUPS LU,
145: WIP_REQUIREMENT_OPERATIONS WRO,
146: MTL_ITEM_LOCATIONS_KFV milk
147: WHERE
148: msikfv.organization_id = wro.organization_id
149: AND msikfv.inventory_item_id = wro.inventory_item_id
150: AND M.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID