VIEW: APPS.AHL_PLAN_VISITS_V

Source

View Text - Preformatted

SELECT DISTINCT(ASPL.SIMULATION_PLAN_ID), SIMULATION_PLAN_NAME, ASPL.OBJECT_VERSION_NUMBER, PRIMARY_PLAN_FLAG, (SELECT COUNT(*) FROM AHL_VISITS_VL A WHERE SIMULATION_PLAN_ID IN (SELECT SIMULATION_PLAN_ID FROM AHL_SIMULATION_PLANS_VL WHERE SIMULATION_PLAN_ID = ASPL.SIMULATION_PLAN_ID) AND A.TEMPLATE_FLAG = 'N' AND A.STATUS_CODE = 'PLANNING' AND (A.ORGANIZATION_ID is NULL OR A.ORGANIZATION_ID IN ( SELECT organization_id FROM org_organization_definitions WHERE operating_unit = mo_global.get_current_org_id() )) AND ( a.item_instance_id IS NULL OR EXISTS ( SELECT 1 FROM ahl_unit_config_headers uc WHERE a.item_instance_id = uc.csi_item_instance_id AND nvl(uc.active_end_date,sysdate) >= sysdate ) ) ) NUMBER_OF_VISITS FROM AHL_SIMULATION_PLANS_VL ASPL, AHL_VISITS_B AVTB WHERE ASPL.SIMULATION_PLAN_ID = AVTB.SIMULATION_PLAN_ID(+)

View Text - HTML Formatted

SELECT DISTINCT(ASPL.SIMULATION_PLAN_ID)
, SIMULATION_PLAN_NAME
, ASPL.OBJECT_VERSION_NUMBER
, PRIMARY_PLAN_FLAG
, (SELECT COUNT(*)
FROM AHL_VISITS_VL A
WHERE SIMULATION_PLAN_ID IN (SELECT SIMULATION_PLAN_ID
FROM AHL_SIMULATION_PLANS_VL
WHERE SIMULATION_PLAN_ID = ASPL.SIMULATION_PLAN_ID)
AND A.TEMPLATE_FLAG = 'N'
AND A.STATUS_CODE = 'PLANNING'
AND (A.ORGANIZATION_ID IS NULL OR A.ORGANIZATION_ID IN ( SELECT ORGANIZATION_ID
FROM ORG_ORGANIZATION_DEFINITIONS
WHERE OPERATING_UNIT = MO_GLOBAL.GET_CURRENT_ORG_ID() ))
AND ( A.ITEM_INSTANCE_ID IS NULL OR EXISTS ( SELECT 1
FROM AHL_UNIT_CONFIG_HEADERS UC
WHERE A.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID
AND NVL(UC.ACTIVE_END_DATE
, SYSDATE) >= SYSDATE ) ) ) NUMBER_OF_VISITS
FROM AHL_SIMULATION_PLANS_VL ASPL
, AHL_VISITS_B AVTB
WHERE ASPL.SIMULATION_PLAN_ID = AVTB.SIMULATION_PLAN_ID(+)