View: AHL_VISITS_VL

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view stores the query to retrieve Visit information
Implementation/DBA Data:	APPS.AHL_VISITS_VL

View Text

SELECT AVTB.ROWID ROW_ID
, AVTB.VISIT_ID
, AVTB.VISIT_NUMBER
, AVTB.OBJECT_VERSION_NUMBER
, AVTB.LAST_UPDATE_DATE
, AVTB.LAST_UPDATED_BY
, AVTB.CREATION_DATE
, AVTB.CREATED_BY
, AVTB.LAST_UPDATE_LOGIN
, AVTB.ORGANIZATION_ID
, AVTB.DEPARTMENT_ID
, AVTB.STATUS_CODE
, AVTB.START_DATE_TIME
, AVTB.VISIT_TYPE_CODE
, AVTB.SIMULATION_PLAN_ID
, AVTB.ITEM_INSTANCE_ID
, AVTB.ITEM_ORGANIZATION_ID
, AVTB.INVENTORY_ITEM_ID
, AVTB.ASSO_PRIMARY_VISIT_ID
, AVTB.SIMULATION_DELETE_FLAG
, AVTB.TEMPLATE_FLAG
, AVTB.OUT_OF_SYNC_FLAG
, AVTB.PROJECT_FLAG
, AVTB.PROJECT_ID
, AVTT.VISIT_NAME
, AVTT.DESCRIPTION
, AVTB.SERVICE_REQUEST_ID
, AVTB.SPACE_CATEGORY_CODE
, AVTB.CLOSE_DATE_TIME
, AVTB.SCHEDULE_DESIGNATOR
, AVTB.ATTRIBUTE_CATEGORY
, AVTB.ATTRIBUTE1
, AVTB.ATTRIBUTE2
, AVTB.ATTRIBUTE3
, AVTB.ATTRIBUTE4
, AVTB.ATTRIBUTE5
, AVTB.ATTRIBUTE6
, AVTB.ATTRIBUTE7
, AVTB.ATTRIBUTE8
, AVTB.ATTRIBUTE9
, AVTB.ATTRIBUTE10
, AVTB.ATTRIBUTE11
, AVTB.ATTRIBUTE12
, AVTB.ATTRIBUTE13
, AVTB.ATTRIBUTE14
, AVTB.ATTRIBUTE15
, AVTB.PRICE_LIST_ID
, AVTB.ESTIMATED_PRICE
, AVTB.ACTUAL_PRICE
, AVTB.OUTSIDE_PARTY_FLAG
, AVTB.ANY_TASK_CHG_FLAG
FROM AHL_VISITS_B AVTB
, AHL_VISITS_TL AVTT
WHERE AVTB.VISIT_ID = AVTT.VISIT_ID
AND AVTT.LANGUAGE = USERENV('LANG')

Columns