[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_REQUISITIONS_INTERFACE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_REQUISITIONS_INTERFACE_ALL
|
| Subobject Name: | |
| Status: | VALID |
PO_REQUISITIONS_INTERFACE_ALL contains requisition information from
other applications. Each row includes all the information necessary to
create approved or unapproved requisitions in Oracle Purchasing. The
Oracle Purchasing Requisition Import feature uses this information to
create new requisition headers, lines and distributions.
.
You use the Submit Request window to launch the Requisition Import
program
for any set of rows. You identify the set of rows you want to import
by
setting the INTERFACE_SOURCE_CODE and BATCH_ID columns appropriately
in the interface table.
.
The Requisition Import program validates your data, derives or
defaults additional information and writes an error message for every
validation that fails into the PO_INTERFACE_ERRORS table. Then the
program groups and numbers requisition lines according to the criteria
you specify in the GROUP_CODE and REQ_NUMBER_SEGMENT1 columns, and
creates new requisitions.
.
Most of the columns in the PO_REQUISITIONS_INTERFACE_ALL table are
identical to the corresponding columns in
the PO_REQUISITIONS_HEADERS_ALL, PO_REQUISITION_LINES_ALL and
PO_REQ_DISTRIBUTIONS_ALL tables. You can additionally enter reference
information in the INTERFACE_SOURCE_LINE_ID column.
.
Scope: public
Product: PO
Display Name: PO Requisitions Interface
Category: BUSINESS_ENTITY PO_PURCHASE_REQUISITION
Category: BUSINESS_ENTITY PO_INTERNAL_REQUISITION
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 5 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_REQUISITIONS_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 TRANSACTION_ID
|
| PO_REQUISITIONS_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ITEM_ID
|
| PO_REQUISITIONS_INTERFACE_N10 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INTERFACE_SOURCE_LINE_ID
|
| PO_REQUISITIONS_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DELIVER_TO_LOCATION_ID
|
| PO_REQUISITIONS_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SOURCE_ORGANIZATION_ID
|
| PO_REQUISITIONS_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
DESTINATION_ORGANIZATION_ID
|
| PO_REQUISITIONS_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REQUEST_ID
REQ_NUMBER_SEGMENT1
|
| PO_REQUISITIONS_INTERFACE_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROCESS_FLAG
|
| PO_REQUISITIONS_INTERFACE_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
WIP_ENTITY_ID
|
| PO_REQUISITIONS_INTERFACE_N8 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REQUISITION_HEADER_ID
REQUEST_ID
GROUP_CODE
|
| PO_REQUISITIONS_INTERFACE_N9 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
REQUEST_ID
PROCESS_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | Transaction unique identifier | ||
| PROCESS_FLAG | VARCHAR2 | (30) | Transaction processing state | |
| REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
| PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
| INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | Yes | Interface transaction source |
| INTERFACE_SOURCE_LINE_ID | NUMBER | Interface transaction reference column | ||
| SOURCE_TYPE_CODE | VARCHAR2 | (25) | Requisition source | |
| REQUISITION_HEADER_ID | NUMBER | Requisition header unique identifier | ||
| REQUISITION_LINE_ID | NUMBER | Requisition line unique identifier | ||
| REQ_DISTRIBUTION_ID | NUMBER | Requisition distribution unique identifier | ||
| REQUISITION_TYPE | VARCHAR2 | (25) | Type of requisition | |
| DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Yes | Requisition destination type |
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| QUANTITY | NUMBER | Quantity ordered | ||
| UNIT_PRICE | NUMBER | Unit price | ||
| AUTHORIZATION_STATUS | VARCHAR2 | (25) | Yes | Authorization status type |
| BATCH_ID | NUMBER | Import batch identifier | ||
| GROUP_CODE | VARCHAR2 | (30) | Import grouping code | |
| DELETE_ENABLED_FLAG | VARCHAR2 | (1) | Unused since release version 7.0 | |
| UPDATE_ENABLED_FLAG | VARCHAR2 | (1) | Unused since release version 7.0 | |
| APPROVER_ID | NUMBER | (9) | Approver unique identifier | |
| APPROVER_NAME | VARCHAR2 | (240) | Approver name | |
| APPROVAL_PATH_ID | NUMBER | Approval path unique identifier | ||
| PREPARER_ID | NUMBER | (9) | Preparer unique identifier | |
| AUTOSOURCE_FLAG | VARCHAR2 | (1) | Controls automatic sourcing | |
| REQ_NUMBER_SEGMENT1 | VARCHAR2 | (20) | Requisition number | |
| REQ_NUMBER_SEGMENT2 | VARCHAR2 | (20) | Key flexfield segment | |
| REQ_NUMBER_SEGMENT3 | VARCHAR2 | (20) | Key flexfield segment | |
| REQ_NUMBER_SEGMENT4 | VARCHAR2 | (20) | Key flexfield segment | |
| REQ_NUMBER_SEGMENT5 | VARCHAR2 | (20) | Key flexfield segment | |
| HEADER_DESCRIPTION | VARCHAR2 | (240) | Header description | |
| HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| URGENT_FLAG | VARCHAR2 | (1) | Indicates whether the requisition is urgent or not | |
| HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether an RFQ is required prior to placement on a purchase order | |
| JUSTIFICATION | VARCHAR2 | (480) | Purchase justification | |
| NOTE_TO_BUYER | VARCHAR2 | (480) | Note to buyer | |
| NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to receiver | |
| ITEM_ID | NUMBER | Item unique identifier | ||
| ITEM_SEGMENT1 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT2 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT3 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT4 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT5 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT6 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT7 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT8 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT9 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT10 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT11 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT12 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT13 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT14 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT15 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT16 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT17 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT18 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT19 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_SEGMENT20 | VARCHAR2 | (40) | Key flexfield segment | |
| ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
| CHARGE_ACCOUNT_ID | NUMBER | Unique Identifier for the General Ledger charge account | ||
| CHARGE_ACCOUNT_SEGMENT1 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT2 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT3 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT4 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT5 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT6 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT7 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT8 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT9 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT10 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT11 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT12 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT13 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT14 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT15 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT16 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT17 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT18 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT19 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT20 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT21 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT22 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT23 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT24 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT25 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT26 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT27 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT28 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT29 | VARCHAR2 | (25) | Key flexfield segment | |
| CHARGE_ACCOUNT_SEGMENT30 | VARCHAR2 | (25) | Key flexfield segment | |
| CATEGORY_ID | NUMBER | Category unique identifier | ||
| CATEGORY_SEGMENT1 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT2 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT3 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT4 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT5 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT6 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT7 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT8 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT9 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT10 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT11 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT12 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT13 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT14 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT15 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT16 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT17 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT18 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT19 | VARCHAR2 | (40) | Key flexfield segment | |
| CATEGORY_SEGMENT20 | VARCHAR2 | (40) | Key flexfield segment | |
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure | |
| UOM_CODE | VARCHAR2 | (3) | 3-letter unit of measure code | |
| LINE_TYPE_ID | NUMBER | Requisition line type unique identifier | ||
| LINE_TYPE | VARCHAR2 | (25) | Requisition line type name | |
| UN_NUMBER_ID | NUMBER | UN number unique identifier | ||
| UN_NUMBER | VARCHAR2 | (25) | UN number | |
| HAZARD_CLASS_ID | NUMBER | Hazard class unique identifier | ||
| HAZARD_CLASS | VARCHAR2 | (40) | Hazard class | |
| MUST_USE_SUGG_VENDOR_FLAG | VARCHAR2 | (10) | Unused since release 8.0 | |
| REFERENCE_NUM | VARCHAR2 | (25) | Reference number | |
| WIP_ENTITY_ID | NUMBER | WIP job or repetitive assembly identifier | ||
| WIP_LINE_ID | NUMBER | WIP line identifier | ||
| WIP_OPERATION_SEQ_NUM | NUMBER | WIP operation sequence number within a routing | ||
| WIP_RESOURCE_SEQ_NUM | NUMBER | WIP resource sequence number | ||
| WIP_REPETITIVE_SCHEDULE_ID | NUMBER | WIP repetitive schedule identifier | ||
| PROJECT_NUM | VARCHAR2 | (25) | Project accounting project number | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Project accounting expenditure type | |
| SOURCE_ORGANIZATION_ID | NUMBER | Source organization unique identifier | ||
| SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | 3-letter source organization code | |
| SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Source subinventory | |
| DESTINATION_ORGANIZATION_ID | NUMBER | Destination organization unique identifier | ||
| DESTINATION_ORGANIZATION_CODE | VARCHAR2 | (3) | 3-letter destination organization code | |
| DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Destination subinventory | |
| DELIVER_TO_LOCATION_ID | NUMBER | Deliver-to-location unique identifier | ||
| DELIVER_TO_LOCATION_CODE | VARCHAR2 | (60) | Deliver-to-location code | |
| DELIVER_TO_REQUESTOR_ID | NUMBER | (9) | Requester unique identifier | |
| DELIVER_TO_REQUESTOR_NAME | VARCHAR2 | (240) | Requester name | |
| SUGGESTED_BUYER_ID | NUMBER | (9) | Suggested buyer unique identifier | |
| SUGGESTED_BUYER_NAME | VARCHAR2 | (240) | Suggested buyer name | |
| SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | Suggested supplier name | |
| SUGGESTED_VENDOR_ID | NUMBER | Suggested supplier unique identifier | ||
| SUGGESTED_VENDOR_SITE_ID | NUMBER | Suggested supplier site unique identifier | ||
| SUGGESTED_VENDOR_CONTACT | VARCHAR2 | (80) | Suggested supplier contact | |
| SUGGESTED_VENDOR_CONTACT_ID | NUMBER | Suggested supplier contact unique identifier | ||
| SUGGESTED_VENDOR_PHONE | VARCHAR2 | (25) | Suggested supplier phone number | |
| SUGGESTED_VENDOR_ITEM_NUM | VARCHAR2 | (25) | Suggested supplier item number | |
| LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| LINE_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| LINE_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| NEED_BY_DATE | DATE | Date the requisition is needed internally | ||
| NOTE1_ID | NUMBER | Note unique identifier | ||
| NOTE2_ID | NUMBER | Note unique identifier | ||
| NOTE3_ID | NUMBER | Note unique identifier | ||
| NOTE4_ID | NUMBER | Note unique identifier | ||
| NOTE5_ID | NUMBER | Note unique identifier | ||
| NOTE6_ID | NUMBER | Note unique identifier | ||
| NOTE7_ID | NUMBER | Note unique identifier | ||
| NOTE8_ID | NUMBER | Note unique identifier | ||
| NOTE9_ID | NUMBER | Note unique identifier | ||
| NOTE10_ID | NUMBER | Note unique identifier | ||
| NOTE1_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE2_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE3_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE4_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE5_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE6_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE7_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE8_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE9_TITLE | VARCHAR2 | (80) | Note title | |
| NOTE10_TITLE | VARCHAR2 | (80) | Note title | |
| GL_DATE | DATE | Date the distribution should be encumbered | ||
| DIST_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| DISTRIBUTION_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| DISTRIBUTION_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| PREPARER_NAME | VARCHAR2 | (240) | Preparer name | |
| BOM_RESOURCE_ID | NUMBER | BOM resource unique identifier | ||
| ACCRUAL_ACCOUNT_ID | NUMBER | Unique identifier for the General Ledger accrual account | ||
| VARIANCE_ACCOUNT_ID | NUMBER | Unique identifier for the General Ledger variance account | ||
| BUDGET_ACCOUNT_ID | NUMBER | Unique identifier for the General Ledger budget account | ||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code | |
| GOVERNMENT_CONTEXT | VARCHAR2 | (30) | USSGL descriptive flexfield context column | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency unique identifier | |
| CURRENCY_UNIT_PRICE | NUMBER | Currency unit price | ||
| RATE | NUMBER | Exchange rate | ||
| RATE_DATE | DATE | Exchange rate date | ||
| RATE_TYPE | VARCHAR2 | (30) | Exchange rate type | |
| PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | Indicator of whether or not encumbrance is needed | |
| AUTOSOURCE_DOC_HEADER_ID | NUMBER | Source document header unique identifier | ||
| AUTOSOURCE_DOC_LINE_NUM | NUMBER | Source document line number | ||
| PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | Project accounting descriptive flexfield context column | |
| EXPENDITURE_ORGANIZATION_ID | NUMBER | Project accounting expenditure organization unique identifier | ||
| PROJECT_ID | NUMBER | Project accounting project unique identifier | ||
| TASK_ID | NUMBER | Project accounting task unique identifier | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Project Manufacturing end item unit number | |
| EXPENDITURE_ITEM_DATE | DATE | Project accounting expenditure item date | ||
| DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | Document type | |
| ORG_ID | NUMBER | Organization identifier | ||
| TRANSACTION_REASON_CODE | VARCHAR2 | (25) | Transaction reason | |
| ALLOCATION_TYPE | VARCHAR2 | (25) | Method of allocation across distributions. Can be PERCENT. | |
| ALLOCATION_VALUE | NUMBER | Allocation Split Value | ||
| MULTI_DISTRIBUTIONS | VARCHAR2 | (1) | Indicator of whether this requisition should have multiple distributions | |
| REQ_DIST_SEQUENCE_ID | NUMBER | Foreign key to PO_REQ_DIST_INTERFACE table | ||
| KANBAN_CARD_ID | NUMBER | Primary key for the kanban card | ||
| EMERGENCY_PO_NUM | VARCHAR2 | (20) | Purchase order number reserved in advance for an emergency requisition | |
| AWARD_ID | NUMBER | (15) | Award identifier | |
| TAX_CODE_ID | NUMBER | Unique identifier for the tax | ||
| OKE_CONTRACT_HEADER_ID | NUMBER | Oracle Project Contract Number unique identifier | ||
| OKE_CONTRACT_NUM | VARCHAR2 | (120) | Oracle Project Contract Number | |
| OKE_CONTRACT_VERSION_ID | NUMBER | Oracle Project Contract Version Number | ||
| OKE_CONTRACT_LINE_ID | NUMBER | Oracle Project Contract Line Unique identifier | ||
| OKE_CONTRACT_LINE_NUM | VARCHAR2 | (150) | Oracle Project Contract Line Number | |
| OKE_CONTRACT_DELIVERABLE_ID | NUMBER | Oracle Project Contract Deliverable Unique identifier | ||
| OKE_CONTRACT_DELIVERABLE_NUM | VARCHAR2 | (150) | Oracle Project Contract Deliverable Number | |
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Secondary unit of measure | |
| SECONDARY_UOM_CODE | VARCHAR2 | (3) | Abbreviated Secondary unit of meaure | |
| SECONDARY_QUANTITY | NUMBER | Quantity ordered in secondary unit of measure | ||
| PREFERRED_GRADE | VARCHAR2 | (150) | Preferred quality grade of the item ordered | |
| VMI_FLAG | VARCHAR2 | (1) | Indicates VMI requisition with value = 'Y' | |
| TAX_USER_OVERRIDE_FLAG | VARCHAR2 | (1) | To capture whether the Tax Code was populated by the user. It is used internally to store the status od the tax overide | |
| AMOUNT | NUMBER | Amount for the Fixed Priced Service requisition lines | ||
| CURRENCY_AMOUNT | NUMBER | Amount for the Fixed Priced Service requisition lines in foreign currency | ||
| SHIP_METHOD | VARCHAR2 | (30) | Ship method (References WSH_CARRIER_SERVICES.ship_method_code.) | |
| ESTIMATED_PICKUP_DATE | DATE | Estimated pickup date. | ||
| BASE_UNIT_PRICE | NUMBER | Base Unit Price | ||
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | Flag to Indicate if the price is negotiated by the preparer | |
| TAX_NAME | VARCHAR2 | (30) | Overrides the system defaulted tax classification during tax calculation | |
| FUNDED_VALUE | NUMBER | The Funded value. | ||
| PARTIAL_FUNDED_FLAG | VARCHAR2 | (1) | States whether the requisition is partially funded | |
| FEDERAL_FLAG | VARCHAR2 | (1) | States whether this is a federal requisition | |
| NOTE_TO_APPROVER#1 | VARCHAR2 | (4000) | Note to approver | |
| TASK_NUM#1 | VARCHAR2 | (250) | Project accounting task number | |
| SUGGESTED_VENDOR_SITE#1 | VARCHAR2 | (46) | Suggested supplier site |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, PROCESS_FLAG
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID
, SOURCE_TYPE_CODE
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID
, REQUISITION_TYPE
, DESTINATION_TYPE_CODE
, ITEM_DESCRIPTION
, QUANTITY
, UNIT_PRICE
, AUTHORIZATION_STATUS
, BATCH_ID
, GROUP_CODE
, DELETE_ENABLED_FLAG
, UPDATE_ENABLED_FLAG
, APPROVER_ID
, APPROVER_NAME
, APPROVAL_PATH_ID
, PREPARER_ID
, AUTOSOURCE_FLAG
, REQ_NUMBER_SEGMENT1
, REQ_NUMBER_SEGMENT2
, REQ_NUMBER_SEGMENT3
, REQ_NUMBER_SEGMENT4
, REQ_NUMBER_SEGMENT5
, HEADER_DESCRIPTION
, HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, URGENT_FLAG
, HEADER_ATTRIBUTE15
, RFQ_REQUIRED_FLAG
, JUSTIFICATION
, NOTE_TO_BUYER
, NOTE_TO_RECEIVER
, ITEM_ID
, ITEM_SEGMENT1
, ITEM_SEGMENT2
, ITEM_SEGMENT3
, ITEM_SEGMENT4
, ITEM_SEGMENT5
, ITEM_SEGMENT6
, ITEM_SEGMENT7
, ITEM_SEGMENT8
, ITEM_SEGMENT9
, ITEM_SEGMENT10
, ITEM_SEGMENT11
, ITEM_SEGMENT12
, ITEM_SEGMENT13
, ITEM_SEGMENT14
, ITEM_SEGMENT15
, ITEM_SEGMENT16
, ITEM_SEGMENT17
, ITEM_SEGMENT18
, ITEM_SEGMENT19
, ITEM_SEGMENT20
, ITEM_REVISION
, CHARGE_ACCOUNT_ID
, CHARGE_ACCOUNT_SEGMENT1
, CHARGE_ACCOUNT_SEGMENT2
, CHARGE_ACCOUNT_SEGMENT3
, CHARGE_ACCOUNT_SEGMENT4
, CHARGE_ACCOUNT_SEGMENT5
, CHARGE_ACCOUNT_SEGMENT6
, CHARGE_ACCOUNT_SEGMENT7
, CHARGE_ACCOUNT_SEGMENT8
, CHARGE_ACCOUNT_SEGMENT9
, CHARGE_ACCOUNT_SEGMENT10
, CHARGE_ACCOUNT_SEGMENT11
, CHARGE_ACCOUNT_SEGMENT12
, CHARGE_ACCOUNT_SEGMENT13
, CHARGE_ACCOUNT_SEGMENT14
, CHARGE_ACCOUNT_SEGMENT15
, CHARGE_ACCOUNT_SEGMENT16
, CHARGE_ACCOUNT_SEGMENT17
, CHARGE_ACCOUNT_SEGMENT18
, CHARGE_ACCOUNT_SEGMENT19
, CHARGE_ACCOUNT_SEGMENT20
, CHARGE_ACCOUNT_SEGMENT21
, CHARGE_ACCOUNT_SEGMENT22
, CHARGE_ACCOUNT_SEGMENT23
, CHARGE_ACCOUNT_SEGMENT24
, CHARGE_ACCOUNT_SEGMENT25
, CHARGE_ACCOUNT_SEGMENT26
, CHARGE_ACCOUNT_SEGMENT27
, CHARGE_ACCOUNT_SEGMENT28
, CHARGE_ACCOUNT_SEGMENT29
, CHARGE_ACCOUNT_SEGMENT30
, CATEGORY_ID
, CATEGORY_SEGMENT1
, CATEGORY_SEGMENT2
, CATEGORY_SEGMENT3
, CATEGORY_SEGMENT4
, CATEGORY_SEGMENT5
, CATEGORY_SEGMENT6
, CATEGORY_SEGMENT7
, CATEGORY_SEGMENT8
, CATEGORY_SEGMENT9
, CATEGORY_SEGMENT10
, CATEGORY_SEGMENT11
, CATEGORY_SEGMENT12
, CATEGORY_SEGMENT13
, CATEGORY_SEGMENT14
, CATEGORY_SEGMENT15
, CATEGORY_SEGMENT16
, CATEGORY_SEGMENT17
, CATEGORY_SEGMENT18
, CATEGORY_SEGMENT19
, CATEGORY_SEGMENT20
, UNIT_OF_MEASURE
, UOM_CODE
, LINE_TYPE_ID
, LINE_TYPE
, UN_NUMBER_ID
, UN_NUMBER
, HAZARD_CLASS_ID
, HAZARD_CLASS
, MUST_USE_SUGG_VENDOR_FLAG
, REFERENCE_NUM
, WIP_ENTITY_ID
, WIP_LINE_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, WIP_REPETITIVE_SCHEDULE_ID
, PROJECT_NUM
, EXPENDITURE_TYPE
, SOURCE_ORGANIZATION_ID
, SOURCE_ORGANIZATION_CODE
, SOURCE_SUBINVENTORY
, DESTINATION_ORGANIZATION_ID
, DESTINATION_ORGANIZATION_CODE
, DESTINATION_SUBINVENTORY
, DELIVER_TO_LOCATION_ID
, DELIVER_TO_LOCATION_CODE
, DELIVER_TO_REQUESTOR_ID
, DELIVER_TO_REQUESTOR_NAME
, SUGGESTED_BUYER_ID
, SUGGESTED_BUYER_NAME
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_ID
, SUGGESTED_VENDOR_SITE_ID
, SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_CONTACT_ID
, SUGGESTED_VENDOR_PHONE
, SUGGESTED_VENDOR_ITEM_NUM
, LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
, NEED_BY_DATE
, NOTE1_ID
, NOTE2_ID
, NOTE3_ID
, NOTE4_ID
, NOTE5_ID
, NOTE6_ID
, NOTE7_ID
, NOTE8_ID
, NOTE9_ID
, NOTE10_ID
, NOTE1_TITLE
, NOTE2_TITLE
, NOTE3_TITLE
, NOTE4_TITLE
, NOTE5_TITLE
, NOTE6_TITLE
, NOTE7_TITLE
, NOTE8_TITLE
, NOTE9_TITLE
, NOTE10_TITLE
, GL_DATE
, DIST_ATTRIBUTE_CATEGORY
, DISTRIBUTION_ATTRIBUTE1
, DISTRIBUTION_ATTRIBUTE2
, DISTRIBUTION_ATTRIBUTE3
, DISTRIBUTION_ATTRIBUTE4
, DISTRIBUTION_ATTRIBUTE5
, DISTRIBUTION_ATTRIBUTE6
, DISTRIBUTION_ATTRIBUTE7
, DISTRIBUTION_ATTRIBUTE8
, DISTRIBUTION_ATTRIBUTE9
, DISTRIBUTION_ATTRIBUTE10
, DISTRIBUTION_ATTRIBUTE11
, DISTRIBUTION_ATTRIBUTE12
, DISTRIBUTION_ATTRIBUTE13
, DISTRIBUTION_ATTRIBUTE14
, DISTRIBUTION_ATTRIBUTE15
, PREPARER_NAME
, BOM_RESOURCE_ID
, ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID
, BUDGET_ACCOUNT_ID
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, CURRENCY_CODE
, CURRENCY_UNIT_PRICE
, RATE
, RATE_DATE
, RATE_TYPE
, PREVENT_ENCUMBRANCE_FLAG
, AUTOSOURCE_DOC_HEADER_ID
, AUTOSOURCE_DOC_LINE_NUM
, PROJECT_ACCOUNTING_CONTEXT
, EXPENDITURE_ORGANIZATION_ID
, PROJECT_ID
, TASK_ID
, END_ITEM_UNIT_NUMBER
, EXPENDITURE_ITEM_DATE
, DOCUMENT_TYPE_CODE
, ORG_ID
, TRANSACTION_REASON_CODE
, ALLOCATION_TYPE
, ALLOCATION_VALUE
, MULTI_DISTRIBUTIONS
, REQ_DIST_SEQUENCE_ID
, KANBAN_CARD_ID
, EMERGENCY_PO_NUM
, AWARD_ID
, TAX_CODE_ID
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_NUM
, OKE_CONTRACT_VERSION_ID
, OKE_CONTRACT_LINE_ID
, OKE_CONTRACT_LINE_NUM
, OKE_CONTRACT_DELIVERABLE_ID
, OKE_CONTRACT_DELIVERABLE_NUM
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_UOM_CODE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, VMI_FLAG
, TAX_USER_OVERRIDE_FLAG
, AMOUNT
, CURRENCY_AMOUNT
, SHIP_METHOD
, ESTIMATED_PICKUP_DATE
, BASE_UNIT_PRICE
, NEGOTIATED_BY_PREPARER_FLAG
, TAX_NAME
, FUNDED_VALUE
, PARTIAL_FUNDED_FLAG
, FEDERAL_FLAG
, NOTE_TO_APPROVER#1
, TASK_NUM#1
, SUGGESTED_VENDOR_SITE#1
FROM PO.PO_REQUISITIONS_INTERFACE_ALL;
PO.PO_REQUISITIONS_INTERFACE_ALL does not reference any database object
PO.PO_REQUISITIONS_INTERFACE_ALL is referenced by following:
PO
PO_REQUISITIONS_INTERFACE_ALL#
|
|
|
|