1 Reply Latest reply on Feb 8, 2016 10:14 PM by Reddy007

    Internal Requisition technical flow?

    Reddy007

      Hello everyone,

      Is there any  query to get all internal requisition which receipts not yet creared...??..
      Please share me technical flow involved in internal requisition ..
      Thanq

        • 1. Re: Internal Requisition technical flow?
          Reddy007

          Hi, I have used below query to obtain receipts to create for internal requisitions but still missing something else..

           

          SELECT prh.segment1 "Req Num"

            FROM po_requisition_headers_all prh,

                 po_requisition_lines_all prl,

                 po_req_distributions_all prd,

                 per_people_x ppx,

                 po_headers_all poh,

                 po_distributions_all pda,

                 mtl_system_items_b msi,

                 mtl_supply ms,

                 RCV_SHIPMENT_HEADERS rsh,

                 RCV_SHIPMENT_LINES rsl

          WHERE prh.requisition_header_id = prl.requisition_header_id

             AND ppx.person_id = prh.preparer_id

             AND prh.type_lookup_code = 'INTERNAL'

             AND prd.requisition_line_id = prl.requisition_line_id

             AND pda.req_distribution_id = prd.distribution_id

             AND pda.po_header_id = poh.po_header_id

             and msi.inventory_item_id=prl.item_id

             and prl.org_id=msi.organization_id

             and ms.REQ_HEADER_ID=prh.REQUISITION_HEADER_ID

             and ms.SUPPLY_TYPE_CODE='SHIPMENT'

             and rsh.SHIPMENT_HEADER_ID=rsl.SHIPMENT_HEADER_ID