[Home] [Help]
View: ICX_CST_MARGIN_DETAIL_V
View Text
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)
Columns
Name |
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 |