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_DEPT_RES_INSTANCES

Line 527: bom_dept_res_instances bdri,

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
531: AND WO.operation_seq_num = AWO.operation_sequence_num

Line 887: bom_dept_res_instances bdri,

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
891: AND WO.operation_seq_num = AWO.operation_sequence_num

Line 1208: bom_dept_res_instances bdri,

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
1212: AND WO.operation_seq_num = AWO.operation_sequence_num

Line 1789: bom_dept_res_instances bdri,

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
1793: AND bdr.department_id = WO.department_id

Line 1820: bom_dept_res_instances bdri,

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
1824: AND bdr.department_id = WO.department_id

Line 1853: bom_dept_res_instances bdri,

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
1857: AND bdr.department_id = WO.department_id

Line 2668: bom_dept_res_instances bdri

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.
2672: AND WO.department_id = bdri.department_id

Line 2707: bom_dept_res_instances bdri

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
2711: AND bre.resource_id = bdri.resource_id

Line 2732: bom_dept_res_instances bdri

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
2736: AND bre.resource_id = bdri.resource_id

Line 2774: bom_dept_res_instances bdri,

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
2778: AND WOR.resource_id = BRS.resource_id

Line 2809: bom_dept_res_instances bdri,

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
2813: --AND WO.department_id = bdri.department_id

Line 3437: bom_dept_res_instances bdri,

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
3441: AND WOR.resource_id = BRS.resource_id

Line 3472: bom_dept_res_instances bdri,

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
3476: --AND WO.department_id = bdri.department_id