DBA Data[Home] [Help]

VIEW: APPS.CSTFV_ITEM_STD_COST_UPDATES

Source

View Text - Preformatted

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
View Text - HTML Formatted

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