[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_REQUISITION_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.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.
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 5 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_REQUISITION_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REQUISITION_LINE_ID
|
| PO_REQUISITION_LINES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
REQUISITION_HEADER_ID
CREATION_DATE
LINE_NUM
|
| PO_REQUISITION_LINES_F1 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NVL("LINE_LOCATION_ID",(-999))
UPPER("ITEM_DESCRIPTION")
|
| PO_REQUISITION_LINES_F2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_DESCRIPTION
|
| PO_REQUISITION_LINES_F3 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NVL("LINE_LOCATION_ID",(-999))
NVL("SUGGESTED_BUYER_ID",(-999))
|
| PO_REQUISITION_LINES_F4 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NVL("LINE_LOCATION_ID",(-999))
|
| PO_REQUISITION_LINES_F5 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NVL("LINE_LOCATION_ID",(-999))
NVL("CLOSED_CODE",'OPEN')
NVL("TRANSFERRED_TO_OE_FLAG",'N')
NVL("CANCEL_FLAG",'N')
|
| PO_REQUISITION_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINE_LOCATION_ID
|
| PO_REQUISITION_LINES_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DELIVER_TO_LOCATION_ID
|
| PO_REQUISITION_LINES_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SUGGESTED_VENDOR_PRODUCT_CODE
|
| PO_REQUISITION_LINES_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
SUGGESTED_BUYER_ID
|
| PO_REQUISITION_LINES_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
KANBAN_CARD_ID
|
| PO_REQUISITION_LINES_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AUCTION_HEADER_ID
AUCTION_LINE_NUMBER
|
| PO_REQUISITION_LINES_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LABOR_REQ_LINE_ID
|
| PO_REQUISITION_LINES_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTRACTOR_STATUS
CONTRACTOR_REQUISITION_FLAG
|
| PO_REQUISITION_LINES_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_UPDATE_DATE
|
| PO_REQUISITION_LINES_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_SITE_ID
VENDOR_ID
|
| PO_REQUISITION_LINES_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQS_IN_POOL_FLAG
SUGGESTED_BUYER_ID
|
| PO_REQUISITION_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CATEGORY_ID
|
| PO_REQUISITION_LINES_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UDA_TEMPLATE_ID
|
| PO_REQUISITION_LINES_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSIGNMENT_NUMBER
|
| PO_REQUISITION_LINES_N22 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
GROUP_LINE_ID
|
| PO_REQUISITION_LINES_N23 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_LINE_ID
|
| PO_REQUISITION_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NEED_BY_DATE
|
| PO_REQUISITION_LINES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TO_PERSON_ID
|
| PO_REQUISITION_LINES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SUGGESTED_VENDOR_NAME
|
| PO_REQUISITION_LINES_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SUGGESTED_BUYER_ID
LINE_LOCATION_ID
|
| PO_REQUISITION_LINES_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_ID
|
| PO_REQUISITION_LINES_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BLANKET_PO_HEADER_ID
|
| PO_REQUISITION_LINES_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WIP_ENTITY_ID
WIP_OPERATION_SEQ_NUM
WIP_RESOURCE_SEQ_NUM
DESTINATION_ORGANIZATION_ID
WIP_REPETITIVE_SCHEDULE_ID
|
| 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 |
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;
PO.PO_REQUISITION_LINES_ALL does not reference any database object
PO.PO_REQUISITION_LINES_ALL is referenced by following:
PO
PO_REQUISITION_LINES_ALL#
|
|
|
|