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

Sql Query for lot number in Purchase Order Lines for Receiving

Accepted answer
1058
Views
8
Comments

Summary:

To fetch the supplier item /lot from  Purchase Order Lines

Content (required):

We have a requirement to fetch the lot number/supplier item from the Purchase Order Lines for that we have checked in the INV_TRANSACTION_LOT_NUMBERS table but, there are multiple lot number for single item and organization

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT

   *

FROM

   inv_transaction_lot_numbers

WHERE

       inventory_item_id = 100000009861303

   AND organization_id = 300000006687171

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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