APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_MC_HEADERS_B

Line 2047: FROM ahl_mc_headers_b mc

2043: IS
2044: SELECT
2045: mc.name,
2046: DECODE(c_mc_header_id, NULL, NULL, mc.revision)
2047: FROM ahl_mc_headers_b mc
2048: WHERE
2049: NVL(c_mc_header_id, c_mc_id)=mc.mc_header_id(+) AND
2050: mc.CONFIG_STATUS_CODE(+)='COMPLETE';
2051: --END