View: AHL_PC_TREE_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view has PC Tree info
Implementation/DBA Data:	APPS.AHL_PC_TREE_V

View Text

SELECT AHNO.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.CHILD_COUNT
, AHNO.LINK_TO_NODE_ID
, AHNO.DRAFT_FLAG
, AHNO.DESCRIPTION
, 'N' NODE_TYPE
, 0 UNIT_ITEM_ID
, 0 INVENTORY_ORG_ID
, 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_VL AHNO UNION SELECT AHASS.ROW_ID
, AHASS.PC_ASSOCIATION_ID PC_NODE_ID
, AHASS.OBJECT_VERSION_NUMBER
, AHASS.LAST_UPDATE_DATE
, AHASS.LAST_UPDATED_BY
, AHASS.CREATION_DATE
, AHASS.CREATED_BY
, AHASS.LAST_UPDATE_LOGIN
, AHNO.PC_HEADER_ID
, AHASS.UNIT_ITEM_NAME NAME
, AHASS.PC_NODE_ID PARENT_NODE_ID
, 0 CHILD_COUNT
, AHASS.LINK_TO_ASSOCIATION_ID LINK_TO_NODE_ID
, AHASS.DRAFT_FLAG
, AHASS.UNIT_ITEM_DESCRIPTION DESCRIPTION
, AHASS.ASSOCIATION_TYPE_FLAG NODE_TYPE
, AHASS.UNIT_ITEM_ID
, AHASS.INVENTORY_ORG_ID
, AHASS.OPERATION_STATUS_FLAG
, AHASS.SECURITY_GROUP_ID
, AHASS.ATTRIBUTE_CATEGORY
, AHASS.ATTRIBUTE1
, AHASS.ATTRIBUTE2
, AHASS.ATTRIBUTE3
, AHASS.ATTRIBUTE4
, AHASS.ATTRIBUTE5
, AHASS.ATTRIBUTE6
, AHASS.ATTRIBUTE7
, AHASS.ATTRIBUTE8
, AHASS.ATTRIBUTE9
, AHASS.ATTRIBUTE10
, AHASS.ATTRIBUTE11
, AHASS.ATTRIBUTE12
, AHASS.ATTRIBUTE13
, AHASS.ATTRIBUTE14
, AHASS.ATTRIBUTE15
FROM AHL_PC_ASSOCIATIONS_V AHASS
, AHL_PC_NODES_VL AHNO
WHERE AHNO.PC_NODE_ID = AHASS.PC_NODE_ID

Columns