Inventory Management - EBS (MOSC)

MOSC Banner

Ship-to Location LOV on Move Orders

edited May 24, 2011 7:34AM in Inventory Management - EBS (MOSC) 4 commentsAnswered
 Hi All,

I created a move order and selected a ship-to location on line level (tab destination).

Then, I tried to select this ship-to location from HR_LOCATIONS_ALL. But it is not there. The ship_to_location_id stored in MTL_TXN_REQUEST_LINES_ALL does not exist in HR_LOCATIONS_ALL nor in HR_LOCATIONS.

But this location is available in the LOV of move order form.

The LOV on the location field contains more entries than I can find locations on the locations setup form.

Can anybody tell me where this information does come from if not from HR_LOCATIONS_ALL? There must exist another table which stores location information. And where (which form) has it been setup?

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