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 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 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 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 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