Cost Management - EBS (MOSC)

MOSC Banner

how can I add resource cost to a item view CST_ITEM_CST_DTLS_INTERFACE? what resource id can I use

edited Aug 12, 2011 4:39AM in Cost Management - EBS (MOSC) 2 commentsAnswered
INSERT INTO CST_ITEM_CST_DTLS_INTERFACE (inventory_item_id,organization_id,Usage_rate_or_amount,cost_element_id,cost_type_id, basis_type, level_type,

resource_id, resource_rate, rollup_source_type,

process_flag , based_on_rollup_flag, shrinkage_rate,lot_size)--,inventory_asset_flag)

SELECT agl.inventory_item_id,organization_id, agl.TL_RESOURCE usage_rate_or_amount,3 cost_element_id,1026 cost_type_id,1 basis_type, 1 level_type,1 resource_id, 1 resource_rate, 1 rollup_source_type, 1 process_flag, --decode(agl.item_type,'P',2,1) based_on_rollup_flag,1 based_on_rollup_flag,0 shrinkage_rate,1 lot_size--,1FROM bolinf

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center