DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on AHL_WORKORDER_OPERATIONS_V

Line 309: FROM AHL_WORKORDER_OPERATIONS_V

305: DEPARTMENT_NAME, OPERATION_ID, OPERATION_CODE, OPERATION_TYPE_CODE,
306: OPERATION_TYPE, STATUS_CODE, STATUS,
307: SCHEDULED_START_DATE, SCHEDULED_END_DATE,
308: ACTUAL_START_DATE, ACTUAL_END_DATE, PLAN_ID
309: FROM AHL_WORKORDER_OPERATIONS_V
310: WHERE WORKORDER_ID = p_WorkorderId
311: AND WORKORDER_OPERATION_ID = NVL(p_WoOperationId, WORKORDER_OPERATION_ID)
312: ORDER BY OPERATION_SEQUENCE_NUM;
313:

Line 1069: Select plan_id,collection_id from ahl_workorder_operations_v

1065: Select plan_id,collection_id from ahl_search_workorders_v
1066: WHERE workorder_id = p_WorkorderId;
1067:
1068: CURSOR get_op_plan_csr(p_WoOperationId IN NUMBER)IS
1069: Select plan_id,collection_id from ahl_workorder_operations_v
1070: WHERE workorder_operation_id = p_WoOperationId;
1071:
1072:
1073: