0 Replies Latest reply on Feb 23, 2009 7:08 PM by 686896

    wharehouse recieving report

    686896
      SELECT
      RSH.RECEIPT_NUM RECEIPT_NUM,
      RT.TRANSACTION_DATE TRX_DATE,
      POH.SEGMENT1 PO_NUM,
      POH.CREATION_DATE PO_DATE,
      POV.VENDOR_NAME VENDOR_NAME,
      RSH.VENDOR_ID,
      MTL.INVENTORY_ITEM_ID ITEM_ID,
      MTL.SEGMENT1||'.'||MTL.SEGMENT2 I| '.'|MTL.SEGMENT3||'.'||MTL.SEGMENT4 ITEM_CODE,
      RSL.ITEM_DESC ITM_DESC,
      RSL.TRANSACT_UOM UOM,
      POL.QUANTITY PO_QTY,
      POL.UNIT_PRICE RATE,(POL.UNIT_PRICE*POL.QUANTITY) TOTAL,
      OOD.ORGANIZATION_CODE||' '||OOD.ORGANIZATION_NAME


      FROM


      RCV_SHIPMENT_HEADERS RSH,
      RCV_TRANSACTIONS RT,
      PO_HEADERS_ALL POH,
      PO_VENDORS POV,
      PO_LINES_ALL POL,
      RCV_SHIPMENT_LINES RSL,
      ORG_ORGANIZATION_DEFINITIONS OOD,
      MTL_SYSTEM_ITEMS_B ITM


      WHERE

      RSH.ORGANIZATION_ID = ITM.ORGANIZATION_ID
      AND POH.PO_HEADER_ID = RSL.PO_HEADER_ID
      AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
      AND POL.PO_LINE_ID = RSL.PO_LINE_ID
      AND RSL.ITEM_ID = MTL.INVENTORY_ITEM_ID



      ORDER BY
      TRX_DATE desc,
      RECEIPT_NUM




      FOR LOCN ORG_ID||ORGANIZATION NAME


      L340 IS ORG_ID
      ORGANIZATIONNAME


      THE LAST COMBINATION AND RSL.ITEM_ID = MTL.INVENTORY_ITEM_ID IS CORRECT OR NOT?


      can any body correct my query

      Edited by: user5444744 on Feb 23, 2009 11:06 AM