realtime reports and interfaces

APPROVED PO REQUISITION REPORT (PO) or Purchase Requisition Approval Status and PO Approval Status Report:
PURPOSE:THIS REPORT SHOWS THE INFORMATION ABOUT APPROVED PURCHASE REQUISITIONS. THE REPORT CONTAINS BOTH INTERNAL AND PURCHASE REQUISITIONS WHICH ARE APPROVED BY THE AUTHORITIES.

SELECT PRH.SEGMENT1 REQ_NUMBER,
PRH.CREATION_DATE REQ_DATE,
PRH.AUTHORIZATION_STATUS REQ_STATUS,
PH.SEGMENT1 PO_NUMBER,
PH.CREATION_DATE PO_DATE,
PH.AUTHORIZATION_STATUS PO_STATUS
FROM PO_REQUISITION_HEADERS_ALL PRH,
PO_REQUISITION_LINES_ALL PRL,
PO_REQ_DISTRIBUTIONS_ALL PRD,
PO_HEADERS_ALL PH,
PO_LINES_ALL PL,
PO_LINE_LOCATIONS_ALL PLL,
PO_DISTRIBUTIONS_ALL PDA
WHERE PRH.REQUISITION_HEADER_ID=PRL.REQUISITION_HEADER_I D
AND PRL.REQUISITION_LINE_ID=PRD.REQUISITION_LINE_ID
AND PH.PO_HEADER_ID=PL.PO_HEADER_ID
AND PL.PO_LINE_ID=PLL.PO_LINE_ID
AND PLL.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND PDA.PO_HEADER_ID=PH.PO_HEADER_ID
AND PDA.REQ_DISTRIBUTION_ID=PRD.DISTRIBUTION_ID
AND PRH.SEGMENT1='5632'


Purchase Requisition Status Report
The Purchase Requisition Status Report can be used to review the approval status of the requisitions you create. By limiting the approval status, you can use the report as a tool to plan and monitor the buyer workload. You can also use the report to monitor requisitions in the approval process or returned and requiring further attention.

The report can include requisitions with the following statuses:

Approved     An approver with sufficient authority approved the requisition. A buyer can now place the corresponding requisition lines onto purchase orders.
Cancelled     A requisition preparer cancelled the requisition.
In Process     The preparer completed the requisition and submitted to the approval process. However, no one with sufficient authority has approved the requisition.
Incomplete     The requisition is incomplete and the preparer has not yet submitted the requisition to an approver.
Pre-Approved     At least one person with sufficient authority approved the requisition. The status is not Approved either because the approver forwarded the requisition to someone else, or the approver has not yet reserved the funds.
Rejected     The approver rejected the requisition. Purchasing returns the entire requisition to the preparer.
Returned     A buyer returned the requisition. Purchasing returns to the preparer all requisition lines within the same requisition that are not on a purchase order.
Report Submission
In the Submit Requests window, select Purchase Requisition Status Report in the Name field.

Report Parameters
Requisition Numbers From/To
Enter the beginning and ending requisition numbers.

Creation Dates From/To
Enter the beginning and ending creation dates.

Requestor
Enter a requestor name to restrict the report to a specific requestor.

Location
Enter a deliver to location to restrict the report to a specific location.

Dynamic Precision Option
Enter the decimal precision for quantities on the report.

BACK ORDER REPORT (OM)
PURPOSE: THIS REPORT SHOWS THE INFORMATION ABOUT THE BACK ORDERS
BACK ORDER MEANS:
1)WHEN ORDER QUANTITY IS GRATER THAN THE ON HAND QUANTITY.
2)MISMATCHING OF WARE HOUSE SHIP TO LOCATION TO THE SALES ORDER HEADERS SHIP TO LOCATION.

SUPPLIER WISE APPROVED REPORT (PO)
PURPOSE:THIS REPORT SHOWS THE SUPPLIER WISE APPROVED PURCHASE ORDERS. THIS PURCHASE ORDER MAY BE STANDARD/BLANKET/CONTRACT/PLANNED ONE AND SHOWS THE SUPPLIER DETAILS ALSO.

DIMS TO ORACLE ONHAND QUANTITY REPORT (PO)
PURPOSE:THIS REPORT SHOWS THE INFORMATION ABOUT THE ONHAND QUANTITIES OF INVENTORY ITEMS WHICH ARE SENT BY DIMS. DIMS MEANS OTHER LEGACY SYSTEM (AS 400). THIS QUERY IS TO GENERATE THE DATA OF MT TO ORACLE ONHAND RAW MATERIAL INFORMATION.

SHIPPING EXTRACT REPORT (OM)
PURPOSE:THIS REPORT SHOWS THE SHIPPING INFORAMTION OF INVENTORY ITEMS AND WITH THE PARTY DETAILS ANS ITEM DETAILS.

AR RECEIPT INFORMATION REPORT(AR)
PURPOSE:THIS REPORT SHOWS THE INFORMATION OF RECEIPTS WHICH ARE GENERATE AFTER RECEIVABLES FROM THE CUSTOMERS.

SALES ORDER REPORT REPORT AND OUTBOUND(OM)IS
PURPOSE: THIS WILL PROVIDE THE FEATURES NEEDED TO SATISFY THE BASIC BUSSINESS NEED OF REVIEWING THE AVAILABLE INVENTORY OF ITEMS ON ORDER.

CUSTOMIZATION OF INVOICE PRICE VARIANCE REPORT:
PURPOSE:THIS IS THE STANDARD REPORT IN PO WHICH GIVES THE INFORMATION ABOUT THE INVOICE PRICE VARIANCE.PRICE VARIANCE MEANS VARIANCE IN THE ITEM COT IT IS DEPENDING ON THE MARKET CONDITIONS AND LOCAL SUPPLIER PARTIES N ETC.

CUSTOMIZATION OF OVER SHIPMENT REPORTS IN PO:
PURPOSE:THIS THE STANDARD REPORT IN PO WHICH GIVES THE INFORMATION ABOUT THE OVER SHIPMENT QUANTITY IN THE  ORGANIZATION.IT DISPLAYS THE DETAILS OF OVER SHIPMENT RECEIPT INFORMATION AND REASON OF OVER SHIPMENTS VENDOR DETAILS AND QUANTITY INFORMATION.

PO REQUISITION INTERFACE:
FIELDS
    INTEFACE_SOURCE_CODE
    AUTHORIZATION_STATUS
    QUANTITY
    DESTINATION_ORGANIZATION_NAME
    DELIVER_TO_REQUESTOR_ID
    REQUISITION_TYPE
    UNIT_OF_MEASURE
    SUGGESTED_VENDOR_NAME
    NEED_BY_DATE
    DESTINATION_TYPE_CODE
    PREPARER_ID
    CHARGE_ACCOUNT_ID
    DELIVER_TO_LOCATION_NAME
    SOURCE_TYPE_CODE
    ITEM_NAME
    DOCUMENT_TYPE_CODE
    BATCH_ID

VALIDATIONS
    VALIDATE COLUMN        REF COLUMN        JOIN        BASE TABLE
    SUGGESTED VENDOR NAME   VENDOR NAME        VENDOR ID    AP_SUPPLIERS(PO_VENDORS )
    DESTINATION ORG NAME    NAME            ORG ID        HR_OPERATING_UNITS
    DELIVER TO LOCATION NAME SEGMENT1        INVENTORY ITEM ID    MTL_SYSTEM_ITEMS_B

INTERFACE TABLE:
        PO_REQUISITIONS_INTERFACE_ALL
        PO_REQ_DIST_INTERFACE_ALL

ERROR TABLE:
        PO_INTERFACE_ERRORS

STANDARD PROGRAM:
            REQUISITION IMPORT: REQUISITION IMPORT IS A CONCURRENT PROGRAM (POCIRM) WHICH IS USED TO PROCESS DATA FROM ORACLE APPLICATIONS(MRP,WIO,OE,& INV) INTO REQUISITIONS IN ORACLE PURCHASING. DATA IS FIRST LOADED INTO THE PO_REQUISISTIONS_INTERFACE_ALL TABLE. THE REQUISITION IMPORT PROGRAM CAN THEN BE RUN TO CREATE REQUISITIONS AWATING FLOW INTO THE PRCUREMENT PROCESS.

PARAMETERS:
        INTERFACE_SOURCE_CODE
        BATCH_ID
        GROUP_BY    -        MANDATORY
        LAST_REQUISITION_NUMBER-
        MULTI_DISTRIBUTIONS    -    MANDATORY
        INITIATE_REQAPPR_AFTER_REQIMP - MANDATORY

AP OPEN INVOICE INBOUND INTERFACE:
FIELDS:
    INVOICE_ID
    VENDOR_NAME
    INVOICE_AMOUNT
    EXCHANGE_RATE_TYPE
    SOURCE
    ORG_ID
    CREATED_BY
    LAST_UPDATED_BY
    INVOICE_NUM
    VENDOR_SITE_CODE
    INVOICE_NUM
    VENDOR_SITE_CODE
    INVOICE_CURRENCY_CODE
    TERMS_NAME
    PAYMENT_METHOD_LOOKUP_CODE
    CREATION_DATE
    LAST_UPDATED_DATE
    LAST_UPDATED_LOGIN
LINE LEVEL FIELDS:
    INVOICE_LINE_ID
    LINE_NUM
    LINE_TYPE_LOOKUP_CODE
    AMOUNT
    ACCOUNTING_DATE
    DIST_CODE_COMBINATION_ID

VALIDATIONS:
   
    VALIDATE COLUMN    :    REF COLUMN :        JOIN :            BASE TABLE :
    VENDOR NAME        VENDOR NAME        VENDOR NAME         AP_SUPPLIERS(PO_VENDORS)
    VENDOR ID        VENDOR ID        VENDOR ID        AP_SUPPLIERS
    ORG_ID            ORGANIZATION_ID        ORG_CODE        ORG_ORGANIZATION_DEFINITIONS
    VENDOR_SITE_ID        VENDOR_SITE_ID        VENDOR_SITE_ID        AP_SUPPLIER_SITES_ALL(PO_VENDOR_SITES_ALL)
    CURRENCY        CURRENCY_CODE        CURRENCY_CODE        FND_CURRENCIES
    INVOICE NUMBER        INVOICE_NUMBER        INVOICE_NUMBER        AP_INVOICE_ALL
    LINE NUMBER        LINE NUMBER        LINE NUMBER & INVOICE_ID AP_INVOICE_LINE_STAGE
    LINE_TYPE         LINE_TYPE               LOOK_UP_CODE        PO_LOOKUP_CODES   
    DIST CODE COMBINATION    LEDGER ID(SET OF BOOK ID) CHART OF ACCOUNT ID   ORG_ORGANIZATION_DEFINITIONS & GL_CODE_COMBINATIONS       
                                                         & CODE COMBINATION ID

INTERFACE TABLES
       
        AP_INVOICE_INTERFACE
        AP_INVOICE_LINES_INTERFACE

STANDARD PROGRAM
        PAYABLES OPEN INTERFACE IMPORT

PARAMETERS:
       
    SOURCE    -    MANDATORY
    GROUP
    LD REASON
    BATCH
    GL DATE
    HOLD NAME
    PURGE
    SUMMARIZE REPORT