74: WO.ITEM_INSTANCE_NUMBER,
75: WO.LOT_NUMBER,
76: WO.SERIAL_NUMBER
77: FROM AHL_WORKORDERS_V WO, AHL_WORKORDER_OPERATIONS WOP,
78: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
79: WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
80: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
81: AND WO.WORKORDER_ID = WOP.WORKORDER_ID
82: AND WOP.workorder_operation_id = p_WoOperationId;
91: WO.ITEM_INSTANCE_NUMBER,
92: WO.LOT_NUMBER,
93: WO.SERIAL_NUMBER
94: FROM AHL_WORKORDERS_V WO,
95: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH
96: WHERE WO.MR_ROUTE_ID=AMR.MR_ROUTE_ID (+)
97: AND AMR.MR_HEADER_ID=AMH.MR_HEADER_ID(+)
98: AND WO.WORKORDER_ID = p_Workorder_Id;
99: