APPS.AHL_PRD_WO_LOGIN_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 529: bom_department_resources bdr

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
532: -- AND WO.department_id = bdri.department_id
533: AND nvl(bdr.share_from_dept_id,WO.department_id) = bdri.department_id

Line 889: bom_department_resources bdr

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
892: --AND WO.department_id = bdri.department_id
893: AND nvl(bdr.share_from_dept_id,WO.department_id) = bdri.department_id

Line 1210: bom_department_resources bdr

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
1213: --AND WO.department_id = bdri.department_id
1214: AND nvl(bdr.share_from_dept_id,WO.department_id) = bdri.department_id

Line 1790: bom_department_resources bdr

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
1794: AND bdr.resource_id = WOR.RESOURCE_ID

Line 1821: bom_department_resources bdr

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
1825: AND bdr.resource_id = WOR.RESOURCE_ID

Line 1854: bom_department_resources bdr

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
1858: AND bdr.resource_id = WOR.RESOURCE_ID

Line 2775: bom_department_resources bdr

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
2779: AND wor.organization_id = brs.organization_id

Line 2810: bom_department_resources bdr

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
2814: AND nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id

Line 3438: bom_department_resources bdr

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
3442: AND wor.organization_id = brs.organization_id

Line 3473: bom_department_resources bdr

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
3477: AND nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id