DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on EAM_MATERIAL_ALLOCQTY_PKG

Line 75: eam_material_allocqty_pkg.allocated_quantity(wro.wip_entity_id , wro.operation_seq_num,wro.organization_id,wro.inventory_item_id),

71: CURSOR get_materials_csr(p_wip_entity_id NUMBER) IS
72: SELECT wro.organization_id,
73: wro.wip_entity_id,
74: SUM(Get_Open_Qty(NVL(wro.required_quantity,0) ,
75: eam_material_allocqty_pkg.allocated_quantity(wro.wip_entity_id , wro.operation_seq_num,wro.organization_id,wro.inventory_item_id),
76: NVL(wro.quantity_issued,0))) open_quantity,
77: mtlbkfv.concatenated_segments inventory_item,
78: wro.inventory_item_id,
79: mtlbkfv.lot_control_code,