[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_LINES_ARCHIVE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_LINES_ARCHIVE_ALL
|
| Subobject Name: | |
| Status: | VALID |
PO_LINES_ARCHIVE_ALL contains archived purchase order line
information. Oracle Purchasing only archives lines for the following
documents:
.
{{"bul:1"}}Standard purchase orders {{"bul:1"}}Blanket purchase orders
.
{{"bodytext"}}When you modify a purchasing line, Oracle Purchasing
will archive it after you (re)approve the purchase order or after you
print it (this depends on the purchasing system options). You can
retrieve revisions of the purchase order line using this table. The
latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'.
.
You need one row for each document line you archive. Each row
contains the same information as the PO_LINES_ALL table. Oracle
Purchasing uses this information to ensure you keep copies of your
legal documents.
.
Oracle Purchasing does not currently read or retrieve information in
this table.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PO_LINES_ARCHIVE_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PO_LINE_ID
REVISION_NUM
|
| PO_LINES_ARCHIVE_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PO_HEADER_ID
|
| PO_LINES_ARCHIVE_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ITEM_ID
|
| PO_LINES_ARCHIVE_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLOSED_BY
|
| PO_LINES_ARCHIVE_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CANCELLED_BY
|
| PO_LINES_ARCHIVE_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FROM_HEADER_ID
|
| 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 | |
| LINE_TYPE_ID | NUMBER | Line type unique identifier | ||
| 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 | ||
| ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
| CATEGORY_ID | NUMBER | Item category unique identifier | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
| UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure for the quantity ordered | |
| QUANTITY_COMMITTED | NUMBER | Quantity agreed for an agreement line | ||
| COMMITTED_AMOUNT | NUMBER | Amount agreed for an agreement line | ||
| ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicates whether or not you can change the price on releases | |
| NOT_TO_EXCEED_PRICE | NUMBER | Price limit that you cannot exceed on a release shipment | ||
| LIST_PRICE_PER_UNIT | NUMBER | List price for the item on the line | ||
| UNIT_PRICE | NUMBER | Unit price for the line | ||
| QUANTITY | NUMBER | Quantity ordered on the line | ||
| UN_NUMBER_ID | NUMBER | UN number unique identifier | ||
| HAZARD_CLASS_ID | NUMBER | Hazard class unique identifier | ||
| NOTE_TO_VENDOR | VARCHAR2 | (480) | Short note to supplier | |
| FROM_HEADER_ID | NUMBER | Quotation unique identifier | ||
| FROM_LINE_ID | NUMBER | Quotation line unique identifier | ||
| MIN_ORDER_QUANTITY | NUMBER | Minimum order quantity for a quotation line | ||
| MAX_ORDER_QUANTITY | NUMBER | Maximum order quantity for a quotation line | ||
| QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | ||
| OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | (25) | Indicates whether you reject receipts exceeding the tolerance or not | |
| MARKET_PRICE | NUMBER | Market price for the item on the line | ||
| UNORDERED_FLAG | VARCHAR2 | (1) | Indicates whether the line was created from unordered receipts or not | |
| 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 | |
| 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 product number | |
| CONTRACT_NUM | VARCHAR2 | (25) | Contract number referenced on the line. Obsoleted in PO FPJ 11.5.10 | |
| TAXABLE_FLAG | VARCHAR2 | (1) | Indicates whether the document line is taxable or not | |
| TAX_NAME | VARCHAR2 | (30) | Tax code applying to the line | |
| 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 | Minimum amount that can be released against a planned purchase order or blanket agreement lines | ||
| PRICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Price type of the line | |
| REVISION_NUM | NUMBER | Document revision number | ||
| PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | (25) | Describes the pricing scheme for blanket agreement line price breaks | |
| LATEST_EXTERNAL_FLAG | VARCHAR2 | (1) | Indicates whether this is the latest archived revision | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger 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_CODE | VARCHAR2 | (25) | Closure status of the line | |
| CLOSED_BY | NUMBER | Unique identifier of employee who closed the line | ||
| CLOSED_DATE | DATE | Date the line is closed | ||
| CLOSED_REASON | VARCHAR2 | (240) | Why the line is closed | |
| TRANSACTION_REASON_CODE | VARCHAR2 | (25) | Transaction reason | |
| ORG_ID | NUMBER | Organization identifier | ||
| 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 | |
| EXPIRATION_DATE | DATE | Expiration Date For Catalog Lines | ||
| QC_GRADE | VARCHAR2 | (25) | Quality control grade wanted for the purchase order line | |
| BASE_UOM | VARCHAR2 | (25) | Base unit of measure (UOM) for the item ordered | |
| BASE_QTY | NUMBER | Ordered quantity converted from transaction UOM to base UOM | ||
| SECONDARY_UOM | VARCHAR2 | (25) | Dual unit of measure for the item ordered | |
| SECONDARY_QTY | NUMBER | Converted quantity from base UOM to dual UOM for the item ordered | ||
| LINE_REFERENCE_NUM | VARCHAR2 | (25) | Audit Trail Reference (needed for 832 EDI transaction) | |
| PROJECT_ID | NUMBER | Project accounting project unique identifier | ||
| TASK_ID | NUMBER | Project accounting task unique identifier | ||
| TAX_CODE_ID | NUMBER | Unique identifier for the tax code | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Secondary unit of measure for the quantity ordered | |
| SECONDARY_QUANTITY | NUMBER | Quantity ordered in secondary unit of measure | ||
| PREFERRED_GRADE | VARCHAR2 | (150) | Preferred quality grade of the item ordered | |
| 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 | ||
| BID_NUMBER | NUMBER | reference to the sourcing bud number | ||
| BID_LINE_NUMBER | NUMBER | reference to sourcing big line number | ||
| 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. | ||
| RETROACTIVE_DATE | DATE | Column used to store the timestamp of a retroactive price change | ||
| SUPPLIER_REF_NUMBER | VARCHAR2 | (150) | Tracking code that links to a specific configuration of an item. Generated by a configuration engine maintained by suppliers. | |
| CONTRACT_ID | NUMBER | Contract PA reference of a Line. Apply to Standard PO only. Foreign key to PO_HEADER_ID in PO_HEADERS_ALL | ||
| JOB_ID | NUMBER | Reference to HR Job for service lines | ||
| AMOUNT | NUMBER | Amount for service lines | ||
| START_DATE | DATE | Assignment start date for contractor | ||
| CONTRACTOR_FIRST_NAME | VARCHAR2 | (240) | Contractor First Name for Service lines | |
| CONTRACTOR_LAST_NAME | VARCHAR2 | (240) | Contractor Last Name for Service lines | |
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Value Basis of the line type | |
| 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 only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether an Amount Billed Approaching Budget reminder notification has been sent for this line. | |
| SVC_COMPLETION_NOTIF_SENT | VARCHAR2 | (1) | Temp Labor lines only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether a Contractor Assignment Nearing Completion reminder notification has been sent for this line. | |
| 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) | ||
| 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 | |
| USER_DOCUMENT_STATUS | VARCHAR2 | (30) | User Document Status | |
| 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_FSC_PSC | VARCHAR2 | (200) | UDA Field denomralized used to search at line level | |
| CLM_MAX_ORDER_AMOUNT | NUMBER | CLM Max Order amount | ||
| CLM_MAX_ORDER_QUANTITY | NUMBER | CLM Max Order quantity | ||
| CLM_MAX_TOTAL_AMOUNT | NUMBER | CLM Max Order Total amount | ||
| CLM_MAX_TOTAL_QUANTITY | NUMBER | CLM Max Order Total qty | ||
| CLM_MDAPS_MAIS | VARCHAR2 | (200) | UDA Field denomralized used to search at line level | |
| CLM_MIN_ORDER_AMOUNT | NUMBER | CLM Min Order Amount | ||
| CLM_MIN_ORDER_QUANTITY | NUMBER | CLM Min Order quantity | ||
| CLM_MIN_TOTAL_AMOUNT | NUMBER | CLM Min Order total amount | ||
| CLM_MIN_TOTAL_QUANTITY | NUMBER | CLM Min Order total qty | ||
| CLM_NAICS | VARCHAR2 | (200) | CLM Naics | |
| CLM_ORDER_END_DATE | DATE | CLM order End date | ||
| CLM_ORDER_START_DATE | DATE | CLM order start date | ||
| CLM_TOTAL_AMOUNT_ORDERED | NUMBER | CLM total Amount ordered | ||
| CLM_TOTAL_QUANTITY_ORDERED | NUMBER | CLM Total Qty ordered | ||
| FROM_LINE_LOCATION_ID | NUMBER | Line Location Id | ||
| TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | (15) | Tax attribute Code | |
| UDA_TEMPLATE_ID | NUMBER | UDA template id | ||
| 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
, REVISION_NUM
, PRICE_BREAK_LOOKUP_CODE
, LATEST_EXTERNAL_FLAG
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CLOSED_CODE
, CLOSED_BY
, CLOSED_DATE
, CLOSED_REASON
, TRANSACTION_REASON_CODE
, ORG_ID
, 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
, EXPIRATION_DATE
, QC_GRADE
, BASE_UOM
, BASE_QTY
, SECONDARY_UOM
, SECONDARY_QTY
, LINE_REFERENCE_NUM
, PROJECT_ID
, TASK_ID
, TAX_CODE_ID
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_QUANTITY
, PREFERRED_GRADE
, AUCTION_HEADER_ID
, AUCTION_DISPLAY_NUMBER
, AUCTION_LINE_NUMBER
, BID_NUMBER
, BID_LINE_NUMBER
, OKE_CONTRACT_HEADER_ID
, OKE_CONTRACT_VERSION_ID
, RETROACTIVE_DATE
, SUPPLIER_REF_NUMBER
, CONTRACT_ID
, JOB_ID
, AMOUNT
, START_DATE
, 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
, 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
, USER_DOCUMENT_STATUS
, CLM_EXERCISED_FLAG
, CLM_EXERCISED_DATE
, CLM_FSC_PSC
, CLM_MAX_ORDER_AMOUNT
, CLM_MAX_ORDER_QUANTITY
, CLM_MAX_TOTAL_AMOUNT
, CLM_MAX_TOTAL_QUANTITY
, CLM_MDAPS_MAIS
, CLM_MIN_ORDER_AMOUNT
, CLM_MIN_ORDER_QUANTITY
, CLM_MIN_TOTAL_AMOUNT
, CLM_MIN_TOTAL_QUANTITY
, CLM_NAICS
, CLM_ORDER_END_DATE
, CLM_ORDER_START_DATE
, CLM_TOTAL_AMOUNT_ORDERED
, CLM_TOTAL_QUANTITY_ORDERED
, FROM_LINE_LOCATION_ID
, TAX_ATTRIBUTE_UPDATE_CODE
, UDA_TEMPLATE_ID
, 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_ARCHIVE_ALL;
PO.PO_LINES_ARCHIVE_ALL does not reference any database object
PO.PO_LINES_ARCHIVE_ALL is referenced by following:
PO
PO_LINES_ARCHIVE_ALL#
|
|
|
|