We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

get lot number query

Accepted answer
18
Views
1
Comments
edited Nov 18, 2020 1:25PM in Reporting and Analytics for SCM 1 comment

Content

i created this query

select RSL.ITEM_ID,
       RSL.ITEM_DESCRIPTION,
       rct.ORGANIZATION_ID,
       RHI.SHIPMENT_NUM,
       rsh.receipt_num,
       rct.transaction_date receipt_date
  from RCV_HEADERS_INTERFACE RHI,
       PO_HEADERS_ALL        PHA,
       hr_organization_units hou,
       RCV_SHIPMENT_HEADERS  RSH,
       RCV_SHIPMENT_LINES    RSL,
       rcv_transactions      rct,
       INV_ORG_PARAMETERS    iop
 where rct.ORGANIZATION_ID = hou.ORGANIZATION_ID
   and RSL.PO_HEADER_ID = PHA.PO_HEADER_ID
   AND RSH.ASN_TYPE = 'ASBN'
   AND RHI.HEADER_INTERFACE_ID = RSH.HEADER_INTERFACE_ID
   AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
   and rct.shipment_line_id = rsl.shipment_line_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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