VIEW: APPS.CSTFV_STANDARD_ITEM_COST

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ CIC.ORGANIZATION_ID , CIC.INVENTORY_ITEM_ID , CIC.COST_TYPE_ID /* REGULAR ATTRIBUTES */ , CIC.ITEM_COST , CIC.MATERIAL_COST , CIC.MATERIAL_OVERHEAD_COST , CIC.OVERHEAD_COST , CIC.RESOURCE_COST , CIC.OUTSIDE_PROCESSING_COST , ML1.MEANING , CIC.LOT_SIZE , ML2.MEANING , CIC.SHRINKAGE_RATE , ML3.MEANING /* FOREIGN KEYS RESOLVED */ , MP.ORGANIZATION_CODE , HR.NAME , '_KF:INV:MSTK:sy' , CT.COST_TYPE , '_DF:BOM:CST_ITEM_COSTS:cic' /* IDS */ /* WHO */ , CIC.CREATION_DATE , CIC.CREATED_BY , CIC.LAST_UPDATE_DATE , CIC.LAST_UPDATED_BY FROM HR_ALL_ORGANIZATION_UNITS HR ,MTL_PARAMETERS MP ,MTL_SYSTEM_ITEMS SY ,MFG_LOOKUPS ML1 ,MFG_LOOKUPS ML2 ,MFG_LOOKUPS ML3 ,CST_ITEM_COSTS CIC ,CST_COST_TYPES CT WHERE CIC.ORGANIZATION_ID = HR.ORGANIZATION_ID AND CIC.ORGANIZATION_ID = MP.ORGANIZATION_ID AND CIC.COST_TYPE_ID = CT.COST_TYPE_ID AND SY.ORGANIZATION_ID = CIC.ORGANIZATION_ID AND SY.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID AND ML1.LOOKUP_TYPE = 'SYS_YES_NO' AND ML1.LOOKUP_CODE = CIC.INVENTORY_ASSET_FLAG AND ML2.LOOKUP_TYPE = 'SYS_YES_NO' AND ML2.LOOKUP_CODE = CIC.BASED_ON_ROLLUP_FLAG AND ML3.LOOKUP_TYPE = 'SYS_YES_NO' AND ML3.LOOKUP_CODE = CIC.DEFAULTED_FLAG AND '_SEC:cic.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ CIC.ORGANIZATION_ID
, CIC.INVENTORY_ITEM_ID
, CIC.COST_TYPE_ID /* REGULAR ATTRIBUTES */
, CIC.ITEM_COST
, CIC.MATERIAL_COST
, CIC.MATERIAL_OVERHEAD_COST
, CIC.OVERHEAD_COST
, CIC.RESOURCE_COST
, CIC.OUTSIDE_PROCESSING_COST
, ML1.MEANING
, CIC.LOT_SIZE
, ML2.MEANING
, CIC.SHRINKAGE_RATE
, ML3.MEANING /* FOREIGN KEYS RESOLVED */
, MP.ORGANIZATION_CODE
, HR.NAME
, '_KF:INV:MSTK:SY'
, CT.COST_TYPE
, '_DF:BOM:CST_ITEM_COSTS:CIC' /* IDS */ /* WHO */
, CIC.CREATION_DATE
, CIC.CREATED_BY
, CIC.LAST_UPDATE_DATE
, CIC.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS SY
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, CST_ITEM_COSTS CIC
, CST_COST_TYPES CT
WHERE CIC.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND CIC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CIC.COST_TYPE_ID = CT.COST_TYPE_ID
AND SY.ORGANIZATION_ID = CIC.ORGANIZATION_ID
AND SY.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
AND ML1.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML1.LOOKUP_CODE = CIC.INVENTORY_ASSET_FLAG
AND ML2.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML2.LOOKUP_CODE = CIC.BASED_ON_ROLLUP_FLAG
AND ML3.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML3.LOOKUP_CODE = CIC.DEFAULTED_FLAG
AND '_SEC:CIC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY