DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on BOM_DEPARTMENT_RESOURCES

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 1733: FROM BOM_DEPARTMENT_RESOURCES BDR,

1729: BR.resource_code,
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

Line 1915: FROM BOM_DEPARTMENT_RESOURCES BDR,

1911: BR.resource_code,
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