DBA Data[Home] [Help]

APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 415: FROM csi_ii_relationships

411: IS
412: SELECT csi_item_instance_id
413: FROM ahl_unit_config_headers uc
414: WHERE csi_item_instance_id in ( SELECT object_id
415: FROM csi_ii_relationships
416: START WITH object_id = c_item_instance_id
417: AND relationship_type_code = 'COMPONENT-OF'
418: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
419: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))