VIEW: APPS.AHL_PC_HEADERS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')