DBA Data[Home] [Help]

APPS.AHL_MC_MASTERCONFIG_PVT dependencies on AHL_MC_HEADERS_V

Line 1599: FROM AHL_MC_HEADERS_VL

1595: ATTRIBUTE13,
1596: ATTRIBUTE14,
1597: ATTRIBUTE15,
1598: DESCRIPTION
1599: FROM AHL_MC_HEADERS_VL
1600: WHERE MC_HEADER_ID = p_mc_header_id;
1601:
1602: -- 2. Define get_topnode_rec_csr to get the details of the topnode record for a particular MC
1603: CURSOR get_topnode_rec_csr

Line 2088: FROM ahl_mc_headers_v mch,

2084: SELECT mch.config_status_code,
2085: mcr.relationship_id,
2086: mcr.object_version_number,
2087: mcr.item_group_id
2088: FROM ahl_mc_headers_v mch,
2089: ahl_mc_relationships mcr
2090: WHERE mch.mc_header_id = p_mc_header_id AND
2091: mch.mc_header_id = mcr.mc_header_id AND
2092: mcr.parent_relationship_id IS NULL;

Line 2873: FROM ahl_mc_headers_v

2869: IS
2870: CURSOR get_mc_status
2871: IS
2872: SELECT config_status_code
2873: FROM ahl_mc_headers_v
2874: WHERE mc_header_id = p_mc_header_id;
2875:
2876: l_status VARCHAR2(30);
2877: