1. Tables and Views for Procurement
  2. POR_REQ_LINES_INTERFACE_ALL

POR_REQ_LINES_INTERFACE_ALL

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

Details

  • Schema: FUSION

  • Object owner: POR

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

POR_REQ_LINES_INTERFACE_A_PK

REQ_LINE_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REQ_LINE_INTERFACE_ID NUMBER 18 Yes Requisition line interface unique identifier.
SHIP_TO_CUST_CONTACT_EMAIL VARCHAR2 240 Email of the Contact from the company where the good are shipped.
DELIVER_TO_CUST_CONTACT_EMAIL VARCHAR2 240 Email of the contact from the company where the goods are being delivered.
REQ_HEADER_INTERFACE_ID NUMBER 18 Requisition header interface unique identifier.
REQUISITION_HEADER_ID NUMBER 18 Requisition header identification.Internal use only.
REQUISITION_LINE_ID NUMBER 18 Requisition line identification.Internal use only.
INTERFACE_LINE_KEY VARCHAR2 50 Cloud interface alternate line key code for integrating applications to be able to identify the requisition line data loaded in the interface table.
INTERFACE_HEADER_KEY VARCHAR2 50 Cloud interface alternate header key code for integrating applications to be able to identify the requisition header data loaded in the interface table.
PROCESS_FLAG VARCHAR2 30 Application-updated flag that indicates whether the requisition is created with all lines that pass validation or is not created if any line does not pass validation.
PRC_BU_ID NUMBER 18 Unique identification of the business unit that manages and owns the purchasing document.
PRC_BU_NAME VARCHAR2 240 The business unit that manages and owns the purchasing document.
INTERFACE_SOURCE_LINE_ID NUMBER 18 *OBSOLETE*Application-updated identifier that references the source transaction.*OBSOLETE*
DESTINATION_TYPE_CODE VARCHAR2 25 Type of the destination to which the requested item should be delivered. The possible lookup code values are INVENTORY, and EXPENSE.
ITEM_DESCRIPTION VARCHAR2 240 Description of the requested item.
QUANTITY NUMBER Quantity of the item to be added to the requisition.
GROUP_CODE VARCHAR2 30 Option by which the requisition lines are grouped when they are being processed by the import program. Requisition lines that are grouped together will be put on the same requisition header. The possible lookup code values are NONE, BUYER, CATEGORY, ITEM, LOCATION, and SUPPLIER.
AUTOSOURCE_FLAG VARCHAR2 1 Allows purchasing documents to derive the supply source from purchase agreements. The supplier and the price information are derived from the source agreement.
URGENT_FLAG VARCHAR2 1 Indicates whether the requisition is urgent or not.
NEGOTIATION_REQUIRED_FLAG VARCHAR2 1 Indicates if negotiation is required for the requested item.
NOTE_TO_BUYER VARCHAR2 1000 Note to the buyer who will be processing the request.
NOTE_TO_RECEIVER VARCHAR2 1000 Note to the receiver who will be receiving the item.
ITEM_ID NUMBER 18 Unique number for an item.
ITEM_REVISION VARCHAR2 18 A particular version of an item.
ITEM_NUMBER VARCHAR2 300 Unique number for an item.
CATEGORY_ID NUMBER 18 Unique idenfication of the category of the item.
CATEGORY_NAME VARCHAR2 250 Indicates the name that uniquely defines an item category.
UOM_CODE VARCHAR2 3 Code in which the quantity of an item is expressed.
LINE_TYPE_ID NUMBER 18 Unique identification of a type to indicate whether a purchasing document line is for goods or services, as well as some default attributes associated with the line.
LINE_TYPE VARCHAR2 30 A type to indicate whether a purchasing document line is for goods or services, as well as some default attributes associated with the line.
UN_NUMBER_ID NUMBER 18 The unique identifier of the United Nations identification number for the hazardous material.
UN_NUMBER VARCHAR2 25 The United Nations identification number for the hazardous material.
HAZARD_CLASS_ID NUMBER 18 Unique identification of the name to classify hazardous materials, to facilitate safety regulations compliance.
HAZARD_CLASS VARCHAR2 40 Name to identify and classify hazardous materials, to facilitate safety regulations compliance.
DESTINATION_ORGANIZATION_ID NUMBER 18 Unique identification of the organization to which the requested item will be delivered.
DESTINATION_ORGANIZATION_CODE VARCHAR2 18 Code of the organization to which the requested item will be delivered.
DESTINATION_SUBINVENTORY VARCHAR2 10 Subinventory to which the requested item should be delivered.
DELIVER_TO_LOCATION_ID NUMBER 18 Unique identification of the final location where the goods previously received from the supplier will be delivered.
DELIVER_TO_LOCATION_CODE VARCHAR2 60 Code of the final location where the goods previously received from the supplier will be delivered.
REQUESTER_ID NUMBER 18 Unique identification of the requester.
REQUESTER_NAME VARCHAR2 240 *OBSOLETE*Name of the requester in list format as: {LastName},{FirstName}.*OBSOLETE*
SUGGESTED_BUYER_ID NUMBER 18 Unique identification of the person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.
SUGGESTED_BUYER_NAME VARCHAR2 240 *OBSOLETE*Person responsible for placing item resupply orders with suppliers and negotiating supplier contracts. Name of the buyer in list format as: {LastName},{FirstName}.*OBSOLETE*
SUGGESTED_VENDOR_NAME VARCHAR2 360 Organization or individual that provides goods or services to the buying organization for payment.
VENDOR_ID NUMBER 18 Unique identification of the organization or individual that provides goods or services to the buying organization for payment.
VENDOR_NUMBER VARCHAR2 30 The unique identifier of the supplier assigned by the buying organization.
SUGGESTED_VENDOR_SITE VARCHAR2 240 The entity that models how the buying organization conducts business with the supplier.
VENDOR_SITE_ID NUMBER 18 Unique identification of the entity that models how the buying organization conducts business with the supplier.
SUGGESTED_VENDOR_CONTACT VARCHAR2 80 Employee of the supplier identified on purchasing documents and represents the supplier in communications with the buying organization.
VENDOR_CONTACT_ID NUMBER 18 Unique identification of the employee of the supplier identified on purchasing documents and represents the supplier in communications with the buying organization.
SUGGESTED_VENDOR_CONTACT_PHONE VARCHAR2 30 Identifies the full phone number for a supplier contact.
SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2 30 The formatted fax number for a supplier address.
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2 1000 Identifies the e-mail for a supplier contact.
SUGGESTED_SUPPLIER_ITEM_NUM VARCHAR2 300 The name or number supplier assigns to an item.
NEW_SUPPLIER_FLAG VARCHAR2 1 Indicates whether or not the supplier is new.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SH_ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
NEED_BY_DATE DATE Date by which the requested item is needed.
CURRENCY_CODE VARCHAR2 15 The three-letter ISO code associated with a currency.
CURRENCY_UNIT_PRICE NUMBER Unit price of the requested item in the currency provided.
RATE NUMBER The ratio at which the principal unit of one currency can be converted into another currency.
RATE_DATE DATE The date as of which a conversion rate is used to convert an amount into another currency.
RATE_TYPE VARCHAR2 30 The source of a currency conversion rate, such as user defined, spot, or corporate.
SOURCE_DOC_HEADER_ID NUMBER 18 The unique identifier of an agreement in a Procurement BU.
SOURCE_DOC_HEADER_NUMBER VARCHAR2 30 The unique number of an agreement in a Procurement BU.
SOURCE_DOC_LINE_ID NUMBER 18 Unique identifier of the agreement line record number.
SOURCE_DOC_LINE_NUMBER NUMBER Agreement line record number.
SECONDARY_UOM_CODE VARCHAR2 3 Secondary unit of measure of the requested item.
SECONDARY_QUANTITY NUMBER Quantity in the secondary unit of measure of the requested item.
CURRENCY_AMOUNT NUMBER Amount of the item to be added to the requisition in the currency provided.
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 1 Indicates if the requested item is negotiated with the supplier.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
TRX_BUSINESS_CATEGORY VARCHAR2 240 Code of a business classification used by Oracle Fusion Tax to identify and categorize an external transaction into a Fusion Tax transaction.
TRX_BUSINESS_CATEGORY_NAME VARCHAR2 240 Name of a business classification used by Oracle Fusion Tax to identify and categorize an external transaction into a Fusion Tax transaction.
PRODUCT_TYPE VARCHAR2 240 Code of the nature of the product involved in a taxable transaction. For example, goods or services.
PRODUCT_TYPE_NAME VARCHAR2 80 Name of the nature of the product involved in a taxable transaction. For example, goods or services.
PRODUCT_FISC_CLASSIFICATION_ID NUMBER 18 Unique identification of the classification used by a tax authority to categorize a product for a tax.
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Code of the classification used by a tax authority to categorize a product for a tax.
PRODUCT_FISC_CLASS_NAME VARCHAR2 250 Name of the classification used by a tax authority to categorize a product for a tax.
PRODUCT_CATEGORY VARCHAR2 240 Code of the type of product fiscal classification used to classify products.
PRODUCT_CATEGORY_NAME VARCHAR2 1996 Name of the type of product fiscal classification used to classify products.
LINE_INTENDED_USE_ID NUMBER 18 A tax classification unique identifier based on the purpose for which a product is used.
LINE_INTENDED_USE VARCHAR2 240 A tax classification code based on the purpose for which a product is used.
LINE_INTENDED_USE_NAME VARCHAR2 250 A tax classification name based on the purpose for which a product is used.
USER_DEFINED_FISC_CLASS VARCHAR2 240 A classification code for any tax requirement that you cannot define using the existing fiscal classification types.
USER_DEFINED_FISC_CLASS_NAME VARCHAR2 240 A classification name for any tax requirement that you cannot define using the existing fiscal classification types.
TAX_CLASSIFICATION_CODE VARCHAR2 50 A code for the tax classification, a grouping of taxes for reporting and processing purposes.
TAX_CLASSIFICATION_NAME VARCHAR2 80 A name for the tax classification, a grouping of taxes for reporting and processing purposes.
ASSESSABLE_VALUE NUMBER The deemed price at which a product is valued, by a tax authority, for tax calculation purposes.
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.
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.
LOAD_REQUEST_ID NUMBER 18 Application-generated number that uniquely identifies the request to create requisitions via cloud interface
REQUESTER_EMAIL_ADDR VARCHAR2 240 Email address of the requester
SUGGESTED_BUYER_EMAIL_ADDR VARCHAR2 240 Email address of the person responsible for placing item resupply orders with suppliers and negotiating supplier contracts.
FIRST_PTY_REG_ID NUMBER 18 A unique sequence of letters and/or numbers assigned to a first party, by a tax authority, when it is registered and by which the first party registration will be identified.
FIRST_PTY_REG_NUMBER VARCHAR2 50 A unique sequence of letters and/or numbers assigned to a first party, by a tax authority, when it is registered and by which the first party registration will be identified.
THIRD_PTY_REG_ID NUMBER 18 A unique sequence of letters and/or numbers assigned to a third party or third party site, by a tax authority, when it is registered and by which the party or party site registration will be identified.
THIRD_PTY_REG_NUMBER VARCHAR2 50 A unique sequence of letters and/or numbers assigned to a third party or third party site, by a tax authority, when it is registered and by which the party or party site registration will be identified.
FINAL_DISCHARGE_LOCATION_ID NUMBER 18 The final destination location for the purchases made by the customer. The location of the final customer or where the goods would be used is not necessarily the same as the initial ship-to location.
FINAL_DISCHARGE_LOC_CODE VARCHAR2 60 The final destination location for the purchases made by the customer. The location of the final customer or where the goods would be used is not necessarily the same as the initial ship-to location.
BACK_TO_BACK_FLAG VARCHAR2 1 Indicates whether a requisition line has a backing sales order that is fulfilled using a back to back order. Y indicates a back to back requisition line. N indicates that the requisition line is not a back to back requisition line.
CARRIER_ID NUMBER 18 A company that transports goods from one point to another by land, sea, or air.
MODE_OF_TRANSPORT VARCHAR2 30 Various modes of transportation used for the movement of goods.
SERVICE_LEVEL VARCHAR2 30 Priority of transportation that affects how quickly goods are transported.
CUSTOMER_ITEM VARCHAR2 25 An alternate key for the internal item used by customers to uniquely identify the item.
CUSTOMER_ITEM_DESC VARCHAR2 240 Description of the item identifier used by customers.
CUSTOMER_PO_NUMBER VARCHAR2 50 Customer PO number on the Sales Order. PO number reference that represents the commercial document that is used to request a seller to supply a product or service in return for payment.
CUSTOMER_PO_LINE_NUMBER VARCHAR2 50 An identifier of the customer PO line record. The customer PO line describes an item or service requested by the end customer.
CUSTOMER_PO_SCHEDULE_NUMBER VARCHAR2 50 An identifier of the customer PO schedule record. The customer PO schedule describes an item or service requested by the end customer.
DELIVER_TO_CUST_ID NUMBER 18 Customer to whom merchandise is being delivered.
DELIVER_TO_CUST_NAME VARCHAR2 360 Name of the customer to whom merchandise is being delivered.
DELIVER_TO_CUST_NUMBER VARCHAR2 30 Number of the customer to whom merchandise is being delivered.
DELIVER_TO_CUST_CONTACT_ID NUMBER 18 Contact from the company where the goods are being delivered.
DELIVER_TO_CUST_CONTACT_NAME VARCHAR2 360 Name of the contact from the company where the goods are being delivered.
DELIVER_TO_CUST_CONTACT_NUMBER VARCHAR2 30 Number of the contact from the company where the goods are being delivered.
DELIVER_TO_CUST_LOCATION_ID NUMBER 18 The final location where goods will be delivered that were previously received from a supplier.
DELIVER_TO_CUST_LOC_SYS_REF VARCHAR2 240 Name of the location in the source system.
DELIVER_TO_CUST_LOC_CLLI_CODE VARCHAR2 60 Unique code to identify the common language location.
DAYS_EARLY_RECEIPT_ALLOWED NUMBER Maximum acceptable number of days early for receipts.
DAYS_LATE_RECEIPT_ALLOWED NUMBER Maximum acceptable number of days late for receipts.
QTY_RCV_TOLERANCE NUMBER Percentage of the quantity that can be received in excess of the designated order quantity.
REQUESTED_SHIP_DATE DATE The original date the customer requested the item ship on.
SALES_ORDER_NUMBER VARCHAR2 50 Backing Sales Order Number
SALES_ORDER_LINE_NUMBER VARCHAR2 50 Backing Sales Order Line Number
SALES_ORDER_SCHEDULE_NUMBER VARCHAR2 50 Backing Sales Order Schedule Number
SHIP_TO_CUST_ID NUMBER 18 Customer to whom merchandise is being sent.
SHIP_TO_CUST_NAME VARCHAR2 360 Name of the customer to whom merchandise is being sent.
SHIP_TO_CUST_NUMBER VARCHAR2 30 Number of the customer to whom merchandise is being sent.
SHIP_TO_CUST_CONTACT_ID NUMBER 18 Contact from the company where the good are shipped
SHIP_TO_CUST_CONTACT_NAME VARCHAR2 360 Name of the Contact from the company where the good are shipped.
SHIP_TO_CUST_CONTACT_NUMBER VARCHAR2 30 Number of the Contact from the company where the good are shipped.
SHIP_TO_CUST_LOCATION_ID NUMBER 18 Location where the supplier should ship the goods.
SHIP_TO_CUST_LOC_SYS_REF VARCHAR2 240 Name of the location in the source system.
SHIP_TO_CUST_LOC_CLLI_CODE VARCHAR2 60 Unique code to identify the common language location.
CONFIGURED_ITEM_FLAG VARCHAR2 1 Indicates that the requisition line is for a configured item and configuration details might exist.
BASE_MODEL_ID NUMBER 18 Indicates the identifier of the part number used by the buying organization to identify the Base/ATO Model on which the unique configuration is built. This part number is defined in PIM.
BASE_MODEL_PRICE NUMBER Indicates the unit price of the base model only.
WORK_ORDER_PRODUCT VARCHAR2 300 Indicates the finished good product of the contract manufacturing work order.
WORK_ORDER_NUMBER VARCHAR2 120 Number of the contract manufacturing work order.
WORK_ORDER_ID NUMBER 18 Unique identifier for the contract manufacturing work order.
WORK_ORDER_OPERATION_SEQ NUMBER Indicates execution sequence of the work order operation.
REQUESTED_DELIVERY_DATE DATE Date by which the requested item is needed
CARRIER VARCHAR2 360 Code of the company that transports goods from one point to another by land, sea, or air.
NOTE_TO_SUPPLIER VARCHAR2 1000 Note to the supplier who will be shipping the item.
ATTACHMENT_CATEGORY_ITEM VARCHAR2 30 Name of the attachment category related to the item.
ATTACHMENT_CATEGORY_SHIP VARCHAR2 30 Name of the attachment category related to shipping instruction.
ATTACHMENT_ENTITY_NAME VARCHAR2 40 Name of the entity from where attachments are retrieved to be stored with the component of the requisition.
ATTACHMENT_PRIMARY_KEY1 VARCHAR2 150 Primary key that identifies the attachment.
ATTACHMENT_PRIMARY_KEY2 VARCHAR2 150 Primary key that identifies the attachment.
ATTACHMENT_PRIMARY_KEY3 VARCHAR2 150 Primary key that identifies the attachment.
ATTACHMENT_PRIMARY_KEY4 VARCHAR2 150 Primary key that identifies the attachment.
ATTACHMENT_PRIMARY_KEY5 VARCHAR2 150 Primary key that identifies the attachment.
ORCHESTRATION_CODE VARCHAR2 20 A code for integrating applications to determine the transactions within Procurement that they need to track. For example, 'SCO', 'DOO', etc.
BASE_MODEL_NUMBER VARCHAR2 300 Part number used by the buying organization to identify the Base/ATO Model on which the unique configuration is built. This part number is defined in PIM.
UNIT_OF_MEASURE VARCHAR2 25 A division of quantity defined as a standard of measurement or exchange.
SECONDARY_UNIT_OF_MEASURE VARCHAR2 25 An alternative unit of measure that is allowed to quantify a dual UOM controlled item.
WORK_ORDER_SUB_TYPE VARCHAR2 30 The display name used to identify the subtype of the manufacturing work order.
WORK_ORDER_OPERATION_ID NUMBER 18 The unique identifier of a work order operation sequence.
RFQ_REQUIRED_FLAG VARCHAR2 1 Indicates whether an RFQ is required prior to placement on a purchase order Obsolete
QTY_UNDER_RCV_TOLERANCE NUMBER The percentage tolerance within which a shipment is automatically closed for receiving. This is referred to as RECEIVE_CLOSE_TOLERANCE in Oracle Fusion Cloud Purchasing Cloud.
FIRM_FLAG VARCHAR2 1 Indicates whether you want to prevent the purchase order for the requisition from being automatically rescheduled by your manufacturing application. Y indicates purchase order is firmed. N indicates purchase order isn't firmed upon.
ALT_SUPPLIER_CONTACT_EMAILS VARCHAR2 2000 Additional emails of supplier contacts provided by the requester. It can have multiple values separated by commas.

Foreign Keys

Table Foreign Table Foreign Key Column
POR_REQ_LINES_INTERFACE_ALL por_req_headers_interface_all REQ_HEADER_INTERFACE_ID
por_req_config_comps_int por_req_lines_interface_all REQ_LINE_INTERFACE_ID
por_req_dists_interface_all por_req_lines_interface_all REQ_LINE_INTERFACE_ID

Indexes

Index Uniqueness Tablespace Columns
POR_REQ_LINES_INTERFACE_N1 Non Unique Default REQ_HEADER_INTERFACE_ID
POR_REQ_LINES_INTERFACE_N2 Non Unique Default PROCESS_FLAG, REQUEST_ID
POR_REQ_LINES_INTERFACE_N3 Non Unique Default LOAD_REQUEST_ID, INTERFACE_LINE_KEY
POR_REQ_LINES_INTERFACE_N4 Non Unique Default INTERFACE_LINE_KEY
POR_REQ_LINES_INTERFACE_N5 Non Unique Default REQUISITION_HEADER_ID
POR_REQ_LINES_INTERFACE_N6 Non Unique Default ITEM_ID, DESTINATION_ORGANIZATION_ID, PROCESS_FLAG
POR_REQ_LINES_INTERFACE_U1 Unique Default REQ_LINE_INTERFACE_ID