APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_WORKORDER_OPERATIONS_V

Line 136: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, AHL_WORKORDER_OPERATIONS_V AWV

132: BEGIN
133: IF (p_resource_code IS NOT NULL) THEN
134: SELECT DISTINCT(BR.RESOURCE_ID)
135: INTO x_resource_id
136: FROM BOM_RESOURCES BR, BOM_DEPARTMENT_RESOURCES BDR, AHL_WORKORDER_OPERATIONS_V AWV
137: WHERE BR.RESOURCE_ID = BDR.RESOURCE_ID AND BDR.DEPARTMENT_ID = AWV.DEPARTMENT_ID
138: AND AWV.WORKORDER_ID = p_workorder_id AND BR.RESOURCE_CODE = p_resource_code;
139: END IF;
140:

Line 373: FROM AHL_WORKORDER_OPERATIONS_V WHERE WORKORDER_OPERATION_ID = x_id;*/

369: -- Cursor to check
370: /*CURSOR c_wo_oper (x_id IN NUMBER) IS
371: SELECT TO_DATE(ACTUAL_START_DATE,'DD-MM-YYYY'), TO_DATE(ACTUAL_END_DATE,'DD-MM-YYYY'),
372: TO_DATE(SCHEDULED_START_DATE,'DD-MM-YYYY'), TO_DATE(SCHEDULED_END_DATE,'DD-MM-YYYY')
373: FROM AHL_WORKORDER_OPERATIONS_V WHERE WORKORDER_OPERATION_ID = x_id;*/
374: -- bug 4092197
375: -- no point in doing a date conversion on a date value
376: -- if the intent was to lose the time portion, then the trunc function can be used
377: -- but do not need to use trunc function

Line 385: FROM AHL_WORKORDER_OPERATIONS_V WHERE WORKORDER_OPERATION_ID = x_id;

381: -- of the trunc(resource_date) = trunc(operation_date)
382: CURSOR c_wo_oper (x_id IN NUMBER) IS
383: SELECT ACTUAL_START_DATE, ACTUAL_END_DATE,
384: SCHEDULED_START_DATE, SCHEDULED_END_DATE
385: FROM AHL_WORKORDER_OPERATIONS_V WHERE WORKORDER_OPERATION_ID = x_id;
386:
387: BEGIN
388: IF G_DEBUG='Y' THEN
389: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items' || '--Operation ID =' || p_resrc_Require_rec.OPERATION_RESOURCE_ID);

Line 1056: --AHL_WORKORDER_OPERATIONS_V

1052: -- To find workorder_operation_id from ahl_workorder_operation_v view
1053: CURSOR c_wo_oper (x_id IN NUMBER, x_seq IN NUMBER) IS
1054: SELECT WORKORDER_OPERATION_ID FROM
1055: AHL_WORKORDER_OPERATIONS
1056: --AHL_WORKORDER_OPERATIONS_V
1057: WHERE WORKORDER_ID = x_id AND OPERATION_SEQUENCE_NUM = x_seq;
1058:
1059: -- To find the resource sequence nubmer from ahl_operation_resources
1060: CURSOR c_resrc_seq (x_id IN NUMBER, x_oper_seq IN NUMBER, x_resrc_seq IN NUMBER) IS

Line 2126: -- To find the WORKORDER_ID from AHL_WORKORDER_OPERATIONS_V view

2122: x_msg_data OUT NOCOPY VARCHAR2
2123: )
2124: IS
2125:
2126: -- To find the WORKORDER_ID from AHL_WORKORDER_OPERATIONS_V view
2127: CURSOR c_wo_oper (x_id IN NUMBER) IS
2128: SELECT WORKORDER_ID,OPERATION_SEQUENCE_NUM FROM
2129: AHL_WORKORDER_OPERATIONS_V
2130: WHERE WORKORDER_OPERATION_ID = x_id;

Line 2129: AHL_WORKORDER_OPERATIONS_V

2125:
2126: -- To find the WORKORDER_ID from AHL_WORKORDER_OPERATIONS_V view
2127: CURSOR c_wo_oper (x_id IN NUMBER) IS
2128: SELECT WORKORDER_ID,OPERATION_SEQUENCE_NUM FROM
2129: AHL_WORKORDER_OPERATIONS_V
2130: WHERE WORKORDER_OPERATION_ID = x_id;
2131:
2132: -- To Get Wip Entity Id and Org Id
2133: CURSOR c_work_orders (x_id IN NUMBER) IS

Line 3056: FROM AHL_WORKORDER_OPERATIONS_V

3052: c_WIP_oper_rec c_WIP_oper%ROWTYPE;
3053:
3054: CURSOR c_WO_oper(x_id IN NUMBER) IS
3055: SELECT OPERATION_SEQUENCE_NUM, SCHEDULED_START_DATE, SCHEDULED_END_DATE
3056: FROM AHL_WORKORDER_OPERATIONS_V
3057: WHERE WORKORDER_OPERATION_ID = x_id;
3058:
3059: /* R12 Perf Tuning
3060: * Balaji modified the query to use only base tables

Line 3345: SELECT * FROM ahl_workorder_operations_v

3341:
3342: --
3343: CURSOR Get_wo_oper_cur (c_wo_operation_id IN NUMBER)
3344: IS
3345: SELECT * FROM ahl_workorder_operations_v
3346: WHERE workorder_operation_id = c_wo_operation_id;
3347:
3348: --
3349: CURSOR c_chk_assgn (oper_resrc_id IN NUMBER)