DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on AHL_PP_MATERIALS_PVT

Line 447: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,

443: CURSOR get_wo_mtl_reqmts_csr(p_WorkorderId IN NUMBER, p_WoOperationId IN NUMBER) IS
444: SELECT ASML.operation_sequence, MSIK.concatenated_segments part_number,MSIK.description Part_Desc, MSIK.primary_unit_of_measure part_uom ,
445: WIRO.REQUIRED_QUANTITY required_quantity , WIRO.DATE_REQUIRED required_date,
446: asml.scheduled_quantity schedule_quantity,asml.scheduled_date schedule_date,
447: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
448: AWOS.workorder_id,
449: asml.inventory_item_id,
450: ASML.organization_id,
451: ASML.scheduled_material_id