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 106: FROM AHL_WORKORDERS AW

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

Line 115: l_workorder_name ahl_workorders.workorder_name%TYPE;

111:
112:
113: l_employee_num NUMBER;
114: l_employee_id NUMBER;
115: l_workorder_name ahl_workorders.workorder_name%TYPE;
116: l_workorder_id NUMBER;
117: l_org_code mtl_parameters.organization_id%TYPE;
118: l_operation_seq_num NUMBER;
119: l_resource_seq_num NUMBER;

Line 426: FROM AHL_WORKORDERS AWOS, WIP_DISCRETE_JOBS WIP,

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

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

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

Line 1169: FROM AHL_WORKORDERS AW

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

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

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

Line 1737: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,

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

Line 1750: FROM AHL_WORKORDERS AW

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

Line 1926: l_workorder_name ahl_workorders.workorder_name%TYPE;

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

Line 2479: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,

2475: AW.workorder_name,
2476: WLGN.operation_seq_num,
2477: AOR.resource_id,
2478: WLGN.resource_seq_num
2479: FROM AHL_Operation_Resources AOR, AHL_WORKORDERS AW,
2480: AHL_WORK_LOGIN_TIMES WLGN
2481: WHERE WLGN.workorder_id = AW.workorder_id
2482: AND WLGN.operation_resource_id = AOR.operation_resource_id(+)
2483: AND WLGN.employee_id = c_employee_id

Line 2501: l_workorder_number ahl_workorders.workorder_name%TYPE;

2497: l_resource_id NUMBER;
2498: l_count NUMBER;
2499:
2500: l_resource_seq_num NUMBER;
2501: l_workorder_number ahl_workorders.workorder_name%TYPE;
2502:
2503: BEGIN
2504:
2505: -- log debug message.

Line 2645: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE

2641:
2642: -- get WO status.
2643: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS
2644: SELECT wo.STATUS_CODE, wo.workorder_name, wo.wip_entity_id, we.organization_id
2645: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE
2646: WHERE WO.wip_entity_id = we.wip_entity_id
2647: AND WORKORDER_ID = p_workorder_id;
2648:
2649: -- validate employee.

Line 2857: l_wo_status AHL_WORKORDERS.status_code%TYPE;

2853: FROM WIP_OPERATIONS
2854: WHERE wip_entity_id = p_wip_entity_id;
2855:
2856: l_employee_id NUMBER;
2857: l_wo_status AHL_WORKORDERS.status_code%TYPE;
2858: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;
2859: l_wip_entity_id NUMBER;
2860: l_org_id NUMBER;
2861:

Line 2858: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;

2854: WHERE wip_entity_id = p_wip_entity_id;
2855:
2856: l_employee_id NUMBER;
2857: l_wo_status AHL_WORKORDERS.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;

Line 2874: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;

2870: l_login_workorder_id NUMBER;
2871: l_login_op_seq_num NUMBER;
2872: l_login_resource_id NUMBER;
2873: l_login_resrc_seq_num NUMBER;
2874: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;
2875: l_resource_id NUMBER;
2876: l_employee_name per_people_f.full_name%TYPE;
2877:
2878: l_fnd_function_name VARCHAR2(100);

Line 3385: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE

3381:
3382: -- get WO status.
3383: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS
3384: SELECT wo.STATUS_CODE, wo.workorder_name, wo.wip_entity_id, we.organization_id
3385: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE
3386: WHERE WO.wip_entity_id = we.wip_entity_id
3387: AND WORKORDER_ID = p_workorder_id;
3388:
3389:

Line 3520: l_wo_status AHL_WORKORDERS.status_code%TYPE;

3516: FROM WIP_OPERATIONS
3517: WHERE wip_entity_id = p_wip_entity_id;
3518:
3519: l_employee_id NUMBER;
3520: l_wo_status AHL_WORKORDERS.status_code%TYPE;
3521: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;
3522: l_wip_entity_id NUMBER;
3523: l_org_id NUMBER;
3524:

Line 3521: l_wo_name AHL_WORKORDERS.workorder_name%TYPE;

3517: WHERE wip_entity_id = p_wip_entity_id;
3518:
3519: l_employee_id NUMBER;
3520: l_wo_status AHL_WORKORDERS.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;

Line 3537: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;

3533: l_login_workorder_id NUMBER;
3534: l_login_op_seq_num NUMBER;
3535: l_login_resource_id NUMBER;
3536: l_login_resrc_seq_num NUMBER;
3537: l_login_wo_name AHL_WORKORDERS.workorder_name%TYPE;
3538: l_resource_id NUMBER;
3539: l_employee_name per_people_f.full_name%TYPE;
3540:
3541: l_fnd_function_name VARCHAR2(100);