VIEW: APPS.ICX_PANEL_SUMMARY_V

Source

View Text - Preformatted

SELECT CUSTOMER_ID , DATA_AS_OF_DATE , PROGRAM_APPLICATION_ID , PROGRAM_UPDATE_DATE , SAME_SUPPLY_CHAIN_FLAG , currency_code , last_order_header_id , to_char(ORDERS_AMOUNT_LAST_WEEK, fnd_currency.safe_get_format_mask(currency_code,30)) , ORDERS_LAST_WEEK , to_char(ORDERS_AMOUNT_LAST_MONTH, fnd_currency.safe_get_format_mask(currency_code,30)) , ORDERS_LAST_MONTH , to_char(ORDERS_AMOUNT_LAST_3_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , ORDERS_LAST_3_MONTHS , to_char(ORDERS_AMOUNT_LAST_6_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , ORDERS_LAST_6_MONTHS , to_char(ORDERS_AMOUNT_LAST_12_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , ORDERS_LAST_12_MONTHS , CANCELLED_ORDERS_3_MONTHS , to_char(CANCELLED_AMOUNT_3_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , CANCELLED_ORDERS_6_MONTHS , to_char(CANCELLED_AMOUNT_6_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , RMA_3_MONTHS , to_char(RMA_AMOUNT_3_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , RMA_6_MONTHS , to_char(RMA_AMOUNT_6_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , LAST_ORDER_DATE , LAST_ORDER_NUMBER , SHIPMENTS_OPEN , SHIPMENTS_LATE , CREDIT_RATING , RISK_CODE , to_char(LATE_PAYMENTS_3_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , to_char(LATE_PAYMENTS_6_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , to_char(AMOUNT_DUE, fnd_currency.safe_get_format_mask(currency_code,30)) , SERVICE_CALLS_3_MONTHS , DATE_OF_LAST_SERVICE_CALL , SITE_ID_LAST_SERVICE_CALL , to_char(SERVICE_AMOUNT_6_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , SERVICE_ORDERS_6_MONTHS , to_char(SERVICE_AMOUNT_12_MONTHS, fnd_currency.safe_get_format_mask(currency_code,30)) , SERVICE_ORDERS_12_MONTHS , LAST_SERVICE_CALL_CONTACT , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 FROM ICX_PANEL_SUMMARY WHERE DATA_AS_OF_DATE = ( SELECT MAX( DATA_AS_OF_DATE ) FROM ICX_PANEL_SUMMARY WHERE NVL( ORG_ID, NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTRB( USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99)) = NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTRB(USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99) ) AND NVL( ORG_ID, NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTRB( USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99)) = NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTRB(USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99)

View Text - HTML Formatted

SELECT CUSTOMER_ID
, DATA_AS_OF_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, SAME_SUPPLY_CHAIN_FLAG
, CURRENCY_CODE
, LAST_ORDER_HEADER_ID
, TO_CHAR(ORDERS_AMOUNT_LAST_WEEK
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_WEEK
, TO_CHAR(ORDERS_AMOUNT_LAST_MONTH
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_MONTH
, TO_CHAR(ORDERS_AMOUNT_LAST_3_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_3_MONTHS
, TO_CHAR(ORDERS_AMOUNT_LAST_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_6_MONTHS
, TO_CHAR(ORDERS_AMOUNT_LAST_12_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, ORDERS_LAST_12_MONTHS
, CANCELLED_ORDERS_3_MONTHS
, TO_CHAR(CANCELLED_AMOUNT_3_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, CANCELLED_ORDERS_6_MONTHS
, TO_CHAR(CANCELLED_AMOUNT_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, RMA_3_MONTHS
, TO_CHAR(RMA_AMOUNT_3_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, RMA_6_MONTHS
, TO_CHAR(RMA_AMOUNT_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, LAST_ORDER_DATE
, LAST_ORDER_NUMBER
, SHIPMENTS_OPEN
, SHIPMENTS_LATE
, CREDIT_RATING
, RISK_CODE
, TO_CHAR(LATE_PAYMENTS_3_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, TO_CHAR(LATE_PAYMENTS_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, TO_CHAR(AMOUNT_DUE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SERVICE_CALLS_3_MONTHS
, DATE_OF_LAST_SERVICE_CALL
, SITE_ID_LAST_SERVICE_CALL
, TO_CHAR(SERVICE_AMOUNT_6_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SERVICE_ORDERS_6_MONTHS
, TO_CHAR(SERVICE_AMOUNT_12_MONTHS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE
, 30))
, SERVICE_ORDERS_12_MONTHS
, LAST_SERVICE_CALL_CONTACT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
FROM ICX_PANEL_SUMMARY
WHERE DATA_AS_OF_DATE = ( SELECT MAX( DATA_AS_OF_DATE )
FROM ICX_PANEL_SUMMARY
WHERE NVL( ORG_ID
, NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)) = NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99) )
AND NVL( ORG_ID
, NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)) = NVL( TO_NUMBER( DECODE( SUBSTRB( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)