View: EGO_RESULTS_FORMAT_COLUMNS_V

Product:	EGO - Advanced Product Catalog
Description:	This view stores all of the results columns associated with all of the results formats
Implementation/DBA Data:	APPS.EGO_RESULTS_FORMAT_COLUMNS_V

View Text

SELECT DISPLAY_QUERY.CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_APPLICATION_ID
, DISPLAY_QUERY.CUSTOMIZATION_CODE CUSTOMIZATION_CODE
, DISPLAY_QUERY.REGION_APPLICATION_ID REGION_APPLICATION_ID
, DISPLAY_QUERY.REGION_CODE REGION_CODE
, DISPLAY_QUERY.ATTRIBUTE_APPLICATION_ID ATTRIBUTE_APPLICATION_ID
, DISPLAY_QUERY.ATTRIBUTE_CODE ATTRIBUTE_CODE
, ORDER_QUERY.ORDER_SEQUENCE ORDER_SEQUENCE
, DISPLAY_QUERY.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, DIRECTION_QUERY.ORDER_DIRECTION ORDER_DIRECTION
, NAME_QUERY.COLUMN_NAME COLUMN_NAME
, TOTAL_QUERY.SHOW_TOTAL SHOW_TOTAL
FROM ( SELECT CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE CUSTOMIZATION_CODE
, REGION_APPLICATION_ID REGION_APPLICATION_ID
, REGION_CODE REGION_CODE
, ATTRIBUTE_APPLICATION_ID ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, PROPERTY_NUMBER_VALUE DISPLAY_SEQUENCE
FROM AK_CUSTOM_REGION_ITEMS
WHERE PROPERTY_NAME = 'DISPLAY_SEQUENCE' ) DISPLAY_QUERY
, ( SELECT CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE CUSTOMIZATION_CODE
, REGION_APPLICATION_ID REGION_APPLICATION_ID
, REGION_CODE REGION_CODE
, ATTRIBUTE_APPLICATION_ID ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, PROPERTY_NUMBER_VALUE ORDER_SEQUENCE
FROM AK_CUSTOM_REGION_ITEMS
WHERE PROPERTY_NAME = 'ORDER_SEQUENCE' ) ORDER_QUERY
, ( SELECT CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE CUSTOMIZATION_CODE
, REGION_APPLICATION_ID REGION_APPLICATION_ID
, REGION_CODE REGION_CODE
, ATTRIBUTE_APPLICATION_ID ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, PROPERTY_VARCHAR2_VALUE ORDER_DIRECTION
FROM AK_CUSTOM_REGION_ITEMS
WHERE PROPERTY_NAME = 'ORDER_DIRECTION' ) DIRECTION_QUERY
, ( SELECT CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE CUSTOMIZATION_CODE
, REGION_APPLICATION_ID REGION_APPLICATION_ID
, REGION_CODE REGION_CODE
, ATTRIBUTE_APPLICATION_ID ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, PROPERTY_VARCHAR2_VALUE COLUMN_NAME
FROM AK_CUSTOM_REGION_ITEMS
WHERE PROPERTY_NAME = 'COLUMN_NAME' ) NAME_QUERY
, ( SELECT CUSTOMIZATION_APPLICATION_ID CUSTOMIZATION_APPLICATION_ID
, CUSTOMIZATION_CODE CUSTOMIZATION_CODE
, REGION_APPLICATION_ID REGION_APPLICATION_ID
, REGION_CODE REGION_CODE
, ATTRIBUTE_APPLICATION_ID ATTRIBUTE_APPLICATION_ID
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, PROPERTY_VARCHAR2_VALUE SHOW_TOTAL
FROM AK_CUSTOM_REGION_ITEMS
WHERE PROPERTY_NAME = 'SHOW_TOTAL' ) TOTAL_QUERY
WHERE DISPLAY_QUERY.CUSTOMIZATION_APPLICATION_ID = ORDER_QUERY.CUSTOMIZATION_APPLICATION_ID (+)
AND DISPLAY_QUERY.CUSTOMIZATION_CODE = ORDER_QUERY.CUSTOMIZATION_CODE (+)
AND DISPLAY_QUERY.REGION_APPLICATION_ID = ORDER_QUERY.REGION_APPLICATION_ID (+)
AND DISPLAY_QUERY.REGION_CODE = ORDER_QUERY.REGION_CODE (+)
AND DISPLAY_QUERY.ATTRIBUTE_APPLICATION_ID = ORDER_QUERY.ATTRIBUTE_APPLICATION_ID (+)
AND DISPLAY_QUERY.ATTRIBUTE_CODE = ORDER_QUERY.ATTRIBUTE_CODE (+)
AND DISPLAY_QUERY.CUSTOMIZATION_APPLICATION_ID = DIRECTION_QUERY.CUSTOMIZATION_APPLICATION_ID (+)
AND DISPLAY_QUERY.CUSTOMIZATION_CODE = DIRECTION_QUERY.CUSTOMIZATION_CODE (+)
AND DISPLAY_QUERY.REGION_APPLICATION_ID = DIRECTION_QUERY.REGION_APPLICATION_ID (+)
AND DISPLAY_QUERY.REGION_CODE = DIRECTION_QUERY.REGION_CODE (+)
AND DISPLAY_QUERY.ATTRIBUTE_APPLICATION_ID = DIRECTION_QUERY.ATTRIBUTE_APPLICATION_ID (+)
AND DISPLAY_QUERY.ATTRIBUTE_CODE = DIRECTION_QUERY.ATTRIBUTE_CODE (+)
AND DISPLAY_QUERY.CUSTOMIZATION_APPLICATION_ID = NAME_QUERY.CUSTOMIZATION_APPLICATION_ID (+)
AND DISPLAY_QUERY.CUSTOMIZATION_CODE = NAME_QUERY.CUSTOMIZATION_CODE (+)
AND DISPLAY_QUERY.REGION_APPLICATION_ID = NAME_QUERY.REGION_APPLICATION_ID (+)
AND DISPLAY_QUERY.REGION_CODE = NAME_QUERY.REGION_CODE (+)
AND DISPLAY_QUERY.ATTRIBUTE_APPLICATION_ID = NAME_QUERY.ATTRIBUTE_APPLICATION_ID (+)
AND DISPLAY_QUERY.ATTRIBUTE_CODE = NAME_QUERY.ATTRIBUTE_CODE (+)
AND DISPLAY_QUERY.CUSTOMIZATION_APPLICATION_ID = TOTAL_QUERY.CUSTOMIZATION_APPLICATION_ID (+)
AND DISPLAY_QUERY.CUSTOMIZATION_CODE = TOTAL_QUERY.CUSTOMIZATION_CODE (+)
AND DISPLAY_QUERY.REGION_APPLICATION_ID = TOTAL_QUERY.REGION_APPLICATION_ID (+)
AND DISPLAY_QUERY.REGION_CODE = TOTAL_QUERY.REGION_CODE (+)
AND DISPLAY_QUERY.ATTRIBUTE_APPLICATION_ID = TOTAL_QUERY.ATTRIBUTE_APPLICATION_ID (+)
AND DISPLAY_QUERY.ATTRIBUTE_CODE = TOTAL_QUERY.ATTRIBUTE_CODE (+)

Columns