DBA Data[Home] [Help]

APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on MTL_RESERVATIONS

Line 554: FROM mtl_reservations mtl ,

550: -- ARUNJK included cursor for cancel reservation for WO-WO supply WO Cancel Marshalling2
551: CURSOR GET_SRC_RES_ID_CSR(P_WORKORDER_ID NUMBER)
552: IS
553: SELECT mtl.reservation_id RESERVATION_ID
554: FROM mtl_reservations mtl ,
555: ahl_workorders awo
556: WHERE mtl.supply_source_header_id = awo.wip_entity_id
557: AND awo.workorder_id = P_WORKORDER_ID;
558: