Product: | IMC - Customers Online |
---|---|
Description: | VIEW FOR IMC_THREE_SIXTY_QUERY |
Implementation/DBA Data: | APPS.IMC_THREE_SIXTY_QUERY_VL |
SELECT B.ROWID ROW_ID
, B.QUERY_ID QUERY_ID
, B.APPLICATION_ID APPLICATION_ID
, B.QUERY_TYPE_FLAG QUERY_TYPE_FLAG
, B.FILTER_COUNT FILTER_COUNT
, B.DISPLAY_COLUMN_COUNT DISPLAY_COLUMN_COUNT
, B.PRODUCT_QUERY1 PRODUCT_QUERY1
, B.PRODUCT_QUERY2 PRODUCT_QUERY2
, B.PRODUCT_QUERY3 PRODUCT_QUERY3
, B.PRODUCT_QUERY4 PRODUCT_QUERY4
, B.PRODUCT_QUERY5 PRODUCT_QUERY5
, B.SEQUENCE_NO SEQUENCE_NO
, B.DISPLAY_FLAG DISPLAY_FLAG
, B.SECURITY_FUNCTION SECURITY_FUNCTION
, B.PRODUCT_URL PRODUCT_URL
, T.TRANSACTION_NAME TRANSACTION_NAME
, T.HEADER_TEXT HEADER_TEXT
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, B.BE_CODE BE_CODE
, B.CATEGORY_CODE CATEGORY_CODE
, B.OPERATING_UNIT_FLAG OPERATING_UNIT_FLAG
FROM IMC_THREE_SIXTY_QUERY_TL T
, IMC_THREE_SIXTY_QUERY_B B
WHERE B.QUERY_ID = T.QUERY_ID
AND T.LANGUAGE = USERENV('LANG')