DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on BOM_RESOURCES

Line 1538: BOM_RESOURCES BR, BOM_DEPARTMENTS DEPT

1534: p_org_id IN NUMBER)
1535: IS
1536: SELECT DISTINCT MAP.department_id, DEPT.description
1537: FROM BOM_DEPARTMENT_RESOURCES BD, AHL_RESOURCE_MAPPINGS MAP,
1538: BOM_RESOURCES BR, BOM_DEPARTMENTS DEPT
1539: WHERE BD.resource_id = MAP.bom_resource_id
1540: AND BR.resource_id = BD.resource_id
1541: AND BR.organization_id = p_org_id
1542: AND MAP.aso_resource_id = p_aso_resource_id

Line 1734: BOM_RESOURCES BR,

1730: BR.resource_type,
1731: BR.description,
1732: BR.unit_of_measure
1733: FROM BOM_DEPARTMENT_RESOURCES BDR,
1734: BOM_RESOURCES BR,
1735: AHL_RESOURCE_MAPPINGS MAP
1736: WHERE BDR.department_id=c_dept_id
1737: AND BDR.resource_id=BR.resource_id
1738: AND BR.organization_id=c_org_id

Line 1916: BOM_RESOURCES BR,

1912: BR.resource_type,
1913: BR.description,
1914: BR.unit_of_measure
1915: FROM BOM_DEPARTMENT_RESOURCES BDR,
1916: BOM_RESOURCES BR,
1917: AHL_RESOURCE_MAPPINGS MAP
1918: WHERE BDR.department_id=c_dept_id
1919: AND BDR.resource_id=BR.resource_id
1920: AND BR.organization_id=c_org_id