Search Results po_requisition_headers_all




Here's a detailed description of the PO_REQUISITION_HEADERS_ALL table in Oracle E-Business Suite (EBS):

Table Name: PO_REQUISITION_HEADERS_ALL

Purpose:
- Stores header-level information for purchase requisitions
- Part of the Oracle Purchasing module
- Tracks key details about requisition requests across multiple organizations

Key Columns:
1. REQUISITION_HEADER_ID (Primary Key)
- Unique identifier for each requisition header
- System-generated sequential number

2. SEGMENT1
- Requisition number
- Unique identifier visible to users

3. ORG_ID
- Operating unit identifier
- Supports multi-organization functionality

4. PREPARER_ID
- User who created the requisition
- Links to FND_USER table

5. DESCRIPTION
- Optional descriptive text for the requisition

6. TYPE_LOOKUP_CODE
- Requisition type classification
- Examples: PURCHASE, INTERNAL, etc.

7. STATUS_CODE
- Current processing status
- Values like INCOMPLETE, PENDING, APPROVED, CLOSED

8. AUTHORIZATION_STATUS
- Approval workflow status
- Tracks requisition's progression through approval process

9. CREATED_BY
- User who initially created the record
- System tracking information

10. CREATION_DATE
- Timestamp of record creation

Common Usage:
- Tracks purchase requisition lifecycle
- Supports requisition approvals
- Provides reporting and tracking capabilities

Relationships:
- Linked to PO_REQUISITION_LINES_ALL (detail lines)
- Connected with HR and Inventory modules

Typical Queries:
- Retrieve requisition details
- Check requisition status
- Analyze requisition trends