APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_RESERVATIONS

Line 913: FROM MTL_RESERVATIONS

909: DEMAND_SOURCE_LINE_DETAIL,
910: DEMAND_SOURCE_HEADER_ID,
911: SUPPLY_SOURCE_HEADER_ID,
912: PRIMARY_RESERVATION_QUANTITY
913: FROM MTL_RESERVATIONS
914: WHERE SUPPLY_SOURCE_TYPE_ID = 5
915: AND DEMAND_SOURCE_TYPE_ID = 5
916: AND SUPPLY_SOURCE_HEADER_ID = c_wip_entity_id ;
917:

Line 7246: FROM mtl_serial_numbers msn, mtl_reservations rsv

7242: p_inventory_item_id IN NUMBER,
7243: p_organization_id IN NUMBER) IS
7244: SELECT rsv.DEMAND_SOURCE_LINE_DETAIL schedule_material_id, rsv.demand_source_header_id,
7245: rsv.demand_source_line_id, rsv.demand_source_type_id
7246: FROM mtl_serial_numbers msn, mtl_reservations rsv
7247: WHERE msn.reservation_id = rsv.reservation_id
7248: AND msn.serial_number = p_serial_number
7249: AND msn.current_organization_id = p_organization_id
7250: AND msn.inventory_item_id = p_inventory_item_id;