POR_REQUISITION_HEADERS_ALL is the table used by Oracle Fusion to store the Requisition Header data. Related tables are por_requisition_lines_all which is the child table for header table and stores the line level data. So lets have a look at the table structure, indexes and constraints.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
POR_REQUISITION_HEADERS_ALL Table Structure
| COLUMN_NAME | DATA_TYPE | NULLABLE |
| REQUISITION_HEADER_ID | NUMBER | N |
| EXTERNALLY_MANAGED_FLAG | VARCHAR2(4) | Y |
| PREPARER_ID | NUMBER | N |
| REQUISITION_NUMBER | VARCHAR2(256) | N |
| REQ_BU_ID | NUMBER | N |
| DESCRIPTION | VARCHAR2(960) | Y |
| DOCUMENT_STATUS | VARCHAR2(100) | Y |
| JUSTIFICATION | VARCHAR2(4000) | Y |
| ACTIVE_REQUISITION_FLAG | VARCHAR2(4) | Y |
| MODIFYING_APPROVER_ID | NUMBER | Y |
| EMERGENCY_REQ_FLAG | VARCHAR2(4) | Y |
| EMERGENCY_PO_NUMBER | VARCHAR2(120) | Y |
| PRC_BU_ID | NUMBER | Y |
| PCARD_ID | NUMBER | Y |
| CHANGE_PENDING_FLAG | VARCHAR2(4) | Y |
| INTERFACE_SOURCE_CODE | VARCHAR2(100) | Y |
| INTERFACE_SOURCE_LINE_ID | NUMBER | Y |
| SUBMISSION_DATE | TIMESTAMP(6) | Y |
| APPROVED_DATE | TIMESTAMP(6) | Y |
| REQ_IMPORT_APPROVER_ID | NUMBER | Y |
| DEFAULT_TAXATION_COUNTRY | VARCHAR2(8) | Y |
| DOCUMENT_SUB_TYPE | VARCHAR2(960) | Y |
| TAX_USER_OVERRIDE_HDR_FLAG | VARCHAR2(4) | Y |
| APPROVAL_INSTANCE_ID | NUMBER | Y |
| ATTRIBUTE_CATEGORY | VARCHAR2(120) | Y |
| SOLDTO_LE_ID | NUMBER | Y |
| HAS_WITHDRAWN_LINES | VARCHAR2(4) | Y |
| HAS_CANCELED_LINES | VARCHAR2(4) | Y |
| HAS_RETURNED_LINES | VARCHAR2(4) | Y |
| HAS_REJECTED_LINES | VARCHAR2(4) | Y |
| HAS_INCOMPLETE_LINES | VARCHAR2(4) | Y |
| LOCKED_BY_BUYER_FLAG | VARCHAR2(4) | Y |
| HAS_PENDING_APPR_LINES | VARCHAR2(4) | Y |
| LINE_GROUP | VARCHAR2(120) | Y |
| FUNDS_STATUS | VARCHAR2(120) | Y |
| PROCESS_STATUS | VARCHAR2(120) | Y |
| ATTRIBUTE1 – ATTRIBUTE20 | VARCHAR2(600) | Y |
| ATTRIBUTE_DATE1 – ATTRIBUTE_DATE10 | DATE | Y |
| ATTRIBUTE_TIMESTAMP1 – ATTRIBUTE_TIMESTAMP10 | TIMESTAMP(6) | Y |
| ATTRIBUTE_NUMBER1 – ATTRIBUTE_NUMBER10 | NUMBER | Y |
| CREATED_BY | VARCHAR2(256) | N |
| CREATION_DATE | TIMESTAMP(6) | N |
| LAST_UPDATED_BY | VARCHAR2(256) | N |
| LAST_UPDATE_DATE | TIMESTAMP(6) | N |
| LAST_UPDATE_LOGIN | VARCHAR2(128) | Y |
| REQUEST_ID | NUMBER | Y |
| JOB_DEFINITION_NAME | VARCHAR2(400) | Y |
| JOB_DEFINITION_PACKAGE | VARCHAR2(3600) | Y |
| OBJECT_VERSION_NUMBER | NUMBER | N |
| FUNDS_CHK_FAIL_WARN_FLAG | VARCHAR2(4) | Y |
| BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2(4) | N |
| OVERRIDING_APPROVER_ID | NUMBER | Y |
| FUNDS_OVERRIDE_APPROVER_ID | NUMBER | Y |
| INSUFFICIENT_FUNDS_FLAG | VARCHAR2(4) | Y |
| INTERNAL_TRANSFER_REQ_FLAG | VARCHAR2(4) | Y |
Indexes
Index type F means Function Based while N means Normal index.
| INDEX_NAME | INDEX_TYPE | UNIQUENESS | COLUMN_NAME |
| POR_REQUISITION_HEADERS_N1 | N | N | PREPARER_ID |
| POR_REQUISITION_HEADERS_N1 | N | N | REQUISITION_NUMBER |
| POR_REQUISITION_HEADERS_N10 | F | N | SYS_NC00104$ |
| POR_REQUISITION_HEADERS_N11 | F | N | SYS_NC00105$ |
| POR_REQUISITION_HEADERS_N12 | N | N | EMERGENCY_PO_NUMBER |
| POR_REQUISITION_HEADERS_N13 | N | N | REQ_BU_ID |
| POR_REQUISITION_HEADERS_N13 | N | N | PREPARER_ID |
| POR_REQUISITION_HEADERS_N13 | N | N | REQUISITION_HEADER_ID |
| POR_REQUISITION_HEADERS_N13 | N | N | CREATION_DATE |
| POR_REQUISITION_HEADERS_N14 | N | N | REQUEST_ID |
| POR_REQUISITION_HEADERS_N2 | N | N | CREATION_DATE |
| POR_REQUISITION_HEADERS_N2 | N | N | REQ_BU_ID |
| POR_REQUISITION_HEADERS_N3 | N | N | DOCUMENT_STATUS |
| POR_REQUISITION_HEADERS_N4 | N | N | MODIFYING_APPROVER_ID |
| POR_REQUISITION_HEADERS_N5 | N | N | LAST_UPDATE_DATE |
| POR_REQUISITION_HEADERS_N6 | N | N | ACTIVE_REQUISITION_FLAG |
| POR_REQUISITION_HEADERS_N6 | N | N | LAST_UPDATED_BY |
| POR_REQUISITION_HEADERS_N8 | F | N | SYS_NC00101$ |
| POR_REQUISITION_HEADERS_N9 | F | N | SYS_NC00102$ |
| POR_REQUISITION_HEADERS_N9 | F | N | SYS_NC00103$ |
| POR_REQUISITION_HEADERS_U1 | N | Y | REQUISITION_HEADER_ID |
Related Posts
- POR_REQUISITION_LINES_ALL: Table Structure, Index and Constraints
- P2P Or Procure To Pay Cycle in Oracle
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com
Check out the Amazon Deals of the day based on your interests..
1 thought on “POR_REQUISITION_HEADERS_ALL: Columns & Indexes”
Comments are closed.