DBA Data[Home] [Help]

APPS.AHL_MC_PATH_POSITION_PVT dependencies on AHL_MC_CONFIG_RELATIONS

Line 58: FROM ahl_mc_config_relations rel, ahl_mc_headers_b hd

54: p_pos_key IN NUMBER,
55: p_child_mc_id IN NUMBER,
56: p_child_ver_num IN NUMBER) IS
57: SELECT 'X'
58: FROM ahl_mc_config_relations rel, ahl_mc_headers_b hd
59: WHERE rel.mc_header_id = hd.mc_header_id
60: AND hd.mc_id = p_child_mc_id
61: AND hd.version_number = nvl(p_child_ver_num, hd.version_number)
62: AND rel.relationship_id IN

Line 2577: FROM ahl_mc_config_relations crel, ahl_mc_relationships subrel,

2573: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2574: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2575: UNION ALL
2576: SELECT subrel.relationship_id
2577: FROM ahl_mc_config_relations crel, ahl_mc_relationships subrel,
2578: csi_ii_relationships csi_ii
2579: WHERE csi_ii.subject_id = p_parent_instance_id
2580: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2581: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)