Enterprise Asset Management - EBS (MOSC)

MOSC Banner

link between tables inv.mtl_serial_numbers and inv.MTL_ITEM_LOCATIONS for a given serial number

edited May 30, 2012 9:50PM in Enterprise Asset Management - EBS (MOSC) 5 comments
Hi,

Can anyone tell me the link between tables inv.mtl_serial_numbers and inv.MTL_ITEM_LOCATIONS for a given  serial number.
I want to extract segment1 from  inv.MTL_ITEM_LOCATIONS for a particular serial number which is in inv.mtl_serial_numbers table.

Regards,

Gaurav Joshi.

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 EAM 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