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.

[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on AHL_OPERATION_RESOURCES

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 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 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 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 3548: FROM AHL_Operation_Resources AOR, AHL_WORK_LOGIN_TIMES WLGN

3544: SELECT WLGN.workorder_id,
3545: WLGN.operation_seq_num,
3546: AOR.resource_id,
3547: WLGN.resource_seq_num
3548: FROM AHL_Operation_Resources AOR, AHL_WORK_LOGIN_TIMES WLGN
3549: WHERE WLGN.operation_resource_id = AOR.operation_resource_id(+)
3550: AND WLGN.employee_id = c_employee_id
3551: AND WLGN.logout_date IS NULL;
3552:

Line 3766: FROM AHL_Operation_Resources AOR, AHL_WORK_LOGIN_TIMES WLGN

3762: SELECT WLGN.workorder_id,
3763: WLGN.operation_seq_num,
3764: AOR.resource_id,
3765: WLGN.resource_seq_num
3766: FROM AHL_Operation_Resources AOR, AHL_WORK_LOGIN_TIMES WLGN
3767: WHERE WLGN.operation_resource_id = AOR.operation_resource_id(+)
3768: AND WLGN.employee_id = c_employee_id
3769: AND WLGN.logout_date IS NULL; -- employee logged in.
3770: BEGIN