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 487: FROM AHL_WORKORDER_OPERATIONS AWO

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

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

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

Line 560: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;

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

Line 852: FROM AHL_WORKORDER_OPERATIONS AWO

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

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

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

Line 921: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;

917:
918: l_object_ver_num NUMBER;
919: l_assignment_id NUMBER;
920:
921: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
922: l_wo_status AHL_WORKORDERS.status_code%TYPE;
923:
924: l_operation_resource_id NUMBER;
925: l_sysdate DATE;

Line 1176: FROM AHL_WORKORDER_OPERATIONS AWO

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

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

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

Line 1243: l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;

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

Line 1757: FROM AHL_WORKORDER_OPERATIONS AWO

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

Line 1765: FROM AHL_WORKORDER_OPERATIONS AWO

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

Line 2749: FROM AHL_WORKORDER_OPERATIONS

2745: CURSOR c_is_op_seq_valid(p_workorder_id IN NUMBER,
2746: p_op_seq_num IN NUMBER,
2747: p_wip_entity_id IN NUMBER) IS
2748: SELECT 'x' -- status_code
2749: FROM AHL_WORKORDER_OPERATIONS
2750: WHERE WORKORDER_ID = p_workorder_id
2751: AND OPERATION_SEQUENCE_NUM = p_op_seq_num
2752: AND status_code = 2 -- uncomplete
2753: AND exists ( SELECT 'x'

Line 2845: FROM AHL_WORKORDER_OPERATIONS

2841:
2842: -- query to check if all operations of a WO are uncomplete.
2843: CURSOR c_workorder_oper(p_workorder_id IN NUMBER) IS
2844: SELECT 'x'
2845: FROM AHL_WORKORDER_OPERATIONS
2846: WHERE workorder_id = p_workorder_id
2847: AND STATUS_CODE = '1' -- complete.
2848: AND rownum < 2;
2849:

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

2858: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;
2859: l_wip_entity_id NUMBER;
2860: l_org_id NUMBER;
2861:
2862: --l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
2863: l_resource_code BOM_RESOURCES.resource_code%TYPE;
2864:
2865: l_junk VARCHAR2(1);
2866: l_return_status VARCHAR2(1);

Line 3412: FROM AHL_WORKORDER_OPERATIONS

3408: CURSOR c_is_op_seq_valid(p_workorder_id IN NUMBER,
3409: p_op_seq_num IN NUMBER,
3410: p_wip_entity_id IN NUMBER) IS
3411: SELECT 'x' -- status_code
3412: FROM AHL_WORKORDER_OPERATIONS
3413: WHERE WORKORDER_ID = p_workorder_id
3414: AND OPERATION_SEQUENCE_NUM = p_op_seq_num
3415: AND status_code = 2 -- uncomplete
3416: AND exists ( SELECT 'x'

Line 3508: FROM AHL_WORKORDER_OPERATIONS

3504:
3505: -- query to check if all operations of a WO are uncomplete.
3506: CURSOR c_workorder_oper(p_workorder_id IN NUMBER) IS
3507: SELECT 'x'
3508: FROM AHL_WORKORDER_OPERATIONS
3509: WHERE workorder_id = p_workorder_id
3510: AND STATUS_CODE = '1' -- complete.
3511: AND rownum < 2;
3512:

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

3521: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;
3522: l_wip_entity_id NUMBER;
3523: l_org_id NUMBER;
3524:
3525: --l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
3526: l_resource_code BOM_RESOURCES.resource_code%TYPE;
3527:
3528: l_junk VARCHAR2(1);
3529: l_return_status VARCHAR2(1);