DBA Data[Home] [Help]

VIEW: APPS.CST_TOTAL_COST_VIEW

Source

View Text - Preformatted

SELECT USERENV('SESSIONID') , CIC.INVENTORY_ITEM_ID , CIC.ORGANIZATION_ID , CIC.COST_TYPE_ID , NULL , NULL , NULL , NULL , NULL , CIC.ITEM_COST , NULL , CIC.TL_ITEM_COST , CIC.PL_ITEM_COST , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL FROM CST_ITEM_COSTS CIC
View Text - HTML Formatted

SELECT USERENV('SESSIONID')
, CIC.INVENTORY_ITEM_ID
, CIC.ORGANIZATION_ID
, CIC.COST_TYPE_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, CIC.ITEM_COST
, NULL
, CIC.TL_ITEM_COST
, CIC.PL_ITEM_COST
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM CST_ITEM_COSTS CIC