DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_RESERVATIONS

Line 5501: FROM mtl_serial_numbers msn, mtl_reservations rsv

5497: p_inventory_item_id IN NUMBER,
5498: p_organization_id IN NUMBER) IS
5499: SELECT rsv.DEMAND_SOURCE_LINE_DETAIL schedule_material_id, rsv.demand_source_header_id,
5500: rsv.demand_source_line_id, rsv.demand_source_type_id
5501: FROM mtl_serial_numbers msn, mtl_reservations rsv
5502: WHERE msn.reservation_id = rsv.reservation_id
5503: AND msn.serial_number = p_serial_number
5504: AND msn.current_organization_id = p_organization_id
5505: AND msn.inventory_item_id = p_inventory_item_id;