1. Tables and Views for Procurement
  2. PO_INTAKE_REQUEST_LINES

PO_INTAKE_REQUEST_LINES

Stores individual intake request line details, amounts, items, and fulfillment attributes.

Details

  • Schema: FUSION

  • Object owner: PO

  • Object type: TABLE

  • Tablespace: po_intake_request_lines

Primary Key

Name Columns

PO_INTAKE_REQUEST_LINES_PK

INTAKE_REQUEST_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
INTAKE_REQUEST_ID NUMBER Yes Header identifier to which this intake request line belongs.
INTAKE_REQUEST_LINE_ID NUMBER Yes Unique identifier of the intake request line record.
INTAKE_REQUEST_LINE_NUMBER NUMBER Yes Sequential line number on the intake request document.
DESCRIPTION VARCHAR2 4000 Free-form description entered for the intake request line item.
INVENTORY_ITEM_ID NUMBER 18 Inventory item identifier for the requested product or service.
INVENTORY_ORG_ID NUMBER 18 Inventory organization identifier associated to the inventory item.
CATEGORY_ID NUMBER 18 Purchasing category identifier associated to the line item.
VENDOR_ID NUMBER 18 Supplier identifier associated to this intake request line, if specified.
VENDOR_SITE_ID NUMBER 18 Supplier site identifier associated to this intake request line, if specified.
QUANTITY NUMBER Requested quantity for the line in the specified unit of measure.
UOM_CODE VARCHAR2 3 Unit of measure code that corresponds to the requested quantity.
UNIT_PRICE NUMBER Unit price applied to the requested quantity for this line.
AMOUNT NUMBER Monetary amount calculated or entered for the intake request line.
NEED_BY_DATE DATE Date by which the requested goods or services are required.
PERFORMANCE_START_DATE DATE Service performance start date for the requested line.
PERFORMANCE_END_DATE DATE Service performance end date for the requested line.
DESTINATION_TYPE_CODE VARCHAR2 30 Destination type for fulfillment, such as inventory or expense.
DESTINATION_ORG_ID NUMBER 18 Destination organization identifier used for fulfillment processing.
DELIVER_TO_LOCATION_ID NUMBER 18 Deliver-to location identifier for fulfillment of this line.
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.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.
ITEM_TYPE_CODE VARCHAR2 30 Represents the code for requisition Line types.
NEW_SUPPLIER_FLAG VARCHAR2 1 Flag indicating whether the supplier is new or not.
NEW_SUPPLIER_NAME VARCHAR2 360 Text representing the new supplier name.
NEW_SUPPLIER_ADDRESS VARCHAR2 240 Column to store the new supplier address.
NEW_SUPPLIER_CONTACT VARCHAR2 240 Column to store the new supplier contact information.
NEW_SUPPLIER_EMAIL VARCHAR2 320 Column to store the new supplier email information.
NEW_SUPPLIER_PHONE VARCHAR2 40 Column to store the new supplier phone number.
NEW_SUPPLIER_FAX VARCHAR2 40 Column to store the new supplier fax number.
STATEMENT_OF_WORK CLOB Column to store statement of work text area information.

Indexes

Index Uniqueness Tablespace Columns
PO_INTAKE_REQUEST_LINES_U1 Unique Default INTAKE_REQUEST_LINE_ID
PO_INTAKE_REQUEST_LINES_U2 Unique Default INTAKE_REQUEST_ID, INTAKE_REQUEST_LINE_NUMBER