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_WORKORDERS

Line 103: FROM AHL_WORKORDERS AW

99:
100: -- get WO name.
101: CURSOR c_wo_name (p_workorder_id IN NUMBER) IS
102: SELECT AW.workorder_name
103: FROM AHL_WORKORDERS AW
104: WHERE AW.WORKORDER_ID = p_workorder_id;
105:
106: l_api_version CONSTANT NUMBER := 1.0;
107: l_api_name CONSTANT VARCHAR2(30) := 'Workorder_Login';

Line 112: l_workorder_name ahl_workorders.workorder_name%TYPE;

108:
109:
110: l_employee_num NUMBER;
111: l_employee_id NUMBER;
112: l_workorder_name ahl_workorders.workorder_name%TYPE;
113: l_workorder_id NUMBER;
114: l_org_code mtl_parameters.organization_id%TYPE;
115: l_operation_seq_num NUMBER;
116: l_resource_seq_num NUMBER;

Line 423: FROM AHL_WORKORDERS AWOS, WIP_DISCRETE_JOBS WIP,

419:
420: CURSOR c_get_wo_id (p_workorder_name VARCHAR2,
421: p_org_code VARCHAR2) IS
422: SELECT workorder_id
423: FROM AHL_WORKORDERS AWOS, WIP_DISCRETE_JOBS WIP,
424: ORG_ORGANIZATION_DEFINITIONS ORG
425: WHERE AWOS.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID
426: AND AWOS.WORKORDER_NAME = p_workorder_name
427: AND WIP.ORGANIZATION_ID = ORG.ORGANIZATION_ID

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 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 919: l_wo_status AHL_WORKORDERS.status_code%TYPE;

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;
923: l_duration NUMBER; -- resource reqd duration.

Line 1166: FROM AHL_WORKORDERS AW

1162:
1163: -- lock workorder.
1164: CURSOR c_lock_wo (p_workorder_id IN NUMBER) IS
1165: SELECT AW.STATUS_CODE
1166: FROM AHL_WORKORDERS AW
1167: WHERE AW.WORKORDER_ID = p_workorder_id
1168: FOR UPDATE OF AW.object_version_number;
1169:
1170: -- Lock all operation for a WO.

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 1239: l_wo_status AHL_WORKORDERS.status_code%TYPE;

1235:
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.

Line 1734: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,

1730: WLGN.login_level,
1731: WLGN.login_date,
1732: WLGN.work_login_time_id,
1733: WLGN.object_version_number
1734: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,
1735: AHL_WORK_LOGIN_TIMES WLGN
1736: WHERE WLGN.workorder_id(+) = AW.workorder_id
1737: AND WLGN.operation_resource_id = AOR.operation_resource_id(+)
1738: AND WLGN.employee_id(+) = c_employee_id

Line 1747: FROM AHL_WORKORDERS AW

1743:
1744: -- lock workorder.
1745: CURSOR c_lock_wo (p_workorder_id IN NUMBER) IS
1746: SELECT AW.STATUS_CODE, AW.workorder_name
1747: FROM AHL_WORKORDERS AW
1748: WHERE AW.WORKORDER_ID = p_workorder_id
1749: FOR UPDATE OF AW.object_version_number;
1750:
1751: -- Lock all operations for a WO.

Line 1923: l_workorder_name ahl_workorders.workorder_name%TYPE;

1919: l_login_workorder_id NUMBER;
1920: l_resource_id NUMBER;
1921: l_operation_seq_num NUMBER;
1922: l_resource_seq_num NUMBER;
1923: l_workorder_name ahl_workorders.workorder_name%TYPE;
1924: l_login_date DATE;
1925: l_login_level ahl_work_login_times.login_level%TYPE;
1926: l_work_login_time_id NUMBER;
1927:

Line 2471: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,

2467: AW.workorder_name,
2468: WLGN.operation_seq_num,
2469: AOR.resource_id,
2470: WLGN.resource_seq_num
2471: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,
2472: AHL_WORK_LOGIN_TIMES WLGN
2473: WHERE WLGN.workorder_id = AW.workorder_id
2474: AND WLGN.operation_resource_id = AOR.operation_resource_id(+)
2475: AND WLGN.employee_id = c_employee_id

Line 2493: l_workorder_number ahl_workorders.workorder_name%TYPE;

2489: l_resource_id NUMBER;
2490: l_count NUMBER;
2491:
2492: l_resource_seq_num NUMBER;
2493: l_workorder_number ahl_workorders.workorder_name%TYPE;
2494:
2495: BEGIN
2496:
2497: -- log debug message.

Line 2637: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE

2633:
2634: -- get WO status.
2635: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS
2636: SELECT wo.STATUS_CODE, wo.workorder_name, wo.wip_entity_id, we.organization_id
2637: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE
2638: WHERE WO.wip_entity_id = we.wip_entity_id
2639: AND WORKORDER_ID = p_workorder_id;
2640:
2641: -- validate employee.

Line 2849: l_wo_status AHL_WORKORDERS.status_code%TYPE;

2845: FROM WIP_OPERATIONS
2846: WHERE wip_entity_id = p_wip_entity_id;
2847:
2848: l_employee_id NUMBER;
2849: l_wo_status AHL_WORKORDERS.status_code%TYPE;
2850: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;
2851: l_wip_entity_id NUMBER;
2852: l_org_id NUMBER;
2853:

Line 2850: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;

2846: WHERE wip_entity_id = p_wip_entity_id;
2847:
2848: l_employee_id NUMBER;
2849: l_wo_status AHL_WORKORDERS.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;

Line 2866: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;

2862: l_login_workorder_id NUMBER;
2863: l_login_op_seq_num NUMBER;
2864: l_login_resource_id NUMBER;
2865: l_login_resrc_seq_num NUMBER;
2866: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;
2867: l_resource_id NUMBER;
2868: l_employee_name per_people_f.full_name%TYPE;
2869:
2870: l_fnd_function_name VARCHAR2(100);