Inventory Management - EBS (MOSC)

MOSC Banner

Put Rule for Move Any LPN

edited May 8, 2016 5:03AM in Inventory Management - EBS (MOSC) 3 commentsAnswered

Hi Kumar,

Can any one suggest on this. Need a SQL query to populate the Receiving Quantity into the Storage when Move Any LPN.

Ex:

Sub INV1: Locator: Capacity: 50

Sub INV2: Locator: No Capacity Constraint

1 PACK = 20 Each (Supplier capacity)

Open PO Quantity: 1000

At present we are receiving 75 Quantity into Receiving Area.

The output should be, when we are doing the Move Any LPN Transactions;

1. 35 Qty into Sub INV1: Locator  (1 PACK+15 Loose)

2. 40 Qty into Sub INV2 (2 PACK)

Requesting for Custom Expression to achieve above requirement. If the requirement is not clear, please give a call on +91 9502064578.

Regards,

Sudheer Galla

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