Oracle Apps Purchase Requisition - technical


Responsibility: Purchasing, Vision Operations (USA) -> Requisitions -> Requisitions


Key Tables:
       po_requisition_headers
       po_requisition_lines
       po_req_distributions


Main DFFs:
       Requisition Headers
       Requisition Lines
       Requisition Distributions
       Requisition Project Information

po_requisition_headers_all: stores information about requisition headers

Few Main Columns:

       Requisition_header_id : Unique system generated Id for requisition headers
       Segment1: Stores the requisition #
       Type_lookup_code: purchase/internal based on the type of requisition
       Authorization_status: approved/incomplete etc. based on the status of requisition
       wf_item_type = Stores the approval workflow corresponding to the requisition. For e.g. REQAPPRV
       wf_item_key =  <workflow item key>

po_requisition_lines_all: stores information about requisition lines

Few Main Columns:

       Requisition_line_id : Unique system generated Id for requisition lines
       Requisition_header_id :  Foreign key from the po_requisition_teaders table
       Line_num: Stores the requisition line #
       Item_id: Store item id linking to inventory_item_id from mtl_system_items_b table
       Line_location_id: purchase order shipment line identifier. Foreign key from po_line_locations table. This column will be null if PO is still not created for this Requisition.
       Blanket_po_header_id: Stores suggested blanket  purchase agreement detail
       Blanket_po_line_num: Stores suggested blanket  purchase agreement detail

po_req_distributions: stores information about the accounting distributions associated with each requisition line

Few Main Columns:

       Distribution_id : Unique system generated Id for requisition distributions
       Requisition_line_id : Foreign key from the po_requisition_lines table
       Code_combination_id: Distribution charge account id
       Accrual_account_id: Distribution accrual account id
       Variance_account_id: Distribution variance account id

Requisitions related workflows:
       Approval workflow:  PO Requisition Approval, Process: Main Requisition Approval
       Account generator workflow: PO Requisition Account Generator, Process: Generate Default Account