eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_RESOURCE_MAPPINGS

Line 1669: FROM BOM_DEPARTMENT_RESOURCES BD, AHL_RESOURCE_MAPPINGS MAP,

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

Line 1905: AHL_RESOURCE_MAPPINGS MAP

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
1908: AND BR.organization_id=c_org_id
1909: AND BR.resource_id=MAP.bom_resource_id

Line 1930: AHL_RESOURCE_MAPPINGS MAP

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
1933: AND MAP.aso_resource_id= c_aso_resource_id
1934: AND BDR.department_id = c_dept_id

Line 2118: AHL_RESOURCE_MAPPINGS MAP

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
2121: AND BR.organization_id=c_org_id
2122: AND BR.resource_id=MAP.bom_resource_id

Line 2143: AHL_RESOURCE_MAPPINGS MAP

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
2146: AND MAP.aso_resource_id= c_aso_resource_id
2147: AND BDR.department_id = c_dept_id

Line 2427: AHL_RESOURCE_MAPPINGS MAP,

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:
2430: WHERE BDR.resource_id = BR.resource_id
2431: AND BR.resource_id = MAP.bom_resource_id