[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
PO_LINES_ALL stores current information about each purchase order
line. You need one row for each line you attach to a document. There
are five document types that use lines:
.
{{"bul:1"}}RFQs
.
{{"bul:1"}}Quotations
.
{{"bul:1"}}Standard purchase orders
.
{{"bul:1"}}Blanket purchase orders
.
{{"bul:1"}}Planned purchase orders
.
{{"bodytext"}}Each row includes the line number, the item number and
category, unit, price, tax information, matching information, and
quantity ordered for the line. Oracle Purchasing uses this information
to record and update item and price information for purchase orders,
quotations, and RFQs.
.
PO_LINE_ID is the unique system-generated line number invisible to the
user. LINE_NUM is the number of the line on the purchase order.
Oracle Purchasing uses CONTRACT_ID to reference a contract purchase
order from a standard purchase order line. Oracle Purchasing uses
ALLOW_PRICE_OVERRIDE_FLAG, COMMITTED_AMOUNT, QUANTITY_COMMITTED,
MIN_RELEASE_AMOUNT only for blanket and planned purchase order lines.
.
The QUANTITY field stores the total quantity of all purchase order
shipment lines (found in PO_LINE_LOCATIONS_ALL).
.
.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PO_LINE_ID
|
| PO_LINES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PO_HEADER_ID
LINE_NUM
|
| PO_LINES_F1 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UPPER("ITEM_DESCRIPTION")
|
| PO_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_ID
|
| PO_LINES_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_UPDATE_DATE
|
| PO_LINES_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTRACT_ID
|
| PO_LINES_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
JOB_ID
|
| PO_LINES_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FROM_HEADER_ID
|
| PO_LINES_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
IP_CATEGORY_ID
|
| PO_LINES_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UDA_TEMPLATE_ID
|
| PO_LINES_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_HEADER_ID
VENDOR_PRODUCT_NUM
|
| PO_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| PO_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CATEGORY_ID
|
| PO_LINES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FROM_LINE_ID
|
| PO_LINES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_DESCRIPTION
|
| PO_LINES_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_PRODUCT_NUM
|
| PO_LINES_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONTRACT_NUM
|
| PO_LINES_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLOSED_BY
|
| PO_LINES_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CANCELLED_BY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_LINE_ID | NUMBER | Yes | Document line 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). | |
| PO_HEADER_ID | NUMBER | Yes | Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.) | |
| LINE_TYPE_ID | NUMBER | Line type unique identifier (References PO_LINE_TYPES_B.line_type_id.) | ||
| LINE_NUM | NUMBER | Yes | Line number | |
| 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. (References MTL_SYSTEM_ITEMS_B.inventory_item_id.) | ||
| ITEM_REVISION | VARCHAR2 | (3) | Item revision. (References MTL_ITEM_REVISIONS_B.revision.) | |
| CATEGORY_ID | NUMBER | Item category unique identifier. (References MTL_CATEGORIES_B.category_id.) | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description. (Defaulted from MTL_SYSTEM_ITEMS_TL.description.) | |
| UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure for the quantity ordered. (References MTL_UNITS_OF_MEASURE.unit_of_measure.) | |
| QUANTITY_COMMITTED | NUMBER | Blankets only: Quantity agreed for an agreement line | ||
| COMMITTED_AMOUNT | NUMBER | Blankets only: Amount agreed for an agreement line | ||
| ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | (1) | Blankets or planned POs only: Indicates whether you can change the price on release shipments | |
| NOT_TO_EXCEED_PRICE | NUMBER | Blankets or planned POs only: Price limit that you cannot exceed on a release shipment | ||
| LIST_PRICE_PER_UNIT | NUMBER | List price for the item on the line. (Defaulted from MTL_SYSTEM_ITEMS_B.list_price_per_unit.) | ||
| UNIT_PRICE | NUMBER | Unit price for the line. (Defaulted from MTL_SYSTEM_ITEMS_B.list_price_per_unit, converted to the document's currency.) | ||
| QUANTITY | NUMBER | Quantity ordered on the line | ||
| UN_NUMBER_ID | NUMBER | UN number unique identifier. (References PO_UN_NUMBERS_B.un_number_id.) | ||
| HAZARD_CLASS_ID | NUMBER | Hazard class unique identifier. (References PO_HAZARD_CLASSES_B.hazard_class_id.) | ||
| NOTE_TO_VENDOR | VARCHAR2 | (480) | Short note to supplier | |
| FROM_HEADER_ID | NUMBER | Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line. (References PO_HEADERS_ALL.po_header_id.) | ||
| FROM_LINE_ID | NUMBER | Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line. (References PO_LINES_ALL.po_line_id.) | ||
| MIN_ORDER_QUANTITY | NUMBER | Quotations only: Minimum order quantity for a quotation line | ||
| MAX_ORDER_QUANTITY | NUMBER | Quotations only: Maximum order quantity for a quotation line | ||
| QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | ||
| OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | (25) | Indicates whether or not you reject receipts exceeding the tolerance | |
| MARKET_PRICE | NUMBER | Market price for the item on the line. (Defaulted from MTL_SYSTEM_ITEMS_B.market_price.) | ||
| UNORDERED_FLAG | VARCHAR2 | (1) | Indicates whether or not the line was created from unordered receipts | |
| CLOSED_FLAG | VARCHAR2 | (1) | Indicates whether the line is closed or not | |
| USER_HOLD_FLAG | VARCHAR2 | (1) | Indicates whether the line is on hold or not (Unused since release version 5.0) | |
| CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether the line is cancelled or not | |
| CANCELLED_BY | NUMBER | (9) | Unique identifier of the employee who cancelled the line. (References HR_EMPLOYEES.employee_id.) | |
| CANCEL_DATE | DATE | Cancellation date | ||
| CANCEL_REASON | VARCHAR2 | (240) | Cancellation reason provided by employee | |
| FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | (30) | Firming status of the line (Unused since release version 7.0) | |
| FIRM_DATE | DATE | Date the line becomes firmed (Unused since release version 7.0) | ||
| VENDOR_PRODUCT_NUM | VARCHAR2 | (25) | Supplier item number | |
| CONTRACT_NUM | VARCHAR2 | (25) | Contract number referenced on the line. (Obsoleted in PO FPJ 11.5.10 - use CONTRACT_ID instead.) | |
| TAXABLE_FLAG | VARCHAR2 | (1) | Indicates whether the document line is taxable or not | |
| TAX_NAME | VARCHAR2 | (30) | Tax code applying to the line. (References AP_TAX_CODES_ALL.name.) | |
| TYPE_1099 | VARCHAR2 | (10) | 1099 type for the purchase order line | |
| CAPITAL_EXPENSE_FLAG | VARCHAR2 | (1) | Indicates whether the line is for a capital expense or not | |
| NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | Indicates whether the buyer negotiated the price or not | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition 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 | |
| REFERENCE_NUM | VARCHAR2 | (25) | Reference number (Unused since release version 7.0) | |
| 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 | |
| MIN_RELEASE_AMOUNT | NUMBER | Blankets or planned POs only: Minimum amount that can be released against a planned or blanket agreement line. | ||
| PRICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Price type of the line. (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='PRICE TYPE'.) | |
| CLOSED_CODE | VARCHAR2 | (25) | Describes closure status of the line | |
| PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | (25) | Blankets only: Pricing scheme for the price breaks of this line (cumulative or non-cumulative). | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code. (References GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE.) | |
| GOVERNMENT_CONTEXT | VARCHAR2 | (30) | USSGL descriptive flexfield context column | |
| 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). | ||
| CLOSED_DATE | DATE | Date the line is closed | ||
| CLOSED_REASON | VARCHAR2 | (240) | Describes why the line is closed | |
| CLOSED_BY | NUMBER | (9) | Unique identifier of the employee who closed the line. (References HR_EMPLOYEES.employee_id.) | |
| TRANSACTION_REASON_CODE | VARCHAR2 | (25) | Transaction reason. (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='TRANSACTION REASON'.) | |
| ORG_ID | NUMBER | Organization identifier | ||
| QC_GRADE | VARCHAR2 | (25) | OPM: Stores the quality control grade wanted on the purchase order line | |
| BASE_UOM | VARCHAR2 | (25) | OPM: Stores the base unit of measure (UOM) for the item ordered | |
| BASE_QTY | NUMBER | OPM: Ordered quantity converted from transaction UOM to base UOM | ||
| SECONDARY_UOM | VARCHAR2 | (25) | OPM: Stores the dual unit of measure for the item ordered | |
| SECONDARY_QTY | NUMBER | OPM: Converted quantity from BASE UOM to DUAL UOM for the item ordered | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| 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 | |
| LINE_REFERENCE_NUM | VARCHAR2 | (25) | Audit Trail Reference (needed for 832 EDI transaction) | |
| PROJECT_ID | NUMBER | Project accounting project unique identifier. (References PA_PROJECTS_ALL.project_id or PJM_SEIBAN_NUMBERS.project_id.) | ||
| TASK_ID | NUMBER | Project accounting task unique identifier. (References PA_TASKS.task_id.) | ||
| EXPIRATION_DATE | DATE | Blanket, quotation, or RFQ only: Date after which the item on this catalog line can no longer be ordered | ||
| TAX_CODE_ID | NUMBER | Unique identifier for the tax code. (References AP_TAX_CODES.tax_id.) | ||
| OKE_CONTRACT_HEADER_ID | NUMBER | Contract identifier from Oracle Contracts. (References OKC_K_HEADERS_B.id.) | ||
| OKE_CONTRACT_VERSION_ID | NUMBER | Version identifier for contract. | ||
| SECONDARY_QUANTITY | NUMBER | OPM: Secondary Quantity ordered on the line | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | OPM: Secondary unit of measure for the quantity ordered | |
| PREFERRED_GRADE | VARCHAR2 | (150) | Preferred quality grade for the item ordered | |
| AUCTION_HEADER_ID | NUMBER | Reference to the negotiation id in sourcing. (References PON_AUCTION_HEADERS_ALL.auction_header_id.) | ||
| AUCTION_DISPLAY_NUMBER | VARCHAR2 | (40) | Reference to the negotiation number in sourcing | |
| AUCTION_LINE_NUMBER | NUMBER | Reference to the negotiation line number in Sourcing | ||
| BID_NUMBER | NUMBER | Reference to the bid number in sourcing | ||
| BID_LINE_NUMBER | NUMBER | Reference to the Bid line in sourcing | ||
| RETROACTIVE_DATE | DATE | Column used to store the timestamp of a retroactive price change | ||
| FROM_LINE_LOCATION_ID | NUMBER | Unique identifier of the Price Break (standard POs only) referenced by this line. (References PO_LINE_LOCATIONS_ALL.line_location_id.) | ||
| SUPPLIER_REF_NUMBER | VARCHAR2 | (150) | Tracking code for a specific configuration of an item. Generated by a configuration engine maintained by suppliers. | |
| CONTRACT_ID | NUMBER | Standard POs only: Contract PA reference of a line. (References PO_HEADERS_ALL.po_header_id.) | ||
| START_DATE | DATE | Assignment start Date for the contingent worker | ||
| AMOUNT | NUMBER | Budget Amout for temp labor standard PO lines | ||
| JOB_ID | NUMBER | Stores the HR Job identifier | ||
| CONTRACTOR_FIRST_NAME | VARCHAR2 | (240) | First name of the contingent worker | |
| CONTRACTOR_LAST_NAME | VARCHAR2 | (240) | Last name of the contingent worker | |
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Value basis of the line | |
| PURCHASE_BASIS | VARCHAR2 | (30) | Purchase basis of the line type | |
| MATCHING_BASIS | VARCHAR2 | (30) | Matching basis of the line type | |
| SVC_AMOUNT_NOTIF_SENT | VARCHAR2 | (1) | Temp Labor lines (i.e. PURCHASE_BASIS='TEMP LABOR') on Standard POs only: Y if an Amount Billed Approaching Budget reminder notification has been sent for this line, NULL otherwise. | |
| SVC_COMPLETION_NOTIF_SENT | VARCHAR2 | (1) | Temp Labor lines (i.e. PURCHASE_BASIS='TEMP LABOR') on Standard POs only: Y if a Contractor Assignment Nearing Completion reminder notification has been sent for this line, NULL otherwise. | |
| BASE_UNIT_PRICE | NUMBER | Base Unit Price | ||
| MANUAL_PRICE_CHANGE_FLAG | VARCHAR2 | (1) | Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise. | |
| RETAINAGE_RATE | NUMBER | Maximum percentage that can be withheld from an invoice as Retainage | ||
| MAX_RETAINAGE_AMOUNT | NUMBER | The maximum amount that can be withheld as Retainage against a contract line | ||
| PROGRESS_PAYMENT_RATE | NUMBER | Percentage applied to the completed work on a financing Pay Item to determine the amount eligible for payment | ||
| RECOUPMENT_RATE | NUMBER | Maximum percentage of the invoice amount against which previous prepayments can be applied | ||
| CATALOG_NAME | VARCHAR2 | (255) | This is to support the replacement of catalogs for CIF format | |
| SUPPLIER_PART_AUXID | VARCHAR2 | (255) | Supplier Part Auxiliary Id | |
| IP_CATEGORY_ID | NUMBER | IP Category Id for GBPA Lines (-2 stored for null values) | ||
| TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | (15) | Keeps track of create/update actions on this entity | |
| LAST_UPDATED_PROGRAM | VARCHAR2 | (255) | The program name that last updated the row. | |
| GROUP_LINE_ID | NUMBER | PO Line Id of the Parent CLIN | ||
| LINE_NUM_DISPLAY | VARCHAR2 | (240) | CLIN / SLIN line number | |
| CLM_INFO_FLAG | VARCHAR2 | (1) | Inidcates if its an Informational line or not. Has values Y / N / null | |
| CLM_OPTION_INDICATOR | VARCHAR2 | (1) | Inidcates if its an Option line or not. Has values O / B / null | |
| CLM_BASE_LINE_NUM | NUMBER | PO Line Id of the Base CLIN / SLIN | ||
| CLM_OPTION_NUM | NUMBER | Option number | ||
| CLM_OPTION_FROM_DATE | DATE | Option line From Date | ||
| CLM_OPTION_TO_DATE | DATE | Option line To Date | ||
| CLM_FUNDED_FLAG | VARCHAR2 | (1) | Funded flag has values Y / N / null | |
| CONTRACT_TYPE | VARCHAR2 | (240) | contains contract type lookup code used for complex pricing | |
| COST_CONSTRAINT | VARCHAR2 | (240) | contains cost constraint lookup code used for complex pricing | |
| CLM_IDC_TYPE | VARCHAR2 | (240) | contains IDC type lookup code used for complex pricing | |
| UDA_TEMPLATE_ID | NUMBER | Uda Template Id | ||
| USER_DOCUMENT_STATUS | VARCHAR2 | (30) | User extensible status | |
| DRAFT_ID | NUMBER | contains the draft id | ||
| CLM_EXERCISED_FLAG | VARCHAR2 | (1) | Indicate if option line is exercised or not. Has values Y / N / null | |
| CLM_EXERCISED_DATE | DATE | Indicates option line exercised date | ||
| CLM_MIN_TOTAL_AMOUNT | NUMBER | Minimum Total Amount used for Ordering Constraints | ||
| CLM_MAX_TOTAL_AMOUNT | NUMBER | Maximum Total Amount used for Ordering Constraints | ||
| CLM_MIN_TOTAL_QUANTITY | NUMBER | Minimum Total Quantity used for Ordering Constraints | ||
| CLM_MAX_TOTAL_QUANTITY | NUMBER | Maximum Total Quantity used for Ordering Constraints | ||
| CLM_MIN_ORDER_AMOUNT | NUMBER | Minimum Order Amount used for Ordering Constraints | ||
| CLM_MAX_ORDER_AMOUNT | NUMBER | Maximum Order Amount used for Ordering Constraints | ||
| CLM_MIN_ORDER_QUANTITY | NUMBER | Minimum Order Quantity used for Ordering Constraints | ||
| CLM_MAX_ORDER_QUANTITY | NUMBER | Maximum Order Quantity used for Ordering Constraints | ||
| CLM_TOTAL_AMOUNT_ORDERED | NUMBER | Total Amount Ordered used for Ordering Constraints | ||
| CLM_TOTAL_QUANTITY_ORDERED | NUMBER | Total Quantity Ordered used for Ordering Constraints | ||
| CLM_FSC_PSC | VARCHAR2 | (200) | FSC PSC Code. Used for searching based on UDA data | |
| CLM_MDAPS_MAIS | VARCHAR2 | (200) | MDAPS MAIS Code. Used for searching based on UDA data | |
| CLM_NAICS | VARCHAR2 | (200) | NAICS code. Used for searching based on UDA data | |
| CLM_ORDER_START_DATE | DATE | Order Start Date used for Ordering Constraints | ||
| CLM_ORDER_END_DATE | DATE | Order End Date used for Ordering Constraints | ||
| REVISION_NUM | NUMBER | |||
| CLM_APPROVED_UNDEF_AMOUNT | NUMBER | |||
| CLM_DELIVERY_EVENT_CODE | VARCHAR2 | (30) | ||
| CLM_EXHIBIT_NAME | VARCHAR2 | (10) | ||
| CLM_PAYMENT_INSTR_CODE | VARCHAR2 | (30) | ||
| CLM_POP_EXCEPTION_REASON | VARCHAR2 | (4000) | ||
| CLM_UDA_PRICING_TOTAL | NUMBER | |||
| CLM_UNDEF_ACTION_CODE | VARCHAR2 | (10) | ||
| CLM_UNDEF_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PO_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PO_HEADER_ID
, LINE_TYPE_ID
, LINE_NUM
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ITEM_ID
, ITEM_REVISION
, CATEGORY_ID
, ITEM_DESCRIPTION
, UNIT_MEAS_LOOKUP_CODE
, QUANTITY_COMMITTED
, COMMITTED_AMOUNT
, ALLOW_PRICE_OVERRIDE_FLAG
, NOT_TO_EXCEED_PRICE
, LIST_PRICE_PER_UNIT
, UNIT_PRICE
, QUANTITY
, UN_NUMBER_ID
, HAZARD_CLASS_ID
, NOTE_TO_VENDOR
, FROM_HEADER_ID
, FROM_LINE_ID
, MIN_ORDER_QUANTITY
, MAX_ORDER_QUANTITY
, QTY_RCV_TOLERANCE
, OVER_TOLERANCE_ERROR_FLAG
, MARKET_PRICE
, UNORDERED_FLAG
, CLOSED_FLAG
, USER_HOLD_FLAG
, CANCEL_FLAG
, CANCELLED_BY
, CANCEL_DATE
, CANCEL_REASON
, FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE
, VENDOR_PRODUCT_NUM
, CONTRACT_NUM
, TAXABLE_FLAG
, TAX_NAME
, TYPE_1099
, CAPITAL_EXPENSE_FLAG
, NEGOTIATED_BY_PREPARER_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, REFERENCE_NUM
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, MIN_RELEASE_AMOUNT
, PRICE_TYPE_LOOKUP_CODE
, CLOSED_CODE
, PRICE_BREAK_LOOKUP_CODE
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CLOSED_DATE
, CLOSED_REASON
, CLOSED_BY
, TRANSACTION_REASON_CODE
, ORG_ID
, QC_GRADE
, BASE_UOM
, BASE_QTY
, SECONDARY_UOM
, SECONDARY_QTY
, GLOBAL_ATTRIBUTE_CATEGORY
, 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
, LINE_REFERENCE_NUM
, PROJECT_ID
, TASK_ID
, EXPIRATION_DATE
, TAX_CODE_ID
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID
, SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE
, PREFERRED_GRADE
, AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER
, BID_NUMBER
, BID_LINE_NUMBER
, RETROACTIVE_DATE
, FROM_LINE_LOCATION_ID
, SUPPLIER_REF_NUMBER
, CONTRACT_ID
, START_DATE
, AMOUNT
, JOB_ID
, CONTRACTOR_FIRST_NAME
, CONTRACTOR_LAST_NAME
, ORDER_TYPE_LOOKUP_CODE
, PURCHASE_BASIS
, MATCHING_BASIS
, SVC_AMOUNT_NOTIF_SENT
, SVC_COMPLETION_NOTIF_SENT
, BASE_UNIT_PRICE
, MANUAL_PRICE_CHANGE_FLAG
, RETAINAGE_RATE
, MAX_RETAINAGE_AMOUNT
, PROGRESS_PAYMENT_RATE
, RECOUPMENT_RATE
, CATALOG_NAME
, SUPPLIER_PART_AUXID
, IP_CATEGORY_ID
, TAX_ATTRIBUTE_UPDATE_CODE
, LAST_UPDATED_PROGRAM
, GROUP_LINE_ID
, LINE_NUM_DISPLAY
, CLM_INFO_FLAG
, CLM_OPTION_INDICATOR
, CLM_BASE_LINE_NUM
, CLM_OPTION_NUM
, CLM_OPTION_FROM_DATE
, CLM_OPTION_TO_DATE
, CLM_FUNDED_FLAG
, CONTRACT_TYPE
, COST_CONSTRAINT
, CLM_IDC_TYPE
, UDA_TEMPLATE_ID
, USER_DOCUMENT_STATUS
, DRAFT_ID
, CLM_EXERCISED_FLAG
, CLM_EXERCISED_DATE
, CLM_MIN_TOTAL_AMOUNT
, CLM_MAX_TOTAL_AMOUNT
, CLM_MIN_TOTAL_QUANTITY
, CLM_MAX_TOTAL_QUANTITY
, CLM_MIN_ORDER_AMOUNT
, CLM_MAX_ORDER_AMOUNT
, CLM_MIN_ORDER_QUANTITY
, CLM_MAX_ORDER_QUANTITY
, CLM_TOTAL_AMOUNT_ORDERED
, CLM_TOTAL_QUANTITY_ORDERED
, CLM_FSC_PSC
, CLM_MDAPS_MAIS
, CLM_NAICS
, CLM_ORDER_START_DATE
, CLM_ORDER_END_DATE
, REVISION_NUM
, CLM_APPROVED_UNDEF_AMOUNT
, CLM_DELIVERY_EVENT_CODE
, CLM_EXHIBIT_NAME
, CLM_PAYMENT_INSTR_CODE
, CLM_POP_EXCEPTION_REASON
, CLM_UDA_PRICING_TOTAL
, CLM_UNDEF_ACTION_CODE
, CLM_UNDEF_FLAG
FROM PO.PO_LINES_ALL;
PO.PO_LINES_ALL does not reference any database object
PO.PO_LINES_ALL is referenced by following:
PO
PO_LINES_ALL#
|
|
|
|