1. Tables and Views for Procurement
  2. POR_REQUISITION_LINES_ALL

POR_REQUISITION_LINES_ALL

POR_REQUISITION_LINES stores information about requisition lines. You need one row for each requisition line you create. Each row contains the line number, item number, item category, item description, need-by date, deliver-to location, item quantities, units, prices, requestor, notes, and suggested supplier information for the requisition line. PARENT_REQ_LINE_ID contains the REQUISITION_LINE_ID from the original requisition line if you exploded or multisourced this requisition line. . POR_REQUISITION_LINES is one of three tables storing requisition information. This table corresponds to the Lines 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_LINES_PK

REQUISITION_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
REQUISITION_LINE_ID NUMBER 18 Yes Requisition line unique identifier
ACTION_REQUIRED_CODE VARCHAR2 30 Action required code of the requisition line
INTERFACE_LINE_KEY VARCHAR2 50 Interface Line Key that matches to the column por_req_lines_interface_all.INTERFACE_LINE_KEY
REPRICE_FLAG VARCHAR2 1 Flag to indicate if a transfer supply request can be re-priced by caliing Supply Chain Financial Orchestration.
WORK_ORDER_SUB_TYPE VARCHAR2 30 The display name used to identify the subtype of the manufacturing work order.
REQUISITION_HEADER_ID NUMBER 18 Yes Requisition header unique identifier
LINE_NUMBER NUMBER Yes Line number
LINE_TYPE_ID NUMBER 18 Yes Line type
CATEGORY_ID NUMBER 18 Item category unique identifier
ITEM_DESCRIPTION VARCHAR2 240 Yes Item description
UOM_CODE VARCHAR2 3 Abbreviated Unit of measure
UNIT_PRICE NUMBER Unit price in functional currency
PRICE_VARIANCE_EXCEEDED_FLAG VARCHAR2 1 Yes Flag to indicate whether the punchout requisition line exceeded the price variance check as per the tolerance on the punchout catalog.
PRICE_VARIANCE_EXCEEDED_AMT NUMBER The price variance amount of the requisition line if the punchout item exceeds the price variance check.
QUANTITY NUMBER Quantity ordered
ITEM_ID NUMBER 18 Item unique identifier
ITEM_REVISION VARCHAR2 18 Item revision
QUANTITY_DELIVERED NUMBER Quantity delivered to date
SUGGESTED_BUYER_ID NUMBER 18 Suggested buyer unique identifier
ASSIGNED_BUYER_ID NUMBER 18 Assigned buyer unique identifier
NEGOTIATION_REQUIRED_FLAG VARCHAR2 1 Indicates whether an RFQ is required prior to placement on a purchase order
NEED_BY_DATE DATE Date the requisition is needed internally
PO_HEADER_ID NUMBER 18 Purchase order header unique identifier
PO_LINE_ID NUMBER 18 Purchase order line unique identifier
TO_HEADER_ID NUMBER 18 Transfer order header unique identifier
TO_LINE_ID NUMBER 18 Transfer order line unique identifier
LINE_LOCATION_ID NUMBER 18 Document shipment schedule unique identifier
MODIFIED_BY_BUYER_FLAG VARCHAR2 1 Indicates whether a buyer modified this line or not
PARENT_REQ_LINE_ID NUMBER 18 Unique identifier of the parent requisition line for a modified requisition line
NOTE_TO_BUYER VARCHAR2 1000 Note to buyer
NOTE_TO_RECEIVER VARCHAR2 1000 Note to receiver
MODIFIED_BY_BUYER_ID NUMBER 18 Unique identifier of the buyer who modified the requisition line
SOURCE_DOCUMENT_TYPE VARCHAR2 25 Source document type
SOURCE_DOC_HEADER_ID NUMBER 18 Suggested source blanket agreement or contract header unique identifier
SOURCE_DOC_LINE_ID NUMBER 18 Suggested source blanket agreement line id
CURRENCY_CODE VARCHAR2 15 Unique identifier for the currency
RATE_TYPE VARCHAR2 30 Currency conversion rate type
RATE_DATE DATE Currency conversion rate date
RATE NUMBER Currency conversion rate
CURRENCY_UNIT_PRICE NUMBER Foreign currency unit price
SUGGESTED_VENDOR_NAME VARCHAR2 360 Suggested supplier name
SUGGESTED_VENDOR_SITE VARCHAR2 240 Suggested supplier site name
SUGGESTED_VENDOR_CONTACT VARCHAR2 80 Suggested supplier contact name
SUGGESTED_VENDOR_CONTACT_PHONE VARCHAR2 30 Suggested supplier phone number
SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2 30 Supplier contact fax number
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2 1000 Supplier email contact information
SUGGESTED_SUPPLIER_ITEM_NUMBER VARCHAR2 300 Suggested supplier product number
UN_NUMBER_ID NUMBER 18 UN number unique identifier
HAZARD_CLASS_ID NUMBER 18 Hazard class unique identifier
URGENT_FLAG VARCHAR2 1 Indicates whether the requisition is urgent or not
CANCEL_FLAG VARCHAR2 1 Indicates whether the requisition is cancelled or not
DESTINATION_TYPE_CODE VARCHAR2 25 Destination type
DESTINATION_ORGANIZATION_ID NUMBER 18 Destination organization unique identifier
DESTINATION_SUBINVENTORY VARCHAR2 10 Destination subinventory name
DELIVER_TO_LOCATION_ID NUMBER 18 Deliver-to location unique identifier
ONE_TIME_LOCATION_FLAG VARCHAR2 1 Indicates that the deliver to location of the requisition line is a one-time location
REQUESTER_ID NUMBER 18 Requester unique identifier
QUANTITY_CANCELLED NUMBER Quantity cancelled
CANCEL_DATE DATE Cancel date
CANCEL_REASON VARCHAR2 240 Cancel reason
VENDOR_ID NUMBER 18 Supplier unique identifier
VENDOR_SITE_ID NUMBER 18 Supplier site unique identifier
VENDOR_CONTACT_ID NUMBER 18 Supplier contact unique identifier
QUANTITY_RECEIVED NUMBER Quantity received
REQ_BU_ID NUMBER 18 Yes Business unit unique identifier
PRC_BU_ID NUMBER 18 Business Unit unique identifier of the purchase order to be created
CONTENT_PRC_BU_ID NUMBER 18 Business Unit unique identifier of the content
ITEM_SOURCE VARCHAR2 25 Indicates whether item comes from catalog, noncatalog, quick create, punchout, req import or service.
PUNCHOUT_CATALOG_ID NUMBER 18 Used only for the reference to item sources table
PUBLIC_LIST_ID NUMBER 18 Public List Unique identifier to indicate where the line is added from. Populated if item is added from public list.
SMART_FORM_ID NUMBER 18 Non-Catalog Request template identifier
MANUFACTURER_NAME VARCHAR2 240 Manufacturer name
MANUFACTURER_PART_NUMBER VARCHAR2 700 Manufacturer part number
UNSPSC_CODE VARCHAR2 700 Standard Product and Service Code
SUPPLIER_DUNS VARCHAR2 60 Data Universal Numbering System Code
PCARD_FLAG VARCHAR2 1 Indicator that this line is ordered using a procurement card
NEW_SUPPLIER_FLAG VARCHAR2 1 Indicator that this is a new supplier
NOTE_TO_SUPPLIER VARCHAR2 1000 Note to supplier
SUPPLIER_REF_NUMBER VARCHAR2 150 Reference Number for the Supplier
SECONDARY_UOM_CODE VARCHAR2 3 Abbreviated Secondary unit of measure of the requisition item
SECONDARY_QUANTITY NUMBER Quantity ordered in secondary unit of measure
SECONDARY_QUANTITY_RECEIVED NUMBER Quantity received till date in secondary unit of measure
SECONDARY_QUANTITY_CANCELLED NUMBER Quantity cancelled in secondary unit of measure
INFO_TEMPLATE_TOUCHED_FLAG VARCHAR2 1 INFO_TEMPLATE_TOUCHED_FLAG
ON_RFQ_FLAG VARCHAR2 1 Indicates whether the requisition line was placed on an RFQ
AUCTION_HEADER_ID NUMBER 18 Reference to sourcing auction id
AUCTION_DISPLAY_NUMBER VARCHAR2 40 Reference to sourcing auction number
AUCTION_LINE_NUMBER NUMBER Reference to sourcing auction line number
REQS_IN_POOL_FLAG VARCHAR2 1 Flag to indicate if the requisitions are available for PO creation
BID_NUMBER NUMBER Reference to sourcing bid number
BID_LINE_NUMBER NUMBER Reference to sourcing bid line number
AT_SOURCING_FLAG VARCHAR2 1 Whether or not this requisition line is part of an active sourcing negotiation. If 'Y', the req line is part of an active negotiation in Oracle Sourcing. If 'N' or 'NULL', the requisition line is not part of an active negotation in Oracle Sourcing.
AMOUNT NUMBER Amount on the req line
CURRENCY_AMOUNT NUMBER Foreign currency amount on the req line
ITEM_USER_OVERRIDE_FLAG VARCHAR2 1 Indicates whether item attributes have been updated by the user
BPA_PRICE_USER_OVERRIDE_FLAG VARCHAR2 1 Indicates whether BPA price attribute has been updated by user
ORDER_TYPE_LOOKUP_CODE VARCHAR2 25 Yes Value Basis of the line type
PURCHASE_BASIS VARCHAR2 30 Yes Value Basis of the line type
MATCHING_BASIS VARCHAR2 30 Yes Matching Basis of the line type
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 1 Indicates whether price has been negotiated by buyer
REQTOPO_AUTOMATION_FAILED VARCHAR2 1 REQTOPO_AUTOMATION_FAILED
REQTOPO_AUTO_FAILED_REASON VARCHAR2 30 Reason for Requisition to PO Automation Failure due to functional error
DEFAULT_TAXATION_COUNTRY VARCHAR2 2 Default Taxation Country
DOCUMENT_SUB_TYPE VARCHAR2 240 Document Sub Type
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction Business Category
USER_DEFINED_FISC_CLASS VARCHAR2 240 User Defined Fiscal Classification
TAX_CLASSIFICATION_CODE VARCHAR2 50 Tax Classification Code
PRODUCT_FISC_CLASSIFICATION VARCHAR2 240 Product Fiscal Classification
PRODUCT_FISC_CLASSIFICATION_ID NUMBER 18 Product Fiscal Classification Id
LINE_INTENDED_USE VARCHAR2 240 Intended Use
LINE_INTENDED_USE_ID NUMBER 18 Line Intended Use ID
PRODUCT_TYPE VARCHAR2 240 Product Type
PRODUCT_CATEGORY VARCHAR2 240 Product Category
ASSESSABLE_VALUE NUMBER Assessable Value
TAX_ATTR_USER_OVERRIDE_FLAG VARCHAR2 1 Determine if the tax attributes are overriden by user
BUYER_PROCESSING_FLAG VARCHAR2 1 Indicates if a buyer is currently processing this requisition line.
LINE_GROUP VARCHAR2 30 Used for determing which group filter a requisition line belongs to.
LINE_STATUS VARCHAR2 25 Contains status of the requisition line
FUNDS_STATUS VARCHAR2 30 This attibute captures the budgetary control status for the requisition line.
LAST_SUBMITTED_DATE TIMESTAMP This attribute captures the time when the requisition line is last submitted for approval. It is used to compute the average approval time metric for the items on requisition lines.
LAST_APPROVAL_DATE TIMESTAMP This attribute captures the time when the requisition lines is last approved. It is used to compute the average approval time metric for the items on requisition lines.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP6 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP7 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP8 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP9 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_TIMESTAMP10 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Requisition Lines (POR_REQUISITION_LINES)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 30 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
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.
REQ_PO_INSTANCE_ID NUMBER 18 Used for BPEL flow for req to PO automation
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.
OPTIONS_PRICE NUMBER Indicates the sum of the extended price of all options chosen per unit of the purchased configuration.
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_CONTACT_ID NUMBER 18 Contact from the company where the goods are being delivered.
DELIVER_TO_CUST_LOCATION_ID NUMBER 18 TCA Location unique identifier. The final location where goods will be delivered that were previously received from a supplier. For Structured One-Time Address, this represents the delivery 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_CONTACT_ID NUMBER 18 Contact from the company where the good are shipped
SHIP_TO_CUST_LOCATION_ID NUMBER 18 Location where the supplier should ship the goods.
SOURCE_ORGANIZATION_ID NUMBER 18 Inventory organization which will supply the item to the destination inventory organization in an internal material transfer operation.
SOURCE_SUBINVENTORY VARCHAR2 10 Subinventory within a source inventory organization which will supply the item to the destination inventory organization in an internal material transfer operation.
SOURCE_TYPE_CODE VARCHAR2 10 Yes Indicator of the type of the source of supply for the requisition line. The possible values are Internal for inventory organizations, and External for suppliers.
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.
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.
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.
ORIGINAL_SUBMITTED_DATE TIMESTAMP Date which indicates when the parent requisition line was originally submitted for approval
ORIGINAL_APPROVAL_DATE TIMESTAMP Date which indicates when the parent requisition line was originally approved
REINSTATE_LINE_LOCATION_ID NUMBER 18 This column will track the line location from which the requisition line is reinstated
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.
WORK_ORDER_OPERATION_ID NUMBER 18 The unique identifier of a work order operation sequence.
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.
REQUESTER_SUPERVISOR_LEVEL1 NUMBER 18 Level 1 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL2 NUMBER 18 Level 2 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL3 NUMBER 18 Level 3 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL4 NUMBER 18 Level 4 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL5 NUMBER 18 Level 5 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL6 NUMBER 18 Level 6 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL7 NUMBER 18 Level 7 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL8 NUMBER 18 Level 8 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL9 NUMBER 18 Level 9 supervisor of the requester, where level 1 is the highest management level of the organization.
REQUESTER_SUPERVISOR_LEVEL10 NUMBER 18 Level 10 supervisor of the requester, where level 1 is the highest management level of the organization.
EXTERNAL_UOM_VALUE VARCHAR2 360 External UOM retrieved from punchout cart in case of a punchout line.
EXTERNAL_UOM_QUANTITY VARCHAR2 50 External UOM associated quantity retrieved from punchout cart in case of a punchout line.
EXTERNAL_CATEGORY_VALUE VARCHAR2 360 External Category Value retrieved from punchout cart in case of a punchout line.
DISABLE_AUTOSOURCING_FLAG VARCHAR2 1 Indicates whether the automatic document sourcing is disabled for the requisition line.
RETURNED_BY_BUYER_ID NUMBER 18 Uniquely identifies the Buyer who returned the requisition line
RETURN_REASON VARCHAR2 4000 Reason provided by the buyer while returning the requisition line.
LIFECYCLE_STATUS VARCHAR2 30 Lifecycle status code of the requisition line
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.
LIFECYCLE_SECONDARY_STATUS VARCHAR2 100 Lifecycle secondary status of the requisition line
ALT_SUPPLIER_CONTACT_EMAILS VARCHAR2 2000 Additional emails of supplier contacts provided by the requester. It can have multiple values separated by commas.
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.
BPA_DESC_USER_OVERRIDE_FLAG VARCHAR2 1 Indicates whether BPA description attribute has been updated by user
EPP_LINE_ID NUMBER 18 External Purchase Price Lines Unique Identifier
MARKETPLACE_ITEM_ID VARCHAR2 30 Oracle Healthcare Marketplace Item unique identifier

Foreign Keys

Table Foreign Table Foreign Key Column
POR_REQUISITION_LINES_ALL por_requisition_headers_all REQUISITION_HEADER_ID
rcv_transactions por_requisition_lines_all REQUISITION_LINE_ID
inv_supply por_requisition_lines_all REQ_LINE_ID
pon_award_allocations por_requisition_lines_all ORIG_REQ_LINE_ID
pon_award_allocations por_requisition_lines_all SPLIT_REQ_LINE_ID
rcv_supply por_requisition_lines_all REQ_LINE_ID
rcv_transactions_interface por_requisition_lines_all REQUISITION_LINE_ID
por_one_time_locations por_requisition_lines_all REQUISITION_LINE_ID
pon_backing_req_history por_requisition_lines_all REQUISITION_LINE_ID
por_req_distributions_all por_requisition_lines_all REQUISITION_LINE_ID
por_req_info_template_values por_requisition_lines_all REQUISITION_LINE_ID
pon_award_allocations_history por_requisition_lines_all ORIG_REQ_LINE_ID
pon_award_allocations_history por_requisition_lines_all SPLIT_REQ_LINE_ID
rcv_shipment_lines por_requisition_lines_all REQUISITION_LINE_ID
pon_backing_requisitions por_requisition_lines_all REQUISITION_LINE_ID

Indexes

Index Uniqueness Tablespace Columns Status
POR_REQUISITION_LINES_N1 Non Unique Default LINE_LOCATION_ID
POR_REQUISITION_LINES_N10 Non Unique Default DELIVER_TO_LOCATION_ID
POR_REQUISITION_LINES_N11 Non Unique Default SUGGESTED_SUPPLIER_ITEM_NUMBER
POR_REQUISITION_LINES_N12 Non Unique Default CREATION_DATE, SUGGESTED_BUYER_ID
POR_REQUISITION_LINES_N13 Non Unique Default AUCTION_HEADER_ID, AUCTION_LINE_NUMBER
POR_REQUISITION_LINES_N14 Non Unique Default LAST_UPDATE_DATE
POR_REQUISITION_LINES_N15 Non Unique Default VENDOR_SITE_ID, VENDOR_ID
POR_REQUISITION_LINES_N16 Non Unique Default REQS_IN_POOL_FLAG, SUGGESTED_BUYER_ID Obsolete
POR_REQUISITION_LINES_N17 Non Unique Default AUCTION_DISPLAY_NUMBER, PRC_BU_ID, SUGGESTED_BUYER_ID
POR_REQUISITION_LINES_N18 Non Unique Default PRC_BU_ID, REQS_IN_POOL_FLAG, DESTINATION_TYPE_CODE
POR_REQUISITION_LINES_N19 Non Unique Default REQ_BU_ID
POR_REQUISITION_LINES_N2 Non Unique Default CATEGORY_ID
POR_REQUISITION_LINES_N20 Non Unique Default PO_LINE_ID
POR_REQUISITION_LINES_N21 Non Unique Default PARENT_REQ_LINE_ID
POR_REQUISITION_LINES_N22 Non Unique Default PO_HEADER_ID
POR_REQUISITION_LINES_N23 Non Unique Default REQS_IN_POOL_FLAG, ASSIGNED_BUYER_ID
POR_REQUISITION_LINES_N24 Non Unique Default ASSIGNED_BUYER_ID, LINE_LOCATION_ID, PRC_BU_ID
POR_REQUISITION_LINES_N25 Non Unique Default CREATION_DATE, ASSIGNED_BUYER_ID
POR_REQUISITION_LINES_N26 Non Unique Default AUCTION_DISPLAY_NUMBER, PRC_BU_ID, ASSIGNED_BUYER_ID
POR_REQUISITION_LINES_N27 Non Unique Default TO_HEADER_ID
POR_REQUISITION_LINES_N28 Non Unique Default TO_LINE_ID
POR_REQUISITION_LINES_N29 Non Unique Default REQ_PO_INSTANCE_ID
POR_REQUISITION_LINES_N3 Non Unique Default NEED_BY_DATE
POR_REQUISITION_LINES_N30 Non Unique Default WORK_ORDER_ID, WORK_ORDER_OPERATION_ID, ORCHESTRATION_CODE
POR_REQUISITION_LINES_N31 Non Unique Default VENDOR_ID, REQ_BU_ID, REQUISITION_HEADER_ID
POR_REQUISITION_LINES_N32 Non Unique Default INTERFACE_LINE_KEY
POR_REQUISITION_LINES_N33 Non Unique Default NVL("TO_HEADER_ID","PO_HEADER_ID"), REQUISITION_HEADER_ID
POR_REQUISITION_LINES_N34 Non Unique Default DELIVER_TO_CUST_LOCATION_ID, REQUISITION_HEADER_ID
POR_REQUISITION_LINES_N35 Non Unique POR_REQUISITION_LINES_N35 ACTION_REQUIRED_CODE
POR_REQUISITION_LINES_N36 Non Unique POR_REQUISITION_LINES_N36 REQUISITION_HEADER_ID, LINE_STATUS
POR_REQUISITION_LINES_N37 Non Unique Default NVL("SMART_FORM_ID",(-2))
POR_REQUISITION_LINES_N4 Non Unique Default REQUESTER_ID
POR_REQUISITION_LINES_N5 Non Unique Default SUGGESTED_VENDOR_NAME
POR_REQUISITION_LINES_N6 Non Unique Default SUGGESTED_BUYER_ID, LINE_LOCATION_ID, PRC_BU_ID
POR_REQUISITION_LINES_N7 Non Unique Default ITEM_ID, REQ_BU_ID, REQUISITION_HEADER_ID
POR_REQUISITION_LINES_N8 Non Unique Default SOURCE_DOC_HEADER_ID
POR_REQUISITION_LINES_N9 Non Unique Default DESTINATION_ORGANIZATION_ID
POR_REQUISITION_LINES_U1 Unique Default REQUISITION_LINE_ID
POR_REQUISITION_LINES_U2 Unique Default REQUISITION_HEADER_ID, LINE_NUMBER