APPS.AHL_PRD_WORKORDER_PUB dependencies on AHL_WORKORDERS

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;

Line 328: Select WORKORDER_ID FROM AHL_WORKORDERS

324:
325: l_workorder_id NUMBER;
326:
327: CURSOR get_workorder_id_csr(p_workorder_number IN VARCHAR2) IS
328: Select WORKORDER_ID FROM AHL_WORKORDERS
329: WHERE WORKORDER_NAME = p_workorder_number;
330:
331: BEGIN
332: OPEN get_workorder_id_csr(p_Workorder_Number);

Line 1350: SELECT 'x' FROM AHL_WORKORDERS AWOS

1346: AND TRUNC(NVL(end_date_active,SYSDATE+1));
1347:
1348: CURSOR get_route_id_validation_csr(c_wo_id NUMBER)
1349: IS
1350: SELECT 'x' FROM AHL_WORKORDERS AWOS
1351: WHERE AWOS.workorder_id = c_wo_id
1352: AND AWOS.route_id IS NULL;
1353: l_temp VARCHAR2(1);
1354: