You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Raw Material Consumption For Production Query.

edited Jul 17, 2020 6:02AM in Manufacturing 6 comments

Content

Hi,

We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop

it in Oracle Fusion. We face difficulty in finding tables and fields.

Please find the below query which is not fetching the NEW_COST column. The NEW_COST from table INV_MATERIAL_TXNS has no rows.

select c.subinventory_code, substr(a.FLEX_VALUE_SET_NAME,4,36) SET_NAME, b.flex_value ITEM_CODE, c.transaction_type_id TRANS_ID, c.organization_id ORG_ID, c.inventory_item_id ITEM_ID, f.description ITEM_DES, trunc(c.transaction_date) TRANS_DT, d.transaction_type_name TRANS_TYPE, sum(round(abs(nvl(c.primary_quantity,0)),2)) TRANS_QTY, sum(round((abs(nvl(c.primary_quantity,0))*nvl(c.NEW_COST,0)),2)) TRANS_VALUE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!