APPS.AHL_PRD_WO_LOGIN_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 526: bom_department_resources bdr

522: FROM mtl_employees_current_view pf,
523: bom_resource_employees bre,
524: bom_dept_res_instances bdri,
525: wip_operations wo,
526: bom_department_resources bdr
527: WHERE WO.wip_entity_id = AW.wip_entity_id
528: AND WO.operation_seq_num = AWO.operation_sequence_num
529: -- AND WO.department_id = bdri.department_id
530: AND nvl(bdr.share_from_dept_id,WO.department_id) = bdri.department_id

Line 886: bom_department_resources bdr

882: FROM mtl_employees_current_view pf,
883: bom_resource_employees bre,
884: bom_dept_res_instances bdri,
885: wip_operations wo,
886: bom_department_resources bdr
887: WHERE WO.wip_entity_id = AW.wip_entity_id
888: AND WO.operation_seq_num = AWO.operation_sequence_num
889: --AND WO.department_id = bdri.department_id
890: AND nvl(bdr.share_from_dept_id,WO.department_id) = bdri.department_id

Line 1207: bom_department_resources bdr

1203: FROM mtl_employees_current_view pf,
1204: bom_resource_employees bre,
1205: bom_dept_res_instances bdri,
1206: wip_operations wo,
1207: bom_department_resources bdr
1208: WHERE WO.wip_entity_id = AW.wip_entity_id
1209: AND WO.operation_seq_num = AWO.operation_sequence_num
1210: --AND WO.department_id = bdri.department_id
1211: AND nvl(bdr.share_from_dept_id,WO.department_id) = bdri.department_id

Line 1787: bom_department_resources bdr

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

Line 1818: bom_department_resources bdr

1814: AND wo.operation_seq_num = p_operation_seq_num
1815: AND exists ( SELECT 'x'
1816: FROM bom_resource_employees bre,
1817: bom_dept_res_instances bdri,
1818: bom_department_resources bdr
1819: WHERE --WO.department_id = bdri.department_id
1820: nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id
1821: AND bdr.department_id = WO.department_id
1822: AND bdr.resource_id = WOR.RESOURCE_ID

Line 1851: bom_department_resources bdr

1847: AND WOR.resource_seq_num = p_resource_seq_num
1848: AND exists ( SELECT 'x'
1849: FROM bom_resource_employees bre,
1850: bom_dept_res_instances bdri,
1851: bom_department_resources bdr
1852: WHERE --WO.department_id = bdri.department_id
1853: nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id
1854: AND bdr.department_id = WO.department_id
1855: AND bdr.resource_id = WOR.RESOURCE_ID

Line 2767: bom_department_resources bdr

2763: FROM wip_operation_resources WOR,
2764: bom_resources BRS,
2765: bom_resource_employees bre,
2766: bom_dept_res_instances bdri,
2767: bom_department_resources bdr
2768: WHERE WOR.operation_seq_num = wo.operation_seq_num
2769: AND WOR.wip_entity_id = wo.wip_entity_id
2770: AND WOR.resource_id = BRS.resource_id
2771: AND wor.organization_id = brs.organization_id

Line 2802: bom_department_resources bdr

2798: AND WOR.resource_id = p_resource_id
2799: AND not exists ( SELECT 'x'
2800: FROM bom_resource_employees bre,
2801: bom_dept_res_instances bdri,
2802: bom_department_resources bdr
2803: WHERE bre.resource_id = wor.resource_id
2804: AND bre.organization_id = wor.organization_id
2805: --AND WO.department_id = bdri.department_id
2806: AND nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id