[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PO_HEADERS_ARCHIVE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PO |
| FND Design Data: |  PO.PO_HEADERS_ARCHIVE_ALL
|
| Subobject Name: | |
| Status: | VALID |
PO_HEADERS_ARCHIVE_ALL contains archived purchase order header
information. Oracle Purchasing only archives the following documents:
.
{{"bul:1"}}Standard purchase orders {{"bul:1"}}Blanket purchase orders
{{"bul:1"}}Contract purchase orders
.
{{"bodytext"}}When you modify a PO_HEADER row, 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 previous revisions of the purchase order header using this
table.
.
The latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'.
.
You need one row for each document header you archive. Each row
contains the same information as the PO_HEADERS_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_HEADERS_ARCHIVE_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PO_HEADER_ID
REVISION_NUM
|
| PO_HEADERS_ARCHIVE_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SEGMENT1
REVISION_NUM
TYPE_LOOKUP_CODE
ORG_ID
|
| PO_HEADERS_ARCHIVE_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
VENDOR_ID
TYPE_LOOKUP_CODE
APPROVED_DATE
|
| PO_HEADERS_ARCHIVE_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AGENT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_HEADER_ID | NUMBER | Yes | Document header unique identifier | |
| AGENT_ID | NUMBER | (9) | Yes | Buyer unique identifier |
| TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | Type of the document |
| 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). | |
| SEGMENT1 | VARCHAR2 | (20) | Yes | Key flexfield segment |
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Key Flexfield summary flag |
| ENABLED_FLAG | VARCHAR2 | (1) | Yes | Key Flexfield enabled flag |
| SEGMENT2 | VARCHAR2 | (20) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (20) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (20) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (20) | Key flexfield segment | |
| START_DATE_ACTIVE | DATE | Key Flexfield start date | ||
| END_DATE_ACTIVE | DATE | Key Flexfield end date | ||
| 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). | ||
| VENDOR_ID | NUMBER | Supplier unique identifier | ||
| VENDOR_SITE_ID | NUMBER | Supplier site unique identifier | ||
| VENDOR_CONTACT_ID | NUMBER | Supplier contact unique identifier | ||
| SHIP_TO_LOCATION_ID | NUMBER | Unique identifier for the ship-to location | ||
| BILL_TO_LOCATION_ID | NUMBER | Unique identifier of the bill-to location for the document | ||
| TERMS_ID | NUMBER | Payment terms unique identifier | ||
| SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (25) | Type of carrier to be used | |
| FOB_LOOKUP_CODE | VARCHAR2 | (25) | Type of free-on-board terms for the document | |
| FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | (25) | Type of freight terms for the document | |
| STATUS_LOOKUP_CODE | VARCHAR2 | (25) | Status of the RFQ or quotation. | |
| CURRENCY_CODE | VARCHAR2 | (15) | Unique identifier for the currency | |
| RATE_TYPE | VARCHAR2 | (30) | Currency conversion rate type | |
| RATE_DATE | DATE | Currency conversion date | ||
| RATE | NUMBER | Currency conversion rate | ||
| FROM_HEADER_ID | NUMBER | Unique identifier of the RFQ used to autocreate a quotation | ||
| FROM_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Document type of the document used to autocreate another document | |
| START_DATE | DATE | Date the document becomes effective | ||
| END_DATE | DATE | Expiration date of the document | ||
| BLANKET_TOTAL_AMOUNT | NUMBER | Amount agreed for the purchase order (blanket or planned) | ||
| AUTHORIZATION_STATUS | VARCHAR2 | (25) | Authorization status of the purchase order | |
| REVISION_NUM | NUMBER | Document revision number | ||
| REVISED_DATE | DATE | Date the document was last revised | ||
| APPROVED_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is approved or not | |
| APPROVED_DATE | DATE | Date the purchase order was last approved | ||
| AMOUNT_LIMIT | NUMBER | Maximum amount that can be released against the purchase order (blanket, contract, or planned) | ||
| MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against the purchase order (blanket or planned) | ||
| NOTE_TO_AUTHORIZER | VARCHAR2 | (240) | Not currently used | |
| NOTE_TO_VENDOR | VARCHAR2 | (480) | Note to the supplier | |
| NOTE_TO_RECEIVER | VARCHAR2 | (480) | Note to the receiver of the purchase order | |
| PRINT_COUNT | NUMBER | Number of times the document was printed | ||
| PRINTED_DATE | DATE | Date the document was last printed | ||
| VENDOR_ORDER_NUM | VARCHAR2 | (25) | No longer used | |
| CONFIRMING_ORDER_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is a confirming order or not | |
| COMMENTS | VARCHAR2 | (240) | Descriptive comments for the document | |
| REPLY_DATE | DATE | Date the supplier replied to the RFQ | ||
| REPLY_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Method the supplier should use to reply to the RFQ | |
| RFQ_CLOSE_DATE | DATE | Date the RFQ will be closed | ||
| QUOTE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Type of quotation | |
| QUOTATION_CLASS_CODE | VARCHAR2 | (25) | Class of quotation | |
| QUOTE_WARNING_DELAY_UNIT | VARCHAR2 | (25) | Warning delay unit of measure (Unused since release 8.0) | |
| QUOTE_WARNING_DELAY | NUMBER | Number of days prior to the expiration of the quotation that you want to be notified | ||
| QUOTE_VENDOR_QUOTE_NUMBER | VARCHAR2 | (25) | Number of the quotation for the supplier | |
| ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether acceptance from the supplier is required or not | |
| ACCEPTANCE_DUE_DATE | DATE | Date by which the supplier should accept the purchase order | ||
| CLOSED_DATE | DATE | Date the document was closed | ||
| USER_HOLD_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is on hold or not | |
| EVER_APPROVED_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order was ever approved - No longer used since release 7.0 | |
| APPROVAL_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether a quote or RFQ requires approval | |
| CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether the purchase order is cancelled or not | |
| STANDARD_COMMENT_CODE | VARCHAR2 | (15) | No longer used since release 7.0 | |
| FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | (30) | Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application | |
| FIRM_DATE | DATE | Date from which the purchase order is firmed | ||
| FROZEN_FLAG | VARCHAR2 | (1) | Indicates whether the document is frozen 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 | |
| CLOSED_CODE | VARCHAR2 | (25) | Describes the closure status of the document | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States standard general ledger transaction code | |
| GOVERNMENT_CONTEXT | VARCHAR2 | (30) | USSGL descriptive flexfield context column | |
| 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 | |
| LATEST_EXTERNAL_FLAG | VARCHAR2 | (1) | Indicates whether this is the latest archived revision | |
| 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). | ||
| 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 | |
| EDI_PROCESSED_FLAG | VARCHAR2 | (1) | Used by e-Commerce Gateway to identify documents that have been sent via EDI. This flag is updated to Y by the e-Commerce Gateway extraction routines. | |
| PCARD_ID | NUMBER | (15) | Unique Identifer for Procurement Card | |
| PRICE_UPDATE_TOLERANCE | NUMBER | Catalog Price Update Tolerance for EDI 832 Update Action | ||
| SUPPLY_AGREEMENT_FLAG | VARCHAR2 | (1) | Supply agreement flag for Supplier Scheduling | |
| EDI_PROCESSED_STATUS | VARCHAR2 | (10) | EDI processing status flag | |
| INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | Audit trail reference (needed for 832 EDI transaction) | |
| REFERENCE_NUM | VARCHAR2 | (25) | Audit trail reference (needed for 832 EDI transaction) | |
| WF_ITEM_TYPE | VARCHAR2 | (8) | Approval workflow item type | |
| WF_ITEM_KEY | VARCHAR2 | (240) | Approval workflow item key | |
| MRC_RATE_TYPE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion rate type pairs | |
| MRC_RATE_DATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID and currency conversion date pairs | |
| MRC_RATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only: Concatenatedstring of reporting Set of Books ID and currency conversion rate pairs | |
| PAY_ON_CODE | VARCHAR2 | (25) | Indicator of whether the purchase order will be paid upon receipt | |
| XML_FLAG | VARCHAR2 | (1) | Indicator if user has chosen to send the PO document through XML. Y if selected. | |
| XML_SEND_DATE | DATE | Date on which XML was generated for a new PO, if XML delivery was chosen. | ||
| XML_CHANGE_SEND_DATE | DATE | Date on which XML was generated for the last change PO, if XML delivery was chosen. | ||
| GLOBAL_AGREEMENT_FLAG | VARCHAR2 | (1) | Global Agreement Flag | |
| CONSIGNED_CONSUMPTION_FLAG | VARCHAR2 | (1) | Consigned Consumption Flag | |
| CBC_ACCOUNTING_DATE | DATE | Column used to store the accounting action date for dual budgetary control functionality. | ||
| CONSUME_REQ_DEMAND_FLAG | VARCHAR2 | (1) | Used by Oracle Sourcing- Tells whether user wanted to consume the req demand when creating a blanket | |
| CHANGE_REQUESTED_BY | VARCHAR2 | (20) | Change Requested By will track changes to Purchase Document from Supplier/ Requester | |
| CONTERMS_EXIST_FLAG | VARCHAR2 | (1) | Indicates if contract terms template is attached to the purchasing document or not. Applicable to Purchasing document of type Standard, Contract, Blanket | |
| CONTERMS_ARTICLES_UPD_DATE | DATE | Timestamp for the last update to Contract Clauses. Applicable to Purchasing document of type Standard, Contract, Blanket | ||
| ENCUMBRANCE_REQUIRED_FLAG | VARCHAR2 | (1) | Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not | |
| CONTERMS_DELIV_UPD_DATE | DATE | Timestamp for the last update to Contract Deliverables Definition. Applicable to Purchasing document of type Standard, Contract, Blanket | ||
| SHIPPING_CONTROL | VARCHAR2 | (30) | Indicator of who is responsible for arranging transportation | |
| PENDING_SIGNATURE_FLAG | VARCHAR2 | (1) | Indicates if the purchasing document is waiting for the signatures or not. Applicable to Purchasing document of type Standard, Contract, Blanket | |
| CHANGE_SUMMARY | VARCHAR2 | (2000) | Description of changes made. This information is entered by the Buyer when submitting the document for approval and may be used in generating an amendment document. | |
| DOCUMENT_CREATION_METHOD | VARCHAR2 | (30) | Method in which the document got created - Autocreate, enter PO , etc... | |
| SUBMIT_DATE | DATE | Date when document was first submitted for approval | ||
| SUPPLIER_NOTIF_METHOD | VARCHAR2 | (25) | Supplier Notification Method | |
| FAX | VARCHAR2 | (30) | Supplier Fax Number | |
| EMAIL_ADDRESS | VARCHAR2 | (2000) | Supplier Email Address | |
| RETRO_PRICE_COMM_UPDATES_FLAG | VARCHAR2 | (1) | Communicate price updates flag | |
| RETRO_PRICE_APPLY_UPDATES_FLAG | VARCHAR2 | (1) | Retroactively apply price updates to existing POs | |
| UPDATE_SOURCING_RULES_FLAG | VARCHAR2 | (1) | Update sourcing rules flag | |
| AUTO_SOURCING_FLAG | VARCHAR2 | (1) | Enable automatic sourcing flag | |
| CREATED_LANGUAGE | VARCHAR2 | (4) | Language code in which the GBPA was created. | |
| CPA_REFERENCE | NUMBER | This is to support the iP catalog upgrade for items that had a CPA reference prior to Release 12. This column is just for information purpose. | ||
| SUPPLIER_AUTH_ENABLED_FLAG | VARCHAR2 | (1) | Supplier Auth Enabled Flag | |
| CAT_ADMIN_AUTH_ENABLED_FLAG | VARCHAR2 | (1) | Cat Admin Auth Enabled Flag | |
| STYLE_ID | NUMBER | Yes | Determines the Purchasing Style of the document. | |
| LAST_UPDATED_PROGRAM | VARCHAR2 | (255) | The program name that last updated the row. | |
| PAY_WHEN_PAID | VARCHAR2 | (1) | This is done as a part of E&C ER- Phase 1 | |
| USER_DOCUMENT_STATUS | VARCHAR2 | (30) | Document Status entered by the user | |
| AME_APPROVAL_ID | NUMBER | Id for AME Approval | ||
| CLM_DOCUMENT_NUMBER | VARCHAR2 | (50) | Unique Document Number for the user | |
| AME_TRANSACTION_TYPE | VARCHAR2 | (50) | AME Transaction Type | |
| CLM_AMOUNT_RELEASED | NUMBER | CLM released amount | ||
| CLM_AMT_SYNCED_TO_AGREEMENT | VARCHAR2 | (1) | CLM Amount Synchronized to aggrement | |
| CLM_AWARD_ADMINISTRATOR | VARCHAR2 | (400) | Award Admintsrator | |
| CLM_AWARD_TYPE | VARCHAR2 | (100) | Type of award | |
| CLM_CLOSEOUT_STATUS | VARCHAR2 | (25) | Close out status | |
| CLM_CONTRACT_OFFICER | NUMBER | Contract Officer | ||
| CLM_COTR_CONTACT | VARCHAR2 | (200) | Contact of Contract | |
| CLM_COTR_OFFICE | VARCHAR2 | (2000) | Contract Office | |
| CLM_DOCUMENT_FORMAT | VARCHAR2 | (200) | Format of Document | |
| CLM_EFFECTIVE_DATE | DATE | CLM Effective date | ||
| CLM_EXTERNAL_IDV | VARCHAR2 | (2000) | CLM external IDV | |
| CLM_ISSUING_OFFICE | VARCHAR2 | (1000) | CLM issuing office | |
| CLM_MAX_ORDER_AMOUNT | NUMBER | Maximum order amount | ||
| CLM_MIN_GUARANTEE_AWARD_AMT | NUMBER | Minimum Guarantee Award Amount | ||
| CLM_MIN_GUAR_AWARD_AMT_PERCENT | NUMBER | percentage of Minimum Guarantee Award Amount | ||
| CLM_MIN_ORDER_AMOUNT | NUMBER | Min Order amount | ||
| CLM_MOD_ISSUING_OFFICE | VARCHAR2 | (1000) | Mod issuing office | |
| CLM_NO_SIGNED_COPIES_TO_RETURN | NUMBER | Return of No Signed Copies | ||
| CLM_PRIORITY_CODE | VARCHAR2 | (200) | priority Code | |
| CLM_SOURCE_DOCUMENT_ID | NUMBER | Source Document ID | ||
| CLM_STANDARD_FORM | VARCHAR2 | (200) | Standard Form | |
| CLM_SUPPLIER_NAME | VARCHAR2 | (400) | Supplier Name | |
| CLM_SUPPLIER_SITE_NAME | VARCHAR2 | (400) | Supplier site name | |
| CLM_VENDOR_OFFER_NUMBER | VARCHAR2 | (400) | Vendor Offer number | |
| COMM_REV_NUM | NUMBER | Comm revision Number | ||
| DRAFT_ID | NUMBER | Unique Identifier for Revision 0 of the Document. Utilized by the Contracts flows in CLM View Base Document Action | ||
| ENABLE_ALL_SITES | VARCHAR2 | (1) | Enabling all sites | |
| OTM_RECOVERY_FLAG | VARCHAR2 | (1) | OTM recovery flag | |
| OTM_STATUS_CODE | VARCHAR2 | (80) | OTM status Code | |
| TAX_ATTRIBUTE_UPDATE_CODE | VARCHAR2 | (15) | tax attribute Update Code | |
| UDA_TEMPLATE_DATE | DATE | UDA template date | ||
| UDA_TEMPLATE_ID | NUMBER | UDA template ID | ||
| UMBRELLA_PROGRAM_ID | NUMBER | Stores the Umbrella program reference to PON_UMBRELLA_PROGRAMS table | ||
| FON_REF_ID | NUMBER | Stores the Fair Opportunity Notice reference to PON_AUCTION_HEADERS_ALL table | ||
| CLM_CONTRACT_FINANCE_CODE | VARCHAR2 | (30) | ||
| CLM_PAYMENT_INSTR_CODE | VARCHAR2 | (30) | ||
| CLM_SPECIAL_CONTRACT_TYPE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PO_HEADER_ID
, AGENT_ID
, TYPE_LOOKUP_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, SEGMENT1
, SUMMARY_FLAG
, ENABLED_FLAG
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID
, TERMS_ID
, SHIP_VIA_LOOKUP_CODE
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, STATUS_LOOKUP_CODE
, CURRENCY_CODE
, RATE_TYPE
, RATE_DATE
, RATE
, FROM_HEADER_ID
, FROM_TYPE_LOOKUP_CODE
, START_DATE
, END_DATE
, BLANKET_TOTAL_AMOUNT
, AUTHORIZATION_STATUS
, REVISION_NUM
, REVISED_DATE
, APPROVED_FLAG
, APPROVED_DATE
, AMOUNT_LIMIT
, MIN_RELEASE_AMOUNT
, NOTE_TO_AUTHORIZER
, NOTE_TO_VENDOR
, NOTE_TO_RECEIVER
, PRINT_COUNT
, PRINTED_DATE
, VENDOR_ORDER_NUM
, CONFIRMING_ORDER_FLAG
, COMMENTS
, REPLY_DATE
, REPLY_METHOD_LOOKUP_CODE
, RFQ_CLOSE_DATE
, QUOTE_TYPE_LOOKUP_CODE
, QUOTATION_CLASS_CODE
, QUOTE_WARNING_DELAY_UNIT
, QUOTE_WARNING_DELAY
, QUOTE_VENDOR_QUOTE_NUMBER
, ACCEPTANCE_REQUIRED_FLAG
, ACCEPTANCE_DUE_DATE
, CLOSED_DATE
, USER_HOLD_FLAG
, EVER_APPROVED_FLAG
, APPROVAL_REQUIRED_FLAG
, CANCEL_FLAG
, STANDARD_COMMENT_CODE
, FIRM_STATUS_LOOKUP_CODE
, FIRM_DATE
, FROZEN_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, CLOSED_CODE
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LATEST_EXTERNAL_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, 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
, EDI_PROCESSED_FLAG
, PCARD_ID
, PRICE_UPDATE_TOLERANCE
, SUPPLY_AGREEMENT_FLAG
, EDI_PROCESSED_STATUS
, INTERFACE_SOURCE_CODE
, REFERENCE_NUM
, WF_ITEM_TYPE
, WF_ITEM_KEY
, MRC_RATE_TYPE
, MRC_RATE_DATE
, MRC_RATE
, PAY_ON_CODE
, XML_FLAG
, XML_SEND_DATE
, XML_CHANGE_SEND_DATE
, GLOBAL_AGREEMENT_FLAG
, CONSIGNED_CONSUMPTION_FLAG
, CBC_ACCOUNTING_DATE
, CONSUME_REQ_DEMAND_FLAG
, CHANGE_REQUESTED_BY
, CONTERMS_EXIST_FLAG
, CONTERMS_ARTICLES_UPD_DATE
, ENCUMBRANCE_REQUIRED_FLAG
, CONTERMS_DELIV_UPD_DATE
, SHIPPING_CONTROL
, PENDING_SIGNATURE_FLAG
, CHANGE_SUMMARY
, DOCUMENT_CREATION_METHOD
, SUBMIT_DATE
, SUPPLIER_NOTIF_METHOD
, FAX
, EMAIL_ADDRESS
, RETRO_PRICE_COMM_UPDATES_FLAG
, RETRO_PRICE_APPLY_UPDATES_FLAG
, UPDATE_SOURCING_RULES_FLAG
, AUTO_SOURCING_FLAG
, CREATED_LANGUAGE
, CPA_REFERENCE
, SUPPLIER_AUTH_ENABLED_FLAG
, CAT_ADMIN_AUTH_ENABLED_FLAG
, STYLE_ID
, LAST_UPDATED_PROGRAM
, PAY_WHEN_PAID
, USER_DOCUMENT_STATUS
, AME_APPROVAL_ID
, CLM_DOCUMENT_NUMBER
, AME_TRANSACTION_TYPE
, CLM_AMOUNT_RELEASED
, CLM_AMT_SYNCED_TO_AGREEMENT
, CLM_AWARD_ADMINISTRATOR
, CLM_AWARD_TYPE
, CLM_CLOSEOUT_STATUS
, CLM_CONTRACT_OFFICER
, CLM_COTR_CONTACT
, CLM_COTR_OFFICE
, CLM_DOCUMENT_FORMAT
, CLM_EFFECTIVE_DATE
, CLM_EXTERNAL_IDV
, CLM_ISSUING_OFFICE
, CLM_MAX_ORDER_AMOUNT
, CLM_MIN_GUARANTEE_AWARD_AMT
, CLM_MIN_GUAR_AWARD_AMT_PERCENT
, CLM_MIN_ORDER_AMOUNT
, CLM_MOD_ISSUING_OFFICE
, CLM_NO_SIGNED_COPIES_TO_RETURN
, CLM_PRIORITY_CODE
, CLM_SOURCE_DOCUMENT_ID
, CLM_STANDARD_FORM
, CLM_SUPPLIER_NAME
, CLM_SUPPLIER_SITE_NAME
, CLM_VENDOR_OFFER_NUMBER
, COMM_REV_NUM
, DRAFT_ID
, ENABLE_ALL_SITES
, OTM_RECOVERY_FLAG
, OTM_STATUS_CODE
, TAX_ATTRIBUTE_UPDATE_CODE
, UDA_TEMPLATE_DATE
, UDA_TEMPLATE_ID
, UMBRELLA_PROGRAM_ID
, FON_REF_ID
, CLM_CONTRACT_FINANCE_CODE
, CLM_PAYMENT_INSTR_CODE
, CLM_SPECIAL_CONTRACT_TYPE
FROM PO.PO_HEADERS_ARCHIVE_ALL;
PO.PO_HEADERS_ARCHIVE_ALL does not reference any database object
PO.PO_HEADERS_ARCHIVE_ALL is referenced by following:
PO
PO_HEADERS_ARCHIVE_ALL#
|
|
|
|