View: AHL_PC_HEADERS_VL

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the table AHL_PC_HEADERS_B and the translated columns from the table AHL_PC_HEADERS_TL
Implementation/DBA Data:	APPS.AHL_PC_HEADERS_VL

View Text

SELECT AHPC.ROWID ROW_ID
, AHPC.PC_HEADER_ID
, AHPC.OBJECT_VERSION_NUMBER
, AHPC.LAST_UPDATE_DATE
, AHPC.LAST_UPDATED_BY
, AHPC.CREATION_DATE
, AHPC.CREATED_BY
, AHPC.LAST_UPDATE_LOGIN
, AHPC.NAME
, AHPC.STATUS
, AHPC.PRODUCT_TYPE_CODE
, AHPC.PRIMARY_FLAG
, AHPC.ASSOCIATION_TYPE_FLAG
, AHPC.DRAFT_FLAG
, AHPC.LINK_TO_PC_ID
, AHPCTL.DESCRIPTION
, AHPC.SECURITY_GROUP_ID
, AHPC.ATTRIBUTE_CATEGORY
, AHPC.ATTRIBUTE1
, AHPC.ATTRIBUTE2
, AHPC.ATTRIBUTE3
, AHPC.ATTRIBUTE4
, AHPC.ATTRIBUTE5
, AHPC.ATTRIBUTE6
, AHPC.ATTRIBUTE7
, AHPC.ATTRIBUTE8
, AHPC.ATTRIBUTE9
, AHPC.ATTRIBUTE10
, AHPC.ATTRIBUTE11
, AHPC.ATTRIBUTE12
, AHPC.ATTRIBUTE13
, AHPC.ATTRIBUTE14
, AHPC.ATTRIBUTE15
FROM AHL_PC_HEADERS_B AHPC
, AHL_PC_HEADERS_TL AHPCTL
WHERE AHPC.PC_HEADER_ID = AHPCTL.PC_HEADER_ID
AND AHPCTL.LANGUAGE = USERENV('LANG')

Columns