View: AHL_PC_NODES_VL

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View Based on AHL_PC_NODES_B and AHL_PC_NODES_TL
Implementation/DBA Data:	APPS.AHL_PC_NODES_VL

View Text

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

Columns