APPS.AHL_PRD_WORKORDER_PUB dependencies on AHL_WORKORDERS_V

Line 77: FROM AHL_WORKORDERS_V WO, AHL_WORKORDER_OPERATIONS WOP,

73: WO.WO_PART_NUMBER,
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

Line 94: FROM AHL_WORKORDERS_V WO,

90: WO.WO_PART_NUMBER,
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;