DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PUB dependencies on AHL_MR_HEADERS_B

Line 78: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH

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;

Line 95: AHL_MR_ROUTES AMR, AHL_MR_HEADERS_B AMH

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: