DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on EAM_MATERIAL_ALLOCQTY_PKG

Line 131: eam_material_allocqty_pkg.open_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID,WRO.REQUIRED_QUANTITY,WRO.QUANTITY_ISSUED) as "REQQUANTITYOPEN" ,

127: WRO.REQUIRED_QUANTITY as "REQREQUIREDQUANTITY",
128: msikfv.concatenated_segments as "REQITEMNAME",
129: msikfv.description as "REQITEMDESCRIPTION",
130: wro.quantity_issued as "REQISSUEDQUANTITY",
131: eam_material_allocqty_pkg.open_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID,WRO.REQUIRED_QUANTITY,WRO.QUANTITY_ISSUED) as "REQQUANTITYOPEN" ,
132: eam_material_allocqty_pkg.allocated_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID) as "REQALLOCATEDQUANTITY")) Material
133: FROM
134: mtl_system_items_b_kfv msikfv,
135: MTL_SYSTEM_ITEMS M,

Line 132: eam_material_allocqty_pkg.allocated_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID) as "REQALLOCATEDQUANTITY")) Material

128: msikfv.concatenated_segments as "REQITEMNAME",
129: msikfv.description as "REQITEMDESCRIPTION",
130: wro.quantity_issued as "REQISSUEDQUANTITY",
131: eam_material_allocqty_pkg.open_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID,WRO.REQUIRED_QUANTITY,WRO.QUANTITY_ISSUED) as "REQQUANTITYOPEN" ,
132: eam_material_allocqty_pkg.allocated_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID) as "REQALLOCATEDQUANTITY")) Material
133: FROM
134: mtl_system_items_b_kfv msikfv,
135: MTL_SYSTEM_ITEMS M,
136: MTL_ITEM_LOCATIONS L,