APPS.AHL_PRD_WORKORDER_PUB dependencies on AHL_WORKORDER_OPERATIONS

Line 43: Select plan_id,collection_id from ahl_workorder_operations_v

39: Select plan_id,collection_id from ahl_search_workorders_v
40: WHERE workorder_id = p_Workorder_Id;
41:
42: CURSOR get_op_plan_csr(p_WoOperationId IN NUMBER)IS
43: Select plan_id,collection_id from ahl_workorder_operations_v
44: WHERE workorder_operation_id = p_WoOperationId;
45:
46:
47:

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 350: Select WORKORDER_OPERATION_ID FROM AHL_WORKORDER_OPERATIONS

346:
347: l_workorder_operation_id NUMBER;
348:
349: CURSOR get_workorder_operation_id_csr(p_Workorder_Id IN NUMBER,p_operation_sequence IN NUMBER) IS
350: Select WORKORDER_OPERATION_ID FROM AHL_WORKORDER_OPERATIONS
351: WHERE WORKORDER_ID = p_Workorder_Id AND
352: OPERATION_SEQUENCE_NUM = p_operation_sequence;
353:
354: BEGIN

Line 1330: SELECT object_version_number,status_code FROM AHL_WORKORDER_OPERATIONS

1326: )IS
1327:
1328:
1329: CURSOR get_current_obj_ver_csr(p_WoOperationId IN NUMBER)IS
1330: SELECT object_version_number,status_code FROM AHL_WORKORDER_OPERATIONS
1331: WHERE WORKORDER_OPERATION_ID = p_WoOperationId;
1332:
1333: l_prd_operation_tbl AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;
1334: j INTEGER;