DBA Data[Home] [Help]

APPS.AHL_MC_MASTERCONFIG_PVT dependencies on AHL_MC_RELATIONSHIPS_V

Line 1642: FROM AHL_MC_RELATIONSHIPS_V

1638: ATTRIBUTE12,
1639: ATTRIBUTE13,
1640: ATTRIBUTE14,
1641: ATTRIBUTE15
1642: FROM AHL_MC_RELATIONSHIPS_V
1643: WHERE MC_HEADER_ID = p_mc_header_id AND
1644: PARENT_RELATIONSHIP_ID IS NULL;
1645:
1646: -- Define cursor check_latest_rev to validate latest revision of MC being used for copying

Line 2959: FROM ahl_mc_relationships_v

2955: p_mc_header_id IN NUMBER
2956: )
2957: IS
2958: SELECT relationship_id, position_ref_meaning, position_necessity_code
2959: FROM ahl_mc_relationships_v
2960: WHERE mc_header_id = p_mc_header_id;
2961:
2962: -- 2. Define cursor get_node_subconfigs_csr to read details about MCs associated as subconfigs to a MC node
2963: CURSOR get_node_subconfigs_csr