VIEW: APPS.AHL_VISITS_VL

Source

View Text - Preformatted

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, AVTB.PRIORITY_CODE, AVTB.PROJECT_TEMPLATE_ID, AVTB.UNIT_SCHEDULE_ID, AVTB.INV_LOCATOR_ID FROM AHL_VISITS_B AVTB, AHL_VISITS_TL AVTT WHERE AVTB.VISIT_ID = AVTT.VISIT_ID AND AVTT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

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
, AVTB.PRIORITY_CODE
, AVTB.PROJECT_TEMPLATE_ID
, AVTB.UNIT_SCHEDULE_ID
, AVTB.INV_LOCATOR_ID
FROM AHL_VISITS_B AVTB
, AHL_VISITS_TL AVTT
WHERE AVTB.VISIT_ID = AVTT.VISIT_ID
AND AVTT.LANGUAGE = USERENV('LANG')