VIEW: APPS.CSTBV_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 , /* ID */ /* WHO */ CO.CREATION_DATE , CO.CREATED_BY , CO.LAST_UPDATE_DATE , CO.LAST_UPDATED_BY FROM 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 '_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
, /* ID */ /* WHO */ CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
FROM 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 '_SEC:CO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY