Inventory Management - EBS (MOSC)

MOSC Banner

Can I join mtl_material_transactions.rcv_transaction_id = rcv_transactions.TRANSACTION_ID ?

edited Nov 14, 2014 10:02AM in Inventory Management - EBS (MOSC) 3 commentsAnswered

Dear Guru,

            Can I bypass table RCV_SHIPMENT_LINES and join MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID directly to RCV_TRANSACTIONS.TRANSACTION_ID ?

Because it accesses FULL SCAN on RCV_SHIPMENT_LINES and takes forever to finish. Could you please advise me. Thank you in advance for your commnets.

SELECT   MMT.INVENTORY_ITEM_ID INV_ITEM_ID,

                   MMT.ORGANIZATION_ID INV_ORG_ID,

                   RT.PRIMARY_QUANTITY INTRANSIT_QUANTITY,

                   RT.PRIMARY_QUANTITY * NVL (MMT.ACTUAL_COST, MMT.NEW_COST)

                      INTRANSIT_VALUE

            FROM   RCV_TRANSACTIONS RT,

                   --RCV_SHIPMENT_LINES RSL,

                   MTL_MATERIAL_TRANSACTIONS MMT

           WHERE       --MMT.TRANSACTION_ID = RSL.MMT_TRANSACTION_ID

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

EBS Inventory Mgmt Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center