VIEW: APPS.ICX_CST_MARGIN_DETAIL_V

Source

View Text - Preformatted

SELECT BUILD_ID , CUSTOMER_ID , PRIMARY_SALESREP_ID , TERRITORY_ID , INVENTORY_ITEM_ID , PERIOD , PARENT_INVENTORY_ITEM_ID , ORG_ID , SOLD_TO_CUSTOMER_NAME , INVOICED_AMOUNT , COGS_AMOUNT , MARGIN FROM ICX_MARGIN_ANALYSIS 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)

View Text - HTML Formatted

SELECT BUILD_ID
, CUSTOMER_ID
, PRIMARY_SALESREP_ID
, TERRITORY_ID
, INVENTORY_ITEM_ID
, PERIOD
, PARENT_INVENTORY_ITEM_ID
, ORG_ID
, SOLD_TO_CUSTOMER_NAME
, INVOICED_AMOUNT
, COGS_AMOUNT
, MARGIN
FROM ICX_MARGIN_ANALYSIS
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)