View: CSTFV_ITEM_STD_COST_UPDATES

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTFV_ITEM_STD_COST_UPDATES

View Text

SELECT CO.COST_UPDATE_ID
, CO.ORGANIZATION_ID
, CO.UPDATE_DATE
, CO.COST_TYPE_ID
, CO.SINGLE_ITEM
, CO.CATEGORY_ID
, CO.CATEGORY_SET_ID
, CO.INV_ADJUSTMENT_ACCOUNT
, /* REGULAR ATTRIBUTES */ '_LA:CO.STATUS:MFG_LOOKUPS:CST_COST_UPDATE_STATUS:MEANING'
, CO.DESCRIPTION
, '_LA:CO.RANGE_OPTION:MFG_LOOKUPS:CST_ITEM_RANGE:MEANING'
, '_LA:CO.UPDATE_RESOURCE_OVHD_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.UPDATE_ACTIVITY_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.SNAPSHOT_SAVED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, CO.ITEM_RANGE_LOW
, CO.ITEM_RANGE_HIGH
, CO.INVENTORY_ADJUSTMENT_VALUE
, CO.INTRANSIT_ADJUSTMENT_VALUE
, CO.WIP_ADJUSTMENT_VALUE
, CO.SCRAP_ADJUSTMENT_VALUE
, /* RESOLVED FOREIGN KEY RESOLUTIONS */ PA.ORGANIZATION_CODE
, HAOU.NAME
, CCT.COST_TYPE
, '_KF:INV:MSTK:MSI'
, '_KF:INV:MCAT:MC'
, MCS.CATEGORY_SET_NAME
, '_KF:SQLGL:GL#:GCC'
, /* ID */ /* WHO */ CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS MSI
, MTL_CATEGORY_SETS MCS
, MTL_CATEGORIES MC
, GL_CODE_COMBINATIONS GCC
, CST_COST_TYPES CCT
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS PA
, CST_COST_UPDATES CO
WHERE CO.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND CO.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND CO.COST_TYPE_ID = CCT.COST_TYPE_ID
AND CO.INV_ADJUSTMENT_ACCOUNT = GCC.CODE_COMBINATION_ID(+)
AND CO.CATEGORY_ID = MC.CATEGORY_ID(+)
AND CO.CATEGORY_SET_ID = MCS.CATEGORY_SET_ID(+)
AND CO.SINGLE_ITEM = MSI.INVENTORY_ITEM_ID(+)
AND CO.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND '_SEC:CO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns