View: AHL_PLAN_VISITS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view stores the query relates to simulation plans and visit detail information
Implementation/DBA Data:	APPS.AHL_PLAN_VISITS_V

View Text

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') NUMBER_OF_VISITS
FROM AHL_SIMULATION_PLANS_VL ASPL
, AHL_VISITS_B AVTB
WHERE ASPL.SIMULATION_PLAN_ID = AVTB.SIMULATION_PLAN_ID(+)

Columns