eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EGO_RESULTS_FORMAT_COLUMNS_V

Source

View Text - Preformatted


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 (+)

View Text - HTML Formatted

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 (+)