Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Back To Back Order Process Flow

    Uploaded by

    Saravanakuamr Chandramohan
    This document outlines the process for creating a back-to-back order in Oracle Applications. It describes creating a sales order, generating a purchase requisition, creating a purchase order from the requisition, receiving the purchase order, and finding the associated purchase requisition number for a given sales order.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Back To Back Order Process Flow

    Uploaded by

    Saravanakuamr Chandramohan
    21 views2 pages
    This document outlines the process for creating a back-to-back order in Oracle Applications. It describes creating a sales order, generating a purchase requisition, creating a purchase order from the requisition, receiving the purchase order, and finding the associated purchase requisition number for a given sales order.

    Original Description:

    Back to Back Order Process Flow

    Original Title

    Back to Back Order Process Flow

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the process for creating a back-to-back order in Oracle Applications. It describes creating a sales order, generating a purchase requisition, creating a purchase order from the requisition, receiving the purchase order, and finding the associated purchase requisition number for a given sales order.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    21 views2 pages

    Back To Back Order Process Flow

    Uploaded by

    Saravanakuamr Chandramohan
    This document outlines the process for creating a back-to-back order in Oracle Applications. It describes creating a sales order, generating a purchase requisition, creating a purchase order from the requisition, receiving the purchase order, and finding the associated purchase requisition number for a given sales order.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Back to Back order

    Setup:

    In Item ATO enabled should be enabled.

    Process

    Create SO book it line status will be Booked right click in line and progress order status
    changed to PO REQ Required

    So got to Purchasing super user run Requisition Import Program.(After running we can see the PR
    created for this SO)

    To get the PR number details for the SO

    OPEN SO toolsscheduling Reservation Details here we can find the PR number.

    SO line will be changed to ‘PO REQ created’ Status after creating the PR for this SO.

    So after PR created Create PO using Auto create option

    SO line will be changed to ‘PO Created’ Status after creating the PO for the PR

    After PO creation approve it and Receive the PO

    After receiving the PO in SO we can see the line status changed to ‘Awaiting shipping’ Status.

    To find the PR number for the Particular Sales order

    SELECT oeha.order_number, oeha.created_by, oela.line_id,


    oela.line_number,
    oeha.header_id,porh.segment1
    FROM po_requisition_headers_all porh,
    oe_order_lines_all oela,
    po_requisition_lines_all porl,
    oe_order_headers_all oeha
    WHERE porh.interface_source_code = 'CTO'
    AND porh.interface_source_line_id IS NOT NULL
    AND oeha.header_id = oela.header_id
    AND porh.requisition_header_id =
    porl.requisition_header_id
    AND porh.interface_source_line_id = oela.line_id
    --AND porl.requisition_line_id = x_req_line_id
    and oeha.order_number=50175344
    GROUP BY oeha.order_number,
    oeha.created_by,
    oela.line_id,
    oela.line_number,
    oeha.header_id,
    porh.segment1

    select * from po_requisition_headers_all where segment1 in('861027','861026')

    You might also like