VIEW: APPS.CSTFV_ITEM_UNIT_COST_DETAILS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ ICD.ORGANIZATION_ID , ICD.INVENTORY_ITEM_ID , ICD.COST_TYPE_ID /* REGULAR ATTRIBUTES */ , ICD.ITEM_UNITS , ICD.ACTIVITY_UNITS , ICD.USAGE_RATE_OR_AMOUNT , '_LA:icd.basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , ICD.ITEM_COST , '_LA:icd.level_type:MFG_LOOKUPS:CST_LEVEL:MEANING' /* FOREIGN KEYS RESOLVED*/ , MP.ORGANIZATION_CODE , HR.NAME , '_KF:INV:MSTK:sy' , CT.COST_TYPE , CE.COST_ELEMENT , BD.DEPARTMENT_CODE , CAC.ACTIVITY , BR1.RESOURCE_CODE , BR2.RESOURCE_CODE , OS.OPERATION_DESCRIPTION , '_DF:BOM:CST_AI_DF:icd' /* IDS */ , ICD.COST_ELEMENT_ID , ICD.DEPARTMENT_ID , ICD.ACTIVITY_ID , ICD.RESOURCE_ID , ICD.BASIS_RESOURCE_ID , ICD.OPERATION_SEQUENCE_ID /* WHO */ , ICD.CREATION_DATE , ICD.CREATED_BY , ICD.LAST_UPDATE_DATE , ICD.LAST_UPDATED_BY FROM HR_ALL_ORGANIZATION_UNITS HR ,MTL_PARAMETERS MP ,MTL_SYSTEM_ITEMS SY ,CST_COST_TYPES CT ,CST_COST_ELEMENTS CE ,BOM_DEPARTMENTS BD ,CST_ACTIVITIES CAC ,BOM_RESOURCES BR1 ,BOM_RESOURCES BR2 ,BOM_OPERATION_SEQUENCES OS ,CST_ITEM_COST_DETAILS ICD WHERE ICD.ORGANIZATION_ID = HR.ORGANIZATION_ID AND ICD.ORGANIZATION_ID = MP.ORGANIZATION_ID AND SY.ORGANIZATION_ID = ICD.ORGANIZATION_ID AND SY.INVENTORY_ITEM_ID = ICD.INVENTORY_ITEM_ID AND ICD.COST_TYPE_ID = CT.COST_TYPE_ID AND ICD.COST_ELEMENT_ID = CE.COST_ELEMENT_ID(+) AND ICD.DEPARTMENT_ID = BD.DEPARTMENT_ID(+) AND ICD.ACTIVITY_ID = CAC.ACTIVITY_ID (+) AND ICD.RESOURCE_ID = BR1.RESOURCE_ID(+) AND ICD.BASIS_RESOURCE_ID = BR2.RESOURCE_ID(+) AND ICD.OPERATION_SEQUENCE_ID = OS.OPERATION_SEQUENCE_ID(+) AND '_SEC:icd.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ ICD.ORGANIZATION_ID
, ICD.INVENTORY_ITEM_ID
, ICD.COST_TYPE_ID /* REGULAR ATTRIBUTES */
, ICD.ITEM_UNITS
, ICD.ACTIVITY_UNITS
, ICD.USAGE_RATE_OR_AMOUNT
, '_LA:ICD.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, ICD.ITEM_COST
, '_LA:ICD.LEVEL_TYPE:MFG_LOOKUPS:CST_LEVEL:MEANING' /* FOREIGN KEYS RESOLVED*/
, MP.ORGANIZATION_CODE
, HR.NAME
, '_KF:INV:MSTK:SY'
, CT.COST_TYPE
, CE.COST_ELEMENT
, BD.DEPARTMENT_CODE
, CAC.ACTIVITY
, BR1.RESOURCE_CODE
, BR2.RESOURCE_CODE
, OS.OPERATION_DESCRIPTION
, '_DF:BOM:CST_AI_DF:ICD' /* IDS */
, ICD.COST_ELEMENT_ID
, ICD.DEPARTMENT_ID
, ICD.ACTIVITY_ID
, ICD.RESOURCE_ID
, ICD.BASIS_RESOURCE_ID
, ICD.OPERATION_SEQUENCE_ID /* WHO */
, ICD.CREATION_DATE
, ICD.CREATED_BY
, ICD.LAST_UPDATE_DATE
, ICD.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS SY
, CST_COST_TYPES CT
, CST_COST_ELEMENTS CE
, BOM_DEPARTMENTS BD
, CST_ACTIVITIES CAC
, BOM_RESOURCES BR1
, BOM_RESOURCES BR2
, BOM_OPERATION_SEQUENCES OS
, CST_ITEM_COST_DETAILS ICD
WHERE ICD.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND ICD.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND SY.ORGANIZATION_ID = ICD.ORGANIZATION_ID
AND SY.INVENTORY_ITEM_ID = ICD.INVENTORY_ITEM_ID
AND ICD.COST_TYPE_ID = CT.COST_TYPE_ID
AND ICD.COST_ELEMENT_ID = CE.COST_ELEMENT_ID(+)
AND ICD.DEPARTMENT_ID = BD.DEPARTMENT_ID(+)
AND ICD.ACTIVITY_ID = CAC.ACTIVITY_ID (+)
AND ICD.RESOURCE_ID = BR1.RESOURCE_ID(+)
AND ICD.BASIS_RESOURCE_ID = BR2.RESOURCE_ID(+)
AND ICD.OPERATION_SEQUENCE_ID = OS.OPERATION_SEQUENCE_ID(+)
AND '_SEC:ICD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY