DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on AHL_SEARCH_WORKORDERS_V

Line 1086: Select plan_id,collection_id from ahl_search_workorders_v

1082: l_workorder_id NUMBER;
1083: l_workorder_operation_id NUMBER;
1084:
1085: CURSOR get_wo_plan_csr(p_WorkorderId IN NUMBER)IS
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