APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_MC_HEADERS_B

Line 1644: AHL_MC_RELATIONSHIPS AMR, AHL_MC_HEADERS_B AHB

1640: c_position_key AHL_MC_RELATIONSHIPS.position_key%TYPE )
1641: IS
1642: SELECT COUNT(amr.position_key)
1643: FROM
1644: AHL_MC_RELATIONSHIPS AMR, AHL_MC_HEADERS_B AHB
1645: WHERE
1646: amr.mc_header_id = ahb.mc_header_id AND
1647: ahb.mc_id = c_mc_id AND
1648: amr.position_key = c_position_key;

Line 1991: FROM ahl_mc_headers_b mc

1987: IS
1988: SELECT
1989: mc.name,
1990: DECODE(c_mc_header_id, NULL, NULL, mc.revision)
1991: FROM ahl_mc_headers_b mc
1992: WHERE
1993: NVL(c_mc_header_id, c_mc_id)=mc.mc_header_id(+) AND
1994: mc.CONFIG_STATUS_CODE(+)='COMPLETE';
1995: --END