eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PP_MATERIALS_PVT dependencies on MTL_RESERVATIONS

Line 2977: FROM mtl_reservations MRV

2973: c_org_id IN NUMBER,
2974: c_wip_entity_id IN NUMBER,
2975: c_oper_seq_num IN NUMBER) IS
2976: SELECT nvl(SUM(mrv.primary_reservation_quantity), 0) reserved_quantity
2977: FROM mtl_reservations MRV
2978: WHERE MRV.INVENTORY_ITEM_ID = c_item_id
2979: AND MRV.EXTERNAL_SOURCE_CODE = 'AHL'
2980: AND MRV.DEMAND_SOURCE_HEADER_ID = c_wip_entity_id
2981: AND MRV.DEMAND_SOURCE_LINE_ID = c_oper_seq_num;

Line 3892: FROM mtl_reservations MRV

3888: c_org_id IN NUMBER,
3889: c_wip_entity_id IN NUMBER,
3890: c_oper_seq_num IN NUMBER) IS
3891: SELECT nvl(SUM(mrv.primary_reservation_quantity), 0) reserved_quantity
3892: FROM mtl_reservations MRV
3893: WHERE MRV.INVENTORY_ITEM_ID = c_item_id
3894: AND MRV.EXTERNAL_SOURCE_CODE = 'AHL'
3895: AND MRV.DEMAND_SOURCE_HEADER_ID = c_wip_entity_id
3896: AND MRV.DEMAND_SOURCE_LINE_ID = c_oper_seq_num;

Line 4271: FROM mtl_reservations mrv, ahl_schedule_materials asmt

4267: asm.requested_quantity old_requested_quantity,
4268: asm.workorder_operation_id,
4269: NVL(asm.completed_quantity, 0) completed_quantity,
4270: (SELECT NVL(SUM(mrv.primary_reservation_quantity), 0)
4271: FROM mtl_reservations mrv, ahl_schedule_materials asmt
4272: WHERE mrv.inventory_item_id = asmt.inventory_item_id
4273: AND mrv.external_source_code = 'AHL'
4274: AND mrv.requirement_date = asmt.requested_date
4275: AND mrv.organization_id = asmt.organization_id