eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 484: FROM AHL_WORKORDER_OPERATIONS AWO

480: -- Lock specific WO-operation.
481: CURSOR c_lock_wo_oper (p_workorder_id IN NUMBER,
482: p_operation_seq_num IN NUMBER) IS
483: SELECT AWO.STATUS_CODE
484: FROM AHL_WORKORDER_OPERATIONS AWO
485: WHERE AWO.WORKORDER_ID = p_workorder_id
486: AND AWO.operation_sequence_num = p_operation_seq_num
487: FOR UPDATE OF AWO.object_version_number;
488:

Line 504: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,

500: where wo1.wip_entity_id = aw.wip_entity_id
501: and wo1.operation_seq_num = p_operation_seq_num) department_id,
502: WOR.resource_seq_num
503: FROM WIP_OPERATION_RESOURCES WOR,
504: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,
505: BOM_RESOURCES BRS
506: WHERE AW.workorder_id = AWO.workorder_id
507: AND WOR.wip_entity_id = AW.wip_entity_id
508: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM

Line 557: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;

553:
554: l_object_ver_num NUMBER;
555: l_assignment_id NUMBER;
556:
557: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
558:
559: l_operation_resource_id NUMBER;
560: l_sysdate DATE;
561: l_duration NUMBER; -- resource reqd duration.

Line 849: FROM AHL_WORKORDER_OPERATIONS AWO

845: -- Lock specific WO-operation.
846: CURSOR c_lock_wo_oper (p_workorder_id IN NUMBER,
847: p_operation_seq_num IN NUMBER) IS
848: SELECT AWO.STATUS_CODE
849: FROM AHL_WORKORDER_OPERATIONS AWO
850: WHERE AWO.WORKORDER_ID = p_workorder_id
851: AND AWO.operation_sequence_num = p_operation_seq_num
852: FOR UPDATE OF AWO.object_version_number;
853:

Line 866: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,

862: (select wo1.department_id from wip_operations wo1
863: where wo1.wip_entity_id = aw.wip_entity_id
864: and wo1.operation_seq_num = p_operation_seq_num) department_id
865: FROM WIP_OPERATION_RESOURCES WOR,
866: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,
867: BOM_RESOURCES BRS
868: WHERE AW.workorder_id = AWO.workorder_id
869: AND AWO.operation_sequence_num = p_operation_seq_num
870: AND WOR.wip_entity_id = AW.wip_entity_id

Line 918: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;

914:
915: l_object_ver_num NUMBER;
916: l_assignment_id NUMBER;
917:
918: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
919: l_wo_status AHL_WORKORDERS.status_code%TYPE;
920:
921: l_operation_resource_id NUMBER;
922: l_sysdate DATE;

Line 1173: FROM AHL_WORKORDER_OPERATIONS AWO

1169:
1170: -- Lock all operation for a WO.
1171: CURSOR c_lock_wo_all_ops (p_workorder_id IN NUMBER) IS
1172: SELECT AWO.STATUS_CODE
1173: FROM AHL_WORKORDER_OPERATIONS AWO
1174: WHERE AWO.WORKORDER_ID = p_workorder_id
1175: FOR UPDATE OF AWO.object_version_number;
1176:
1177: -- Query to get all qualified resources reqd for a WO and employee

Line 1189: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,

1185: (select wo1.department_id from wip_operations wo1
1186: where wo1.wip_entity_id = aw.wip_entity_id
1187: and wo1.operation_seq_num = AWO.operation_sequence_num) department_id
1188: FROM WIP_OPERATION_RESOURCES WOR,
1189: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,
1190: BOM_RESOURCES BRS
1191: WHERE AW.workorder_id = AWO.workorder_id
1192: AND WOR.wip_entity_id = AW.wip_entity_id
1193: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM

Line 1240: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;

1236: l_object_ver_num NUMBER;
1237: l_assignment_id NUMBER;
1238:
1239: l_wo_status AHL_WORKORDERS.status_code%TYPE;
1240: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
1241:
1242: l_sysdate DATE;
1243: l_duration NUMBER; -- resource reqd duration.
1244:

Line 1754: FROM AHL_WORKORDER_OPERATIONS AWO

1750:
1751: -- Lock all operations for a WO.
1752: CURSOR c_lock_wo_all_ops (p_workorder_id IN NUMBER) IS
1753: SELECT AWO.STATUS_CODE
1754: FROM AHL_WORKORDER_OPERATIONS AWO
1755: WHERE AWO.WORKORDER_ID = p_workorder_id
1756: FOR UPDATE OF AWO.object_version_number;
1757:
1758: -- Lock specific WO-operation.

Line 1762: FROM AHL_WORKORDER_OPERATIONS AWO

1758: -- Lock specific WO-operation.
1759: CURSOR c_lock_wo_oper (p_workorder_id IN NUMBER,
1760: p_operation_seq_num IN NUMBER) IS
1761: SELECT AWO.STATUS_CODE
1762: FROM AHL_WORKORDER_OPERATIONS AWO
1763: WHERE AWO.WORKORDER_ID = p_workorder_id
1764: AND AWO.operation_sequence_num = p_operation_seq_num
1765: FOR UPDATE OF AWO.object_version_number;
1766:

Line 2741: FROM AHL_WORKORDER_OPERATIONS

2737: CURSOR c_is_op_seq_valid(p_workorder_id IN NUMBER,
2738: p_op_seq_num IN NUMBER,
2739: p_wip_entity_id IN NUMBER) IS
2740: SELECT 'x' -- status_code
2741: FROM AHL_WORKORDER_OPERATIONS
2742: WHERE WORKORDER_ID = p_workorder_id
2743: AND OPERATION_SEQUENCE_NUM = p_op_seq_num
2744: AND status_code = 2 -- uncomplete
2745: AND exists ( SELECT 'x'

Line 2837: FROM AHL_WORKORDER_OPERATIONS

2833:
2834: -- query to check if all operations of a WO are uncomplete.
2835: CURSOR c_workorder_oper(p_workorder_id IN NUMBER) IS
2836: SELECT 'x'
2837: FROM AHL_WORKORDER_OPERATIONS
2838: WHERE workorder_id = p_workorder_id
2839: AND STATUS_CODE = '1' -- complete.
2840: AND rownum < 2;
2841:

Line 2854: --l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;

2850: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;
2851: l_wip_entity_id NUMBER;
2852: l_org_id NUMBER;
2853:
2854: --l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
2855: l_resource_code BOM_RESOURCES.resource_code%TYPE;
2856:
2857: l_junk VARCHAR2(1);
2858: l_return_status VARCHAR2(1);