DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on EAM_MATERIAL_ALLOCQTY_PKG

Line 138: 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" ,

134: WRO.REQUIRED_QUANTITY as "REQREQUIREDQUANTITY",
135: msikfv.concatenated_segments as "REQITEMNAME",
136: msikfv.description as "REQITEMDESCRIPTION",
137: wro.quantity_issued as "REQISSUEDQUANTITY",
138: 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" ,
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,

Line 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

135: msikfv.concatenated_segments as "REQITEMNAME",
136: msikfv.description as "REQITEMDESCRIPTION",
137: wro.quantity_issued as "REQISSUEDQUANTITY",
138: 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" ,
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,