VIEW: APPS.AHL_PC_NODES_VL

Source

View Text - Preformatted

SELECT AHNO.ROWID ROW_ID, AHNO.PC_NODE_ID, AHNO.OBJECT_VERSION_NUMBER, AHNO.LAST_UPDATE_DATE, AHNO.LAST_UPDATED_BY, AHNO.CREATION_DATE, AHNO.CREATED_BY, AHNO.LAST_UPDATE_LOGIN, AHNO.PC_HEADER_ID, AHNO.NAME, AHNO.PARENT_NODE_ID, AHNO.LINK_TO_NODE_ID, AHNO.CHILD_COUNT, AHNO.DRAFT_FLAG, AHNOTL.DESCRIPTION, AHNO.OPERATION_STATUS_FLAG, AHNO.SECURITY_GROUP_ID, AHNO.ATTRIBUTE_CATEGORY, AHNO.ATTRIBUTE1, AHNO.ATTRIBUTE2, AHNO.ATTRIBUTE3, AHNO.ATTRIBUTE4, AHNO.ATTRIBUTE5, AHNO.ATTRIBUTE6, AHNO.ATTRIBUTE7, AHNO.ATTRIBUTE8, AHNO.ATTRIBUTE9, AHNO.ATTRIBUTE10, AHNO.ATTRIBUTE11, AHNO.ATTRIBUTE12, AHNO.ATTRIBUTE13, AHNO.ATTRIBUTE14, AHNO.ATTRIBUTE15 FROM AHL_PC_NODES_B AHNO, AHL_PC_NODES_TL AHNOTL WHERE AHNO.PC_NODE_ID = AHNOTL.PC_NODE_ID AND AHNOTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT AHNO.ROWID ROW_ID
, AHNO.PC_NODE_ID
, AHNO.OBJECT_VERSION_NUMBER
, AHNO.LAST_UPDATE_DATE
, AHNO.LAST_UPDATED_BY
, AHNO.CREATION_DATE
, AHNO.CREATED_BY
, AHNO.LAST_UPDATE_LOGIN
, AHNO.PC_HEADER_ID
, AHNO.NAME
, AHNO.PARENT_NODE_ID
, AHNO.LINK_TO_NODE_ID
, AHNO.CHILD_COUNT
, AHNO.DRAFT_FLAG
, AHNOTL.DESCRIPTION
, AHNO.OPERATION_STATUS_FLAG
, AHNO.SECURITY_GROUP_ID
, AHNO.ATTRIBUTE_CATEGORY
, AHNO.ATTRIBUTE1
, AHNO.ATTRIBUTE2
, AHNO.ATTRIBUTE3
, AHNO.ATTRIBUTE4
, AHNO.ATTRIBUTE5
, AHNO.ATTRIBUTE6
, AHNO.ATTRIBUTE7
, AHNO.ATTRIBUTE8
, AHNO.ATTRIBUTE9
, AHNO.ATTRIBUTE10
, AHNO.ATTRIBUTE11
, AHNO.ATTRIBUTE12
, AHNO.ATTRIBUTE13
, AHNO.ATTRIBUTE14
, AHNO.ATTRIBUTE15
FROM AHL_PC_NODES_B AHNO
, AHL_PC_NODES_TL AHNOTL
WHERE AHNO.PC_NODE_ID = AHNOTL.PC_NODE_ID
AND AHNOTL.LANGUAGE = USERENV('LANG')