APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_UNIT_INSTALLED_DETAILS_V

Line 4967: FROM ahl_unit_installed_details_v A,

4963: B.mc_revision,
4964: B.mc_status,
4965: B.position_ref,
4966: B.root_uc_header_id
4967: FROM ahl_unit_installed_details_v A,
4968: ahl_unit_config_headers_v B
4969: WHERE csi_item_instance_id = c_csi_item_instance_id
4970: AND A.csi_item_instance_id = B.csi_instance_id (+)
4971: AND trunc(nvl(B.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE);

Line 5655: from ahl_unit_installed_details_v a,

5651: b.mc_revision,
5652: b.mc_status,
5653: b.position_ref,
5654: b.root_uc_header_id
5655: from ahl_unit_installed_details_v a,
5656: (
5657: SELECT U.unit_config_header_id uc_header_id,
5658: U.name uc_name,
5659: UCSC.meaning uc_status,