DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on AHL_WORKORDER_OPERATIONS_V

Line 329: FROM AHL_WORKORDER_OPERATIONS_V

325: DEPARTMENT_NAME, OPERATION_ID, OPERATION_CODE, OPERATION_TYPE_CODE,
326: OPERATION_TYPE, STATUS_CODE, STATUS,
327: SCHEDULED_START_DATE, SCHEDULED_END_DATE,
328: ACTUAL_START_DATE, ACTUAL_END_DATE, PLAN_ID
329: FROM AHL_WORKORDER_OPERATIONS_V
330: WHERE WORKORDER_ID = p_WorkorderId
331: AND WORKORDER_OPERATION_ID = NVL(p_WoOperationId, WORKORDER_OPERATION_ID)
332: ORDER BY OPERATION_SEQUENCE_NUM;
333:

Line 1090: Select plan_id,collection_id from ahl_workorder_operations_v

1086: Select plan_id,collection_id from ahl_search_workorders_v
1087: WHERE workorder_id = p_WorkorderId;
1088:
1089: CURSOR get_op_plan_csr(p_WoOperationId IN NUMBER)IS
1090: Select plan_id,collection_id from ahl_workorder_operations_v
1091: WHERE workorder_operation_id = p_WoOperationId;
1092:
1093:
1094: