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 BOM_RESOURCE_EMPLOYEES

Line 526: bom_resource_employees bre,

522: AND WOR.resource_seq_num = nvl(p_resource_seq_num, WOR.resource_seq_num)
523: -- qualified.
524: AND EXISTS (SELECT 'x'
525: FROM mtl_employees_current_view pf,
526: bom_resource_employees bre,
527: bom_dept_res_instances bdri,
528: wip_operations wo,
529: bom_department_resources bdr
530: WHERE WO.wip_entity_id = AW.wip_entity_id

Line 886: bom_resource_employees bre,

882: AND AW.workorder_id = p_workorder_id
883: -- qualified.
884: AND EXISTS (SELECT 'x'
885: FROM mtl_employees_current_view pf,
886: bom_resource_employees bre,
887: bom_dept_res_instances bdri,
888: wip_operations wo,
889: bom_department_resources bdr
890: WHERE WO.wip_entity_id = AW.wip_entity_id

Line 1207: bom_resource_employees bre,

1203: AND AW.workorder_id = p_workorder_id
1204: -- qualified.
1205: AND EXISTS (SELECT 'x'
1206: FROM mtl_employees_current_view pf,
1207: bom_resource_employees bre,
1208: bom_dept_res_instances bdri,
1209: wip_operations wo,
1210: bom_department_resources bdr
1211: WHERE WO.wip_entity_id = AW.wip_entity_id

Line 1788: FROM bom_resource_employees bre,

1784: AND WOR.resource_id = BRS.resource_id
1785: AND BRS.resource_type = 2 -- person.
1786: AND wo.wip_entity_id = p_wip_entity_id
1787: AND exists ( SELECT 'x'
1788: FROM bom_resource_employees bre,
1789: bom_dept_res_instances bdri,
1790: bom_department_resources bdr
1791: WHERE --WO.department_id = bdri.department_id
1792: nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id

Line 1819: FROM bom_resource_employees bre,

1815: AND BRS.resource_type = 2 -- person.
1816: AND wo.wip_entity_id = p_wip_entity_id
1817: AND wo.operation_seq_num = p_operation_seq_num
1818: AND exists ( SELECT 'x'
1819: FROM bom_resource_employees bre,
1820: bom_dept_res_instances bdri,
1821: bom_department_resources bdr
1822: WHERE --WO.department_id = bdri.department_id
1823: nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id

Line 1852: FROM bom_resource_employees bre,

1848: AND wo.wip_entity_id = p_wip_entity_id
1849: AND wo.operation_seq_num = p_operation_seq_num
1850: AND WOR.resource_seq_num = p_resource_seq_num
1851: AND exists ( SELECT 'x'
1852: FROM bom_resource_employees bre,
1853: bom_dept_res_instances bdri,
1854: bom_department_resources bdr
1855: WHERE --WO.department_id = bdri.department_id
1856: nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id

Line 2667: bom_resource_employees bre,

2663: WHERE wo.wip_entity_id = p_wip_entity_id
2664: AND not exists ( SELECT 'x'
2665: FROM wip_operation_resources WOR,
2666: bom_resources BRS,
2667: bom_resource_employees bre,
2668: bom_dept_res_instances bdri
2669: WHERE wo.operation_seq_num = WOR.operation_seq_num
2670: AND WOR.resource_id = BRS.resource_id
2671: AND BRS.resource_type = 2 -- person.

Line 2706: FROM bom_resource_employees bre,

2702: AND WOR.resource_id = BRS.resource_id
2703: AND BRS.resource_type = 2 -- person.
2704: AND wo.wip_entity_id = p_wip_entity_id
2705: AND exists ( SELECT 'x'
2706: FROM bom_resource_employees bre,
2707: bom_dept_res_instances bdri
2708: WHERE WO.department_id = bdri.department_id
2709: AND WOR.RESOURCE_ID= bdri.resource_id
2710: AND bre.instance_id = bdri.instance_id

Line 2731: FROM bom_resource_employees bre,

2727: AND BRS.resource_type = 2 -- person.
2728: AND wo.wip_entity_id = p_wip_entity_id
2729: AND wo.operation_seq_num = p_operation_seq_num
2730: AND exists ( SELECT 'x'
2731: FROM bom_resource_employees bre,
2732: bom_dept_res_instances bdri
2733: WHERE WO.department_id = bdri.department_id
2734: AND WOR.RESOURCE_ID= bdri.resource_id
2735: AND bre.instance_id = bdri.instance_id

Line 2773: bom_resource_employees bre,

2769: and wo.operation_seq_num = p_operation_seq_num
2770: AND exists ( SELECT 'x'
2771: FROM wip_operation_resources WOR,
2772: bom_resources BRS,
2773: bom_resource_employees bre,
2774: bom_dept_res_instances bdri,
2775: bom_department_resources bdr
2776: WHERE WOR.operation_seq_num = wo.operation_seq_num
2777: AND WOR.wip_entity_id = wo.wip_entity_id

Line 2808: FROM bom_resource_employees bre,

2804: AND wo.wip_entity_id = p_wip_entity_id
2805: AND WOR.operation_seq_num = p_operation_seq_num
2806: AND WOR.resource_id = p_resource_id
2807: AND not exists ( SELECT 'x'
2808: FROM bom_resource_employees bre,
2809: bom_dept_res_instances bdri,
2810: bom_department_resources bdr
2811: WHERE bre.resource_id = wor.resource_id
2812: AND bre.organization_id = wor.organization_id

Line 3436: bom_resource_employees bre,

3432: and wo.operation_seq_num = p_operation_seq_num
3433: AND exists ( SELECT 'x'
3434: FROM wip_operation_resources WOR,
3435: bom_resources BRS,
3436: bom_resource_employees bre,
3437: bom_dept_res_instances bdri,
3438: bom_department_resources bdr
3439: WHERE WOR.operation_seq_num = wo.operation_seq_num
3440: AND WOR.wip_entity_id = wo.wip_entity_id

Line 3471: FROM bom_resource_employees bre,

3467: AND wo.wip_entity_id = p_wip_entity_id
3468: AND WOR.operation_seq_num = p_operation_seq_num
3469: AND WOR.resource_id = p_resource_id
3470: AND not exists ( SELECT 'x'
3471: FROM bom_resource_employees bre,
3472: bom_dept_res_instances bdri,
3473: bom_department_resources bdr
3474: WHERE bre.resource_id = wor.resource_id
3475: AND bre.organization_id = wor.organization_id