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
