DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_RESOURCE_MAPPINGS

Line 1537: FROM BOM_DEPARTMENT_RESOURCES BD, AHL_RESOURCE_MAPPINGS MAP,

1533: CURSOR get_res_dept_csr (p_aso_resource_id IN NUMBER,
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

Line 1735: AHL_RESOURCE_MAPPINGS MAP

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
1739: AND BR.resource_id=MAP.bom_resource_id

Line 1917: AHL_RESOURCE_MAPPINGS MAP

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
1921: AND BR.resource_id=MAP.bom_resource_id