DBA Data[Home] [Help]

APPS.AHL_RSV_RESERVATIONS_PVT dependencies on AHL_MATERIAL_REQUIREMENTS_V

Line 82: FROM ahl_material_requirements_v asmt

78: SELECT asmt.organization_id, asmt.requested_date, asmt.uom,
79: nvl(asmt.requested_quantity,0) requested_quantity, asmt.inventory_item_id,
80: asmt.object_version_number, nvl(asmt.reserved_quantity,0) reserved_quantity,
81: nvl(asmt.completed_quantity,0) completed_quantity
82: FROM ahl_material_requirements_v asmt
83: WHERE asmt.schedule_material_id = c_scheduled_material_id;
84:
85: l_mtl_req_dtls_rec get_mtl_req_dtls_csr%ROWTYPE;
86: