POR_REQUISITION_HEADERS_ALL
POR_REQUISITION_HEADERS_ALL stores information about requisition headers. You need one row for each requisition header you create. Each row contains the requisition number, preparer, status, and description. . REQUISITION_HEADER_ID is the unique system-generated requisition number. REQUISITION_HEADER_ID is invisible to the user. REQUISITION_NUMBER is the number you use to identify the requisition in forms and reports. Oracle Purchasing generates REQUISITION_NUMBER using the PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let Oracle Purchasing generate requisition numbers for you. . POR_REQUISITION_HEADERS_ALL is one of three tables storing requisition information. POR_REQUISITION_HEADERS_ALL corresponds to the Header region of the Requisitions window.
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
POR_REQUISITION_HEADERS_PK |
REQUISITION_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| REQUISITION_HEADER_ID | NUMBER | 18 | Yes | Requisition header unique identifier | ||
| REJECT_REASON | VARCHAR2 | 4000 | Reason provided by the approver while rejecting the requisition header | |||
| REJECTED_BY_APPROVER_ID | NUMBER | 18 | Uniquely identifies the approver who rejected the requisition header | |||
| HAS_ACTION_REQUIRED_LINES | VARCHAR2 | 1 | Indicator of whether a requisition has at least one line that requires action. | |||
| EXTERNALLY_MANAGED_FLAG | VARCHAR2 | 1 | Indicator of whether a requisition is visible and can be managed in Self Service Procurement. | |||
| PREPARER_ID | NUMBER | 18 | Yes | Unique identifier of the employee who prepared the requisition | ||
| REQUISITION_NUMBER | VARCHAR2 | 64 | Yes | Requisition number | ||
| REQ_BU_ID | NUMBER | 18 | Yes | Business Unit Unique Identifier | ||
| DESCRIPTION | VARCHAR2 | 240 | Description for requisition | |||
| DOCUMENT_STATUS | VARCHAR2 | 25 | Document Status | |||
| JUSTIFICATION | VARCHAR2 | 1000 | Note to approver | |||
| ACTIVE_REQUISITION_FLAG | VARCHAR2 | 1 | Set to 'Y' to indicate that this requisition should be shown to the user when he/she logs into SSP. | |||
| MODIFYING_APPROVER_ID | NUMBER | 18 | If the value is not null, it indicates that the requisition is currently being modified by the approver. Stores the person id of the approver modifying the requisition | |||
| EMERGENCY_REQ_FLAG | VARCHAR2 | 1 | Stores state of emergency req checkbox | |||
| EMERGENCY_PO_NUMBER | VARCHAR2 | 30 | Purchase order number reserved in advance for an emergency requisition | |||
| PRC_BU_ID | NUMBER | 18 | The business unit from which the emergency_po_number is derived. This field completely qualifies the emergency_po_num | |||
| PCARD_ID | NUMBER | 18 | Unique dentifer for procurement card used for the order | |||
| CHANGE_PENDING_FLAG | VARCHAR2 | 1 | Indicates whether requisition is in Change Order process or not | |||
| INTERFACE_SOURCE_CODE | VARCHAR2 | 25 | Source of requisition from Requisition Import | |||
| INTERFACE_SOURCE_LINE_ID | NUMBER | 18 | Source requisition line identifier from Requisition Import | |||
| SUBMISSION_DATE | TIMESTAMP | SUBMISSION_DATE | ||||
| APPROVED_DATE | TIMESTAMP | Date when Requisition is approved | ||||
| REQ_IMPORT_APPROVER_ID | NUMBER | 18 | REQ_IMPORT_APPROVER_ID | |||
| DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | DEFAULT_TAXATION_COUNTRY | |||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | DOCUMENT_SUB_TYPE | |||
| TAX_USER_OVERRIDE_HDR_FLAG | VARCHAR2 | 1 | TAX_USER_OVERRIDE_HEADER_FLAG | |||
| APPROVAL_INSTANCE_ID | NUMBER | 18 | APPROVAL_INSTANCE_ID | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| SOLDTO_LE_ID | NUMBER | 18 | Sold to legal entity unique identifier | |||
| HAS_WITHDRAWN_LINES | VARCHAR2 | 1 | Has value Y if any of the lines have LINE_STATUS = 'WITHDRAWN', otherwise has value N | |||
| HAS_CANCELED_LINES | VARCHAR2 | 1 | Has value Y if any of the lines have LINE_STATUS = 'CANCELED', otherwise has value N | |||
| HAS_RETURNED_LINES | VARCHAR2 | 1 | Has value Y if any of the lines have LINE_STATUS = 'RETURNED', otherwise has value N | |||
| HAS_REJECTED_LINES | VARCHAR2 | 1 | Has value Y if any of the lines have LINE_STATUS = 'REJECTED', otherwise has value N | |||
| HAS_INCOMPLETE_LINES | VARCHAR2 | 1 | Has value Y if any of the lines have LINE_STATUS = 'INCOMPLETE', otherwise has value N | |||
| LOCKED_BY_BUYER_FLAG | VARCHAR2 | 1 | Has value Y if any of the lines have BUYER_PROCESSING_FLAG = 'Y' and LINE_STATUS = ('INCOMPLETE' OR 'PENDING APPROVAL'), otherwise has value N | |||
| HAS_PENDING_APPR_LINES | VARCHAR2 | 1 | Has value Y if any of the lines have LINE_STATUS = 'PENDING APROVAL', otherwise has value N | |||
| LINE_GROUP | VARCHAR2 | 30 | Used for determing which group filter a requisition line belongs to. | |||
| FUNDS_STATUS | VARCHAR2 | 30 | This attribute captures the overall budgetary control status for the requisition. | |||
| PROCESS_STATUS | VARCHAR2 | 30 | This attribute indicates the stage of importing requisitions or running purchase request web service. Default value is NULL. PROCESS_STATUS is 'POST_PLSQL' once the PL/SQL procedure is finished and is 'COMPLETED' once the requisition import or web service is completed. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Requisition Headers (POR_REQUISITION_HEADERS) | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| FUNDS_CHK_FAIL_WARN_FLAG | VARCHAR2 | 1 | It is set to Yes if the implicit funds check upon submission returns failures or warnings. | |||
| BUDGET_CONTROL_ENABLED_FLAG | VARCHAR2 | 1 | Yes | The flag tracks if the requisition has budgetary control enabled or not. Possible values can be Y/N. Default is N. | ||
| OVERRIDING_APPROVER_ID | NUMBER | 18 | Overriding first approver identifier for a requisition for approval routing. | |||
| FUNDS_OVERRIDE_APPROVER_ID | NUMBER | 18 | The ID of user capable of performing funds override on requisition. | |||
| INSUFFICIENT_FUNDS_FLAG | VARCHAR2 | 1 | It is set to Y if the implicit funds check upon submission returns failures and an override is requested. Default is N. | |||
| APPROVAL_NOT_REQUIRED_FLAG | VARCHAR2 | 1 | This flag indicates whether requisition requires approval or not. | |||
| INTERNAL_TRANSFER_REQ_FLAG | VARCHAR2 | 1 | Indicates whether all lines of the requisition are for internal material transfer | |||
| SOURCE_APPLICATION_CODE | VARCHAR2 | 25 | Indicates the name of application from which requisition was created | |||
| LIFECYCLE_STATUS | VARCHAR2 | 30 | Rolledup lifecycle status code of the requisition | |||
| SPECIAL_HANDLING_TYPE_CODE | VARCHAR2 | 30 | Special Handling Descriptive Flexfield Type Code: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE1 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE2 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE3 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE4 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE5 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE6 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE7 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE8 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE9 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE10 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | |||
| SH_ATTRIBUTE11 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE12 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE13 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE14 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE15 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE16 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE17 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE18 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE19 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE20 | VARCHAR2 | 150 | Special Handling Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| SH_ATTRIBUTE_DATE1 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE2 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE3 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE4 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE5 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE6 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE7 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE8 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE9 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_DATE10 | DATE | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER1 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER2 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER3 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER4 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER5 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER6 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER7 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER8 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER9 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| SH_ATTRIBUTE_NUMBER10 | NUMBER | Special Handling Descriptive Flexfield: segment of the user special descriptive flexfield. | ||||
| MAPPED_APPROVAL_ATTRIBUTE1 | VARCHAR2 | 2000 | If the value is not null, it indicates the list of approvers or project roles derived from the REQ_APPROVAL_MAPPING_SET_1 and REQ_APPROVAL_DATA_SET_1 configuration. | |||
| MAPPED_APPROVAL_ATTRIBUTE2 | VARCHAR2 | 2000 | If the value is not null, it indicates the list of approvers or project roles derived from the REQ_APPROVAL_MAPPING_SET_2 and REQ_APPROVAL_DATA_SET_2 configuration. | |||
| MAPPED_APPROVAL_ATTRIBUTE3 | VARCHAR2 | 2000 | If the value is not null, it indicates the list of approvers or project roles derived from the REQ_APPROVAL_MAPPING_SET_3 and REQ_APPROVAL_DATA_SET_3 configuration. | |||
| MAPPED_APPROVAL_ATTRIBUTE4 | VARCHAR2 | 2000 | If the value is not null, it indicates the list of approvers or project roles derived from the REQ_APPROVAL_MAPPING_SET_4 and REQ_APPROVAL_DATA_SET_4 configuration. | |||
| MAPPED_APPROVAL_ATTRIBUTE5 | VARCHAR2 | 2000 | If the value is not null, it indicates the list of approvers or project roles derived from the REQ_APPROVAL_MAPPING_SET_5 and REQ_APPROVAL_DATA_SET_5 configuration. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| inv_supply | por_requisition_headers_all | REQ_HEADER_ID |
| pon_award_allocations | por_requisition_headers_all | ORIG_REQ_HEADER_ID |
| rcv_supply | por_requisition_headers_all | REQ_HEADER_ID |
| por_requisition_lines_all | por_requisition_headers_all | REQUISITION_HEADER_ID |
| pon_backing_req_history | por_requisition_headers_all | REQUISITION_HEADER_ID |
| pon_award_allocations_history | por_requisition_headers_all | ORIG_REQ_HEADER_ID |
| pon_backing_requisitions | por_requisition_headers_all | REQUISITION_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POR_REQUISITION_HEADERS_N1 | Non Unique | Default | PREPARER_ID, REQUISITION_NUMBER |
| POR_REQUISITION_HEADERS_N10 | Non Unique | Default | TRUNC("APPROVED_DATE") |
| POR_REQUISITION_HEADERS_N11 | Non Unique | Default | TRUNC("CREATION_DATE"), CREATED_BY |
| POR_REQUISITION_HEADERS_N12 | Non Unique | Default | EMERGENCY_PO_NUMBER |
| POR_REQUISITION_HEADERS_N13 | Non Unique | Default | REQ_BU_ID, PREPARER_ID, REQUISITION_HEADER_ID, CREATION_DATE |
| POR_REQUISITION_HEADERS_N14 | Non Unique | Default | REQUEST_ID |
| POR_REQUISITION_HEADERS_N15 | Non Unique | Default | PREPARER_ID, REQ_BU_ID, DOCUMENT_STATUS, APPROVED_DATE |
| POR_REQUISITION_HEADERS_N16 | Non Unique | POR_REQUISITION_HEADERS_N16 | HAS_ACTION_REQUIRED_LINES |
| POR_REQUISITION_HEADERS_N17 | Non Unique | POR_REQUISITION_HEADERS_N17 | REQUISITION_NUMBER, REQ_BU_ID |
| POR_REQUISITION_HEADERS_N2 | Non Unique | Default | CREATION_DATE, REQ_BU_ID |
| POR_REQUISITION_HEADERS_N3 | Non Unique | Default | DOCUMENT_STATUS |
| POR_REQUISITION_HEADERS_N4 | Non Unique | Default | MODIFYING_APPROVER_ID |
| POR_REQUISITION_HEADERS_N5 | Non Unique | Default | LAST_UPDATE_DATE |
| POR_REQUISITION_HEADERS_N6 | Non Unique | Default | ACTIVE_REQUISITION_FLAG, PREPARER_ID |
| POR_REQUISITION_HEADERS_N8 | Non Unique | Default | UPPER("DESCRIPTION") |
| POR_REQUISITION_HEADERS_N9 | Non Unique | Default | UPPER("REQUISITION_NUMBER"), "CREATION_DATE" |
| POR_REQUISITION_HEADERS_U1 | Unique | Default | REQUISITION_HEADER_ID |