VIEW: APPS.AHL_PC_TREE_V

Source

View Text - Preformatted

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, AHASS.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

View Text - HTML Formatted

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
, AHASS.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