DBA Data[Home] [Help] [Dependency Information]


TABLE: PO.PO_REQUISITION_LINES_ALL

Object Details
Object Name: PO_REQUISITION_LINES_ALL
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_REQUISITION_LINES_ALL
Subobject Name:
Status: VALID


PO_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.
.
LINE_LOCATION_ID identifies the purchase order shipment line on
which you placed the requisition. LINE_LOCATION_ID is null if you
have not placed the requisition line on a purchase order.
BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested
blanket purchase agreement or catalog quotation line 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.
.
PO_REQUISITION_LINES is one of three tables storing requisition
information. This table corresponds to the Lines region
of the Requisitions window.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_REQUISITION_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUISITION_LINE_ID
PO_REQUISITION_LINES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUISITION_HEADER_ID
ColumnCREATION_DATE
ColumnLINE_NUM
PO_REQUISITION_LINES_F1 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("LINE_LOCATION_ID",(-999))
ColumnUPPER("ITEM_DESCRIPTION")
PO_REQUISITION_LINES_F2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_DESCRIPTION
PO_REQUISITION_LINES_F3 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("LINE_LOCATION_ID",(-999))
ColumnNVL("SUGGESTED_BUYER_ID",(-999))
PO_REQUISITION_LINES_F4 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("LINE_LOCATION_ID",(-999))
PO_REQUISITION_LINES_F5 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNVL("LINE_LOCATION_ID",(-999))
ColumnNVL("CLOSED_CODE",'OPEN')
ColumnNVL("TRANSFERRED_TO_OE_FLAG",'N')
ColumnNVL("CANCEL_FLAG",'N')
PO_REQUISITION_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_LOCATION_ID
PO_REQUISITION_LINES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVER_TO_LOCATION_ID
PO_REQUISITION_LINES_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUGGESTED_VENDOR_PRODUCT_CODE
PO_REQUISITION_LINES_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATION_DATE
ColumnSUGGESTED_BUYER_ID
PO_REQUISITION_LINES_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnKANBAN_CARD_ID
PO_REQUISITION_LINES_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID
ColumnAUCTION_LINE_NUMBER
PO_REQUISITION_LINES_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLABOR_REQ_LINE_ID
PO_REQUISITION_LINES_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTRACTOR_STATUS
ColumnCONTRACTOR_REQUISITION_FLAG
PO_REQUISITION_LINES_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
PO_REQUISITION_LINES_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_SITE_ID
ColumnVENDOR_ID
PO_REQUISITION_LINES_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQS_IN_POOL_FLAG
ColumnSUGGESTED_BUYER_ID
PO_REQUISITION_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCATEGORY_ID
PO_REQUISITION_LINES_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUDA_TEMPLATE_ID
PO_REQUISITION_LINES_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_NUMBER
PO_REQUISITION_LINES_N22 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_LINE_ID
PO_REQUISITION_LINES_N23 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_ID
PO_REQUISITION_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNEED_BY_DATE
PO_REQUISITION_LINES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTO_PERSON_ID
PO_REQUISITION_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUGGESTED_VENDOR_NAME
PO_REQUISITION_LINES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUGGESTED_BUYER_ID
ColumnLINE_LOCATION_ID
PO_REQUISITION_LINES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_ID
PO_REQUISITION_LINES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBLANKET_PO_HEADER_ID
PO_REQUISITION_LINES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnWIP_OPERATION_SEQ_NUM
ColumnWIP_RESOURCE_SEQ_NUM
ColumnDESTINATION_ORGANIZATION_ID
ColumnWIP_REPETITIVE_SCHEDULE_ID
Columns
Name Datatype Length Mandatory Comments
REQUISITION_LINE_ID NUMBER
Yes Requisition line unique identifier
REQUISITION_HEADER_ID NUMBER
Yes Requisition header unique identifier
LINE_NUM NUMBER
Yes Line number
LINE_TYPE_ID NUMBER
Yes Line type
CATEGORY_ID NUMBER

Item category unique identifier
ITEM_DESCRIPTION VARCHAR2 (240) Yes Item description
UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
Unit of measure
UNIT_PRICE NUMBER

Unit price in functional currency
QUANTITY NUMBER

Quantity ordered
DELIVER_TO_LOCATION_ID NUMBER

Deliver-to location unique identifier
TO_PERSON_ID NUMBER (9) Yes Requester unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SOURCE_TYPE_CODE VARCHAR2 (25) Yes Requisition source type of item
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).
ITEM_ID NUMBER

Item unique identifier
ITEM_REVISION VARCHAR2 (3)
Item revision
QUANTITY_DELIVERED NUMBER

Quantity delivered to date
SUGGESTED_BUYER_ID NUMBER (9)
Suggested buyer unique identifier
ENCUMBERED_FLAG VARCHAR2 (1)
Indicates whether the distribution is encumbered. When encumbrance is not enabled, this column will be used as an internal flag.
RFQ_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
LINE_LOCATION_ID NUMBER

Document shipment schedule unique identifier
MODIFIED_BY_AGENT_FLAG VARCHAR2 (1)
Indicates whether a buyer modified this line or not
PARENT_REQ_LINE_ID NUMBER

Unique identifier of the parent requisition line for a modified requisition line
JUSTIFICATION VARCHAR2 (480)
Purchase justification
NOTE_TO_AGENT VARCHAR2 (480)
Note to buyer
NOTE_TO_RECEIVER VARCHAR2 (480)
Note to deliverer
PURCHASING_AGENT_ID NUMBER (9)
Unique identifier of the buyer who modified the requisition line
DOCUMENT_TYPE_CODE VARCHAR2 (25)
Source document type
BLANKET_PO_HEADER_ID NUMBER

Suggested source blanket agreement or catalog quotation header unique identifier
BLANKET_PO_LINE_NUM NUMBER

Suggested source blanket agreement or catalog quotation line number
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 (240)
Suggested supplier name
SUGGESTED_VENDOR_LOCATION VARCHAR2 (240)
Suggested supplier site name
SUGGESTED_VENDOR_CONTACT VARCHAR2 (80)
Suggested supplier contact name
SUGGESTED_VENDOR_PHONE VARCHAR2 (25)
Suggested supplier phone number
SUGGESTED_VENDOR_PRODUCT_CODE VARCHAR2 (25)
Suggested supplier product number
UN_NUMBER_ID NUMBER

UN number unique identifier
HAZARD_CLASS_ID NUMBER

Hazard class unique identifier
MUST_USE_SUGG_VENDOR_FLAG VARCHAR2 (1)
Unused since release 8.0
REFERENCE_NUM VARCHAR2 (25)
Reference number
ON_RFQ_FLAG VARCHAR2 (1)
Indicates whether the requisition line was placed on an RFQ
URGENT_FLAG VARCHAR2 (1)
Indicates whether the requisition is urgent or not
CANCEL_FLAG VARCHAR2 (1)
Indicates whether the requisition is cancelled or not
SOURCE_ORGANIZATION_ID NUMBER

Inventory source organization unique identifier
SOURCE_SUBINVENTORY VARCHAR2 (10)
Inventory source subinventory name
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type
DESTINATION_ORGANIZATION_ID NUMBER

Destination organization unique identifier
DESTINATION_SUBINVENTORY VARCHAR2 (10)
Destination subinventory name
QUANTITY_CANCELLED NUMBER

Quantity cancelled
CANCEL_DATE DATE

Cancel date
CANCEL_REASON VARCHAR2 (240)
Cancel reason
CLOSED_CODE VARCHAR2 (25)
Close status
AGENT_RETURN_NOTE VARCHAR2 (480)
Unused since release 7.0
CHANGED_AFTER_RESEARCH_FLAG VARCHAR2 (1)
Unused since release 7.0
VENDOR_ID NUMBER

Supplier unique identifier
VENDOR_SITE_ID NUMBER

Supplier site unique identifier
VENDOR_CONTACT_ID NUMBER

Supplier contact unique identifier
RESEARCH_AGENT_ID NUMBER (9)
Unused since release 7.0
ON_LINE_FLAG VARCHAR2 (1)
Unused since release 7.0
WIP_ENTITY_ID NUMBER

WIP job or repetitive assembly identifier
WIP_LINE_ID NUMBER

WIP line identifier
WIP_REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule identifier
WIP_OPERATION_SEQ_NUM NUMBER

WIP operation sequence number within a routing
WIP_RESOURCE_SEQ_NUM NUMBER

WIP resource sequence number
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
DESTINATION_CONTEXT VARCHAR2 (30)
Destination descriptive flexfield context column
INVENTORY_SOURCE_CONTEXT VARCHAR2 (30)
Inventory source descriptive flexfield context column
VENDOR_SOURCE_CONTEXT VARCHAR2 (30)
Supplier source descriptive flexfield context column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
BOM_RESOURCE_ID NUMBER

BOM resource unique identifier
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_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_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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
GOVERNMENT_CONTEXT VARCHAR2 (30)
USSGL descriptive flexfield context column
CLOSED_REASON VARCHAR2 (240)
Close reason
CLOSED_DATE DATE

Close date
TRANSACTION_REASON_CODE VARCHAR2 (25)
Transaction reason
QUANTITY_RECEIVED NUMBER

Quantity received
SOURCE_REQ_LINE_ID NUMBER

Source requisition line identifier
ORG_ID NUMBER

Organization identifier
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
KANBAN_CARD_ID NUMBER

Primary key for the Kanban Card
CATALOG_TYPE VARCHAR2 (30)
Catalog type
CATALOG_SOURCE VARCHAR2 (30)
Catalog source
MANUFACTURER_ID NUMBER

Manufacturer unique identifier
MANUFACTURER_NAME VARCHAR2 (240)
Manufacturer name
MANUFACTURER_PART_NUMBER VARCHAR2 (150)
Manufacturer part number
REQUESTER_EMAIL VARCHAR2 (240)
Requester e-mail address
REQUESTER_FAX VARCHAR2 (60)
Requester facsimile number
REQUESTER_PHONE VARCHAR2 (60)
Requester phone number
UNSPSC_CODE VARCHAR2 (30)
Standard Product and Service Code
OTHER_CATEGORY_CODE VARCHAR2 (30)
Other category code
SUPPLIER_DUNS VARCHAR2 (60)
Data Universal Numbering System Code
TAX_STATUS_INDICATOR VARCHAR2 (30)
Tax status
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
AUTO_RECEIVE_FLAG VARCHAR2 (1)
Allow auto-receiving
TAX_USER_OVERRIDE_FLAG VARCHAR2 (1)
Indicator of whether someone overrode the default tax
TAX_CODE_ID NUMBER

Unique identifier for the tax code
NOTE_TO_VENDOR VARCHAR2 (480)
Note to supplier
OKE_CONTRACT_VERSION_ID NUMBER

Stores the contract version number
OKE_CONTRACT_HEADER_ID NUMBER

Stores the header id of a contract
ITEM_SOURCE_ID NUMBER

Used only for the reference to item sources table
SUPPLIER_REF_NUMBER VARCHAR2 (150)
Reference Number for the Supplier
SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
Secondary unit of measure of the requisition item
SECONDARY_QUANTITY NUMBER

Quantity ordered in secondary unit of measure
PREFERRED_GRADE VARCHAR2 (150)
Preferred quality grade of the item ordered
SECONDARY_QUANTITY_RECEIVED NUMBER

Quantity received till date in secondary unit of measure
SECONDARY_QUANTITY_CANCELLED NUMBER

Quantity cancelled in secondary unit of measure
VMI_FLAG VARCHAR2 (1)
Indicates VMI requisition with value = 'Y'
AUCTION_HEADER_ID NUMBER

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
NONCAT_TEMPLATE_ID NUMBER

Non-Catalog Request template identifier
SUGGESTED_VENDOR_CONTACT_FAX VARCHAR2 (25)
Supplier contact fax number
SUGGESTED_VENDOR_CONTACT_EMAIL VARCHAR2 (2000)
Supplier email contact information
AMOUNT NUMBER

Amount on the req line
CURRENCY_AMOUNT NUMBER

Foreign currency amount on the req line
LABOR_REQ_LINE_ID NUMBER

Stored the referenced temp labor requisition line id for an expence line
JOB_ID NUMBER

Reference to the HR Job
JOB_LONG_DESCRIPTION VARCHAR2 (2000)
Job Detailed Description
CONTRACTOR_STATUS VARCHAR2 (25)
Resource finalization status for temp labor req lines
CONTACT_INFORMATION VARCHAR2 (240)
Job Contact Information
SUGGESTED_SUPPLIER_FLAG VARCHAR2 (1)
Flag to indicate if the supplier is from an ASL or user suggested
CANDIDATE_SCREENING_REQD_FLAG VARCHAR2 (1)
Flag to indicate if candidate screening is required
CANDIDATE_FIRST_NAME VARCHAR2 (240)
First Name of the Candidate
CANDIDATE_LAST_NAME VARCHAR2 (240)
Last Name of the Candidate
ASSIGNMENT_END_DATE DATE

End date for the candidate assignment
OVERTIME_ALLOWED_FLAG VARCHAR2 (1)
Flag to indicate if overtime is allowed
CONTRACTOR_REQUISITION_FLAG VARCHAR2 (1)
Indicates if the req is a temp labor req
DROP_SHIP_FLAG VARCHAR2 (1)
Indicates whether the Shipment has a backing Sales Order Line.
ASSIGNMENT_START_DATE DATE

Assignment start date for the candidate
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
SHIP_METHOD VARCHAR2 (30)
Ship method (References WSH_CARRIER_SERVICES.ship_method_code.)
ESTIMATED_PICKUP_DATE DATE

Estimated pickup date.
SUPPLIER_NOTIFIED_FOR_CANCEL VARCHAR2 (1)
Indicates whether a cancellation notification has been sent to the supplier for this requisition line.
BASE_UNIT_PRICE NUMBER

Base Unit Price
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.
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
Keeps track of create/update actions on this entity
TAX_NAME VARCHAR2 (30)
Tax Name
TRANSFERRED_TO_OE_FLAG VARCHAR2 (1)
Indicates whether an internal requisition line has been transferred to order management
CONFORMED_LINE_ID NUMBER

Populated only for Amendment records and stores the requisition_line_id of the parent requisition line
AMENDMENT_TYPE VARCHAR2 (30)
Used for PR Amendment and shows the type of change. Possible values are ADDED, CHANGED, CANCELLED
AMENDMENT_STATUS VARCHAR2 (3)
Used for PR Amendment and stores the amendment status. Possible values are N - New, A - Accepted, R - Rejected, P - Pending
LINE_NUM_DISPLAY VARCHAR2 (100)
Stores the line number for federal requisitions
GROUP_LINE_ID NUMBER

Stores the requisition_line_id of the CLIN
CLM_INFO_FLAG VARCHAR2 (1)
States whether this is an informational line
CLM_OPTION_INDICATOR VARCHAR2 (1)
States whether this is an optional line
CLM_BASE_LINE_NUM NUMBER

Stores the requisition_line_id of the base line and is populated only for optional line
CLM_OPTION_NUM NUMBER

Stores the option line number
CLM_OPTION_FROM_DATE DATE

Stores the option start date
CLM_OPTION_TO_DATE DATE

Stores the option end date
CLM_FUNDED_FLAG VARCHAR2 (1)
States whether this is a funded line or not.
UDA_TEMPLATE_ID NUMBER

Uda Template Id
CONTRACT_TYPE VARCHAR2 (100)
Contract Type for Complex Pricing
COST_CONSTRAINT VARCHAR2 (100)
Cost Constraint for Complex Pricing
AMENDMENT_RESPONSE_REASON VARCHAR2 (2000)
Stores the reason for the amendment changes when it gets accepted or rejected
CLM_PERIOD_PERF_START_DATE DATE

The Start date for CLM period performance.
CLM_PERIOD_PERF_END_DATE DATE

The End date for CLM period performance.
CLM_EXTENDED_ITEM_DESCRIPTION VARCHAR2 (4000)
Extended Item Description.
CLM_OPTION_EXERCISED VARCHAR2 (1)
States whether the option line is exercised.
IS_LINE_NUM_DISPLAY_MODIFIED VARCHAR2 (1)
Stores whether the line num display is modified by user manually.
ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment Number
PO_DRAFT_ID NUMBER

po_draft_id of the modification
PO_LINE_ID NUMBER

po_Line_id in the modification
CLM_EXERCISED_DATE DATE

Date When optiion line is exercised.
LINKED_TO_FUND VARCHAR2 (1)
Indicates whether the line is only used to add funds
FUND_SOURCE_NOT_KNOWN VARCHAR2 (1)
This column indicates if the requisition line has distributions or not
LINKED_PO_COUNT NUMBER

Linked PO Count
CLM_MIPR_OBLIGATION_TYPE VARCHAR2 (30)
PAR_DRAFT_ID NUMBER

PAR_LINE_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUISITION_LINE_ID
,      REQUISITION_HEADER_ID
,      LINE_NUM
,      LINE_TYPE_ID
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_PRICE
,      QUANTITY
,      DELIVER_TO_LOCATION_ID
,      TO_PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SOURCE_TYPE_CODE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ITEM_ID
,      ITEM_REVISION
,      QUANTITY_DELIVERED
,      SUGGESTED_BUYER_ID
,      ENCUMBERED_FLAG
,      RFQ_REQUIRED_FLAG
,      NEED_BY_DATE
,      LINE_LOCATION_ID
,      MODIFIED_BY_AGENT_FLAG
,      PARENT_REQ_LINE_ID
,      JUSTIFICATION
,      NOTE_TO_AGENT
,      NOTE_TO_RECEIVER
,      PURCHASING_AGENT_ID
,      DOCUMENT_TYPE_CODE
,      BLANKET_PO_HEADER_ID
,      BLANKET_PO_LINE_NUM
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      CURRENCY_UNIT_PRICE
,      SUGGESTED_VENDOR_NAME
,      SUGGESTED_VENDOR_LOCATION
,      SUGGESTED_VENDOR_CONTACT
,      SUGGESTED_VENDOR_PHONE
,      SUGGESTED_VENDOR_PRODUCT_CODE
,      UN_NUMBER_ID
,      HAZARD_CLASS_ID
,      MUST_USE_SUGG_VENDOR_FLAG
,      REFERENCE_NUM
,      ON_RFQ_FLAG
,      URGENT_FLAG
,      CANCEL_FLAG
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      DESTINATION_TYPE_CODE
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      QUANTITY_CANCELLED
,      CANCEL_DATE
,      CANCEL_REASON
,      CLOSED_CODE
,      AGENT_RETURN_NOTE
,      CHANGED_AFTER_RESEARCH_FLAG
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      RESEARCH_AGENT_ID
,      ON_LINE_FLAG
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      ATTRIBUTE_CATEGORY
,      DESTINATION_CONTEXT
,      INVENTORY_SOURCE_CONTEXT
,      VENDOR_SOURCE_CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BOM_RESOURCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      CLOSED_REASON
,      CLOSED_DATE
,      TRANSACTION_REASON_CODE
,      QUANTITY_RECEIVED
,      SOURCE_REQ_LINE_ID
,      ORG_ID
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      KANBAN_CARD_ID
,      CATALOG_TYPE
,      CATALOG_SOURCE
,      MANUFACTURER_ID
,      MANUFACTURER_NAME
,      MANUFACTURER_PART_NUMBER
,      REQUESTER_EMAIL
,      REQUESTER_FAX
,      REQUESTER_PHONE
,      UNSPSC_CODE
,      OTHER_CATEGORY_CODE
,      SUPPLIER_DUNS
,      TAX_STATUS_INDICATOR
,      PCARD_FLAG
,      NEW_SUPPLIER_FLAG
,      AUTO_RECEIVE_FLAG
,      TAX_USER_OVERRIDE_FLAG
,      TAX_CODE_ID
,      NOTE_TO_VENDOR
,      OKE_CONTRACT_VERSION_ID
,      OKE_CONTRACT_HEADER_ID
,      ITEM_SOURCE_ID
,      SUPPLIER_REF_NUMBER
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_QUANTITY
,      PREFERRED_GRADE
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_QUANTITY_CANCELLED
,      VMI_FLAG
,      AUCTION_HEADER_ID
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_LINE_NUMBER
,      REQS_IN_POOL_FLAG
,      BID_NUMBER
,      BID_LINE_NUMBER
,      NONCAT_TEMPLATE_ID
,      SUGGESTED_VENDOR_CONTACT_FAX
,      SUGGESTED_VENDOR_CONTACT_EMAIL
,      AMOUNT
,      CURRENCY_AMOUNT
,      LABOR_REQ_LINE_ID
,      JOB_ID
,      JOB_LONG_DESCRIPTION
,      CONTRACTOR_STATUS
,      CONTACT_INFORMATION
,      SUGGESTED_SUPPLIER_FLAG
,      CANDIDATE_SCREENING_REQD_FLAG
,      CANDIDATE_FIRST_NAME
,      CANDIDATE_LAST_NAME
,      ASSIGNMENT_END_DATE
,      OVERTIME_ALLOWED_FLAG
,      CONTRACTOR_REQUISITION_FLAG
,      DROP_SHIP_FLAG
,      ASSIGNMENT_START_DATE
,      ORDER_TYPE_LOOKUP_CODE
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      NEGOTIATED_BY_PREPARER_FLAG
,      SHIP_METHOD
,      ESTIMATED_PICKUP_DATE
,      SUPPLIER_NOTIFIED_FOR_CANCEL
,      BASE_UNIT_PRICE
,      AT_SOURCING_FLAG
,      TAX_ATTRIBUTE_UPDATE_CODE
,      TAX_NAME
,      TRANSFERRED_TO_OE_FLAG
,      CONFORMED_LINE_ID
,      AMENDMENT_TYPE
,      AMENDMENT_STATUS
,      LINE_NUM_DISPLAY
,      GROUP_LINE_ID
,      CLM_INFO_FLAG
,      CLM_OPTION_INDICATOR
,      CLM_BASE_LINE_NUM
,      CLM_OPTION_NUM
,      CLM_OPTION_FROM_DATE
,      CLM_OPTION_TO_DATE
,      CLM_FUNDED_FLAG
,      UDA_TEMPLATE_ID
,      CONTRACT_TYPE
,      COST_CONSTRAINT
,      AMENDMENT_RESPONSE_REASON
,      CLM_PERIOD_PERF_START_DATE
,      CLM_PERIOD_PERF_END_DATE
,      CLM_EXTENDED_ITEM_DESCRIPTION
,      CLM_OPTION_EXERCISED
,      IS_LINE_NUM_DISPLAY_MODIFIED
,      ASSIGNMENT_NUMBER
,      PO_DRAFT_ID
,      PO_LINE_ID
,      CLM_EXERCISED_DATE
,      LINKED_TO_FUND
,      FUND_SOURCE_NOT_KNOWN
,      LINKED_PO_COUNT
,      CLM_MIPR_OBLIGATION_TYPE
,      PAR_DRAFT_ID
,      PAR_LINE_ID
FROM PO.PO_REQUISITION_LINES_ALL;

Dependencies

[top of page]

PO.PO_REQUISITION_LINES_ALL does not reference any database object

PO.PO_REQUISITION_LINES_ALL is referenced by following:

SchemaPO
ViewPO_REQUISITION_LINES_ALL#