[Home] [Help]
1665: CURSOR get_res_dept_csr (p_aso_resource_id IN NUMBER,
1666: p_org_id IN NUMBER)
1667: IS
1668: SELECT DISTINCT MAP.department_id, DEPT.description
1669: FROM BOM_DEPARTMENT_RESOURCES BD, AHL_RESOURCE_MAPPINGS MAP,
1670: BOM_RESOURCES BR, BOM_DEPARTMENTS DEPT
1671: WHERE BD.resource_id = MAP.bom_resource_id
1672: AND BR.resource_id = BD.resource_id
1673: AND BR.organization_id = p_org_id
1899: BR.resource_code,
1900: BR.resource_type,
1901: BR.description,
1902: BR.unit_of_measure
1903: FROM BOM_DEPARTMENT_RESOURCES BDR,
1904: BOM_RESOURCES BR,
1905: AHL_RESOURCE_MAPPINGS MAP
1906: WHERE BDR.department_id=c_dept_id
1907: AND BDR.resource_id=BR.resource_id
1924: BR.resource_code,
1925: BR.resource_type,
1926: BR.description,
1927: BR.unit_of_measure
1928: FROM BOM_DEPARTMENT_RESOURCES BDR,
1929: BOM_RESOURCES BR,
1930: AHL_RESOURCE_MAPPINGS MAP
1931: WHERE BDR.resource_id = BR.resource_id
1932: AND BR.resource_id = MAP.bom_resource_id
2112: BR.resource_code,
2113: BR.resource_type,
2114: BR.description,
2115: BR.unit_of_measure
2116: FROM BOM_DEPARTMENT_RESOURCES BDR,
2117: BOM_RESOURCES BR,
2118: AHL_RESOURCE_MAPPINGS MAP
2119: WHERE BDR.department_id=c_dept_id
2120: AND BDR.resource_id=BR.resource_id
2137: BR.resource_code,
2138: BR.resource_type,
2139: BR.description,
2140: BR.unit_of_measure
2141: FROM BOM_DEPARTMENT_RESOURCES BDR,
2142: BOM_RESOURCES BR,
2143: AHL_RESOURCE_MAPPINGS MAP
2144: WHERE BDR.resource_id = BR.resource_id
2145: AND BR.resource_id = MAP.bom_resource_id
2421: BR.unit_of_measure,
2422: RESTYPE.meaning resource_type_name,
2423: c_aso_resource_dur duration
2424:
2425: FROM BOM_DEPARTMENT_RESOURCES BDR,
2426: BOM_RESOURCES BR,
2427: AHL_RESOURCE_MAPPINGS MAP,
2428: MFG_LOOKUPS RESTYPE
2429: