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


VIEW: APPS.PO_HEADERS_ARCHIVE_XML

Object Details
Object Name: PO_HEADERS_ARCHIVE_XML
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_HEADERS_ARCHIVE_XML
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Type of the document
SEGMENT1 VARCHAR2 (20) Yes Key flexfield segment
REVISION_NUM NUMBER

Document revision number
PRINT_COUNT NUMBER

Number of times the document was printed
CREATION_DATE VARCHAR2 (20)
Standard who column - date when this row was created.
PRINTED_DATE VARCHAR2 (20)
Date the document was last printed
REVISED_DATE VARCHAR2 (20)
Date the document was last revised
START_DATE VARCHAR2 (20)
Date the document becomes effective
END_DATE VARCHAR2 (20)
Expiration date of the document
NOTE_TO_VENDOR VARCHAR2 (480)
Note to the supplier
DOCUMENT_BUYER_FIRST_NAME VARCHAR2 (150)
Buyer's first name References PER_ALL_PEOPLE_F.first_name
DOCUMENT_BUYER_LAST_NAME VARCHAR2 (150) Yes Buyer's last name References PER_ALL_PEOPLE_F.last_name
DOCUMENT_BUYER_TITLE VARCHAR2 (30)
Buyer's title References PER_ALL_PEOPLE_F.title
DOCUMENT_BUYER_AGENT_ID NUMBER (9) Yes Buyer unique identifier. (References PO_AGENTS.agent_id)
ARCHIVE_BUYER_AGENT_ID VARCHAR2 (40)
Agent ID of Buyer of zero'th revision of the document. Agent Id is null if PO revision_num is 0.
ARCHIVE_BUYER_FIRST_NAME VARCHAR2 (4000)
First name of Buyer of zero'th revision of the document.NULL if PO revision_num is 0.
ARCHIVE_BUYER_LAST_NAME VARCHAR2 (4000)
Last name of Buyer of zero'th revision of the document. Null if PO revision_num is 0.
ARCHIVE_BUYER_TITLE VARCHAR2 (4000)
Last name of Buyer of zero'th revision of the document. Null if PO revision_num is 0.
AMOUNT_AGREED VARCHAR2 (4000)
Buyer unique identifier
CANCEL_FLAG VARCHAR2 (1)
Indicates whether the purchase order is cancelled or not
CONFIRMING_ORDER_FLAG VARCHAR2 (1)
Indicates whether the purchase order is a confirming order or not
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether acceptance from the supplier is required or not
ACCEPTANCE_DUE_DATE VARCHAR2 (20)
Date by which the supplier should accept the purchase order
CURRENCY_CODE VARCHAR2 (15) Yes Unique identifier for the currency
CURRENCY_NAME VARCHAR2 (80) Yes Name of the currency. References FND_CURRENCIES_VL.name
RATE VARCHAR2 (4000)
Currency conversion rate
SHIP_VIA VARCHAR2 (25)
Type of carrier to be used (References ORG_FREIGHT_TL.freight_code)
FOB VARCHAR2 (80)
Type of free-on-board terms for the document (References FND_LOOKUP_VALUES.meaning with LOOKUP_TYPE='FOB')
FREIGHT_TERMS VARCHAR2 (80)
Type of fright terms for the document (References FND_LOOKUP_VALUES.meaning with LOOKUP_TYPE='FREIGHT TERMS')
PAYMENT_TERMS VARCHAR2 (50)
Type of PAYMENT terms for the document (References AP_TERMS.NAME
CUSTOMER_NUM VARCHAR2 (25)
Customer account number. References po_vendor_sites_all.customer_num or po_vendors.customer_num.
VENDOR_NUM VARCHAR2 (30) Yes Supplier number. References po_vendors.SEGMENT1
VENDOR_NAME VARCHAR2 (240)
Supplier name. References po_vendors.name
VENDOR_ADDRESS_LINE1 VARCHAR2 (240)
Supplier address line 1. References po_vendor_sites_all.address_line1
VENDOR_ADDRESS_LINE2 VARCHAR2 (240)
Supplier address line 2. References po_vendor_sites_all.address_line2
VENDOR_ADDRESS_LINE3 VARCHAR2 (240)
Supplier address line 3. References po_vendor_sites_all.address_line3
VENDOR_CITY VARCHAR2 (25)
Supplier city. References po_vendor_sites_all.city
VENDOR_STATE VARCHAR2 (150)
Supplier state. References po_vendor_sites_all.state or county or province
VENDOR_POSTAL_CODE VARCHAR2 (20)
Supplier postal code. References po_vendor_sites_all.zip
VENDOR_COUNTRY VARCHAR2 (80)
Supplier country. References FND_TERRITORIES_TL.TERRITORY_SHORT_NAME
VENDOR_PHONE VARCHAR2 (15)
Supplier phone number. References po_vendor_sites_all.phone
VENDOR_CONTACT_FIRST_NAME VARCHAR2 (15)
Supplier contact first name. References po_vendor_contacts.first_name
VENDOR_CONTACT_LAST_NAME VARCHAR2 (15)
Supplier contact last name. References po_vendor_contacts.last_name
VENDOR_CONTACT_TITLE VARCHAR2 (80)
Supplier contact title. References po_vendor_contacts.title
VENDOR_CONTACT_PHONE VARCHAR2 (40)
Supplier contact phone. References po_vendor_contacts.phone
SHIP_TO_LOCATION_ID VARCHAR2 (40)
Unique identifier for the ship-to location
SHIP_TO_LOCATION_NAME VARCHAR2 (4000)
Ship-to location name.
SHIP_TO_ADDRESS_LINE1 VARCHAR2 (4000)
Ship-to location address first line.
SHIP_TO_ADDRESS_LINE2 VARCHAR2 (4000)
Ship-to location address second line.
SHIP_TO_ADDRESS_LINE3 VARCHAR2 (4000)
Ship-to location address third line.
SHIP_TO_ADDRESS_LINE4 VARCHAR2 (4000)
Ship-to location address fourth line.
SHIP_TO_ADDRESS_INFO VARCHAR2 (4000)
"This is the concatenation value of town_or_city, state_or_province and postal_code"
SHIP_TO_COUNTRY VARCHAR2 (4000)
Ship-to location country.
BILL_TO_LOCATION_ID VARCHAR2 (40)
Bill-to location unique identifier.
BILL_TO_LOCATION_NAME VARCHAR2 (4000)
Bill-to location name.
BILL_TO_ADDRESS_LINE1 VARCHAR2 (4000)
Bill-to location address first line.
BILL_TO_ADDRESS_LINE2 VARCHAR2 (4000)
Bill-to location address second line.
BILL_TO_ADDRESS_LINE3 VARCHAR2 (4000)
Bill-to location address third line.
BILL_TO_ADDRESS_LINE4 VARCHAR2 (4000)
Bill-to location address fourth line
BILL_TO_ADDRESS_INFO VARCHAR2 (4000)
"This is the concatenation value of town_or_city, state_or_province and postal_code"
BILL_TO_COUNTRY VARCHAR2 (4000)
Bill-to location country.
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
VENDOR_SITE_ID NUMBER

Supplier site unique identifier (References PO_VENDOR_SITES_ALL.vendor_site_id)
PO_HEADER_ID NUMBER
Yes Document header unique identifier
APPROVED_FLAG VARCHAR2 (1)
Indicates whether the purchase order is approved or not
LANGUAGE VARCHAR2 (30)
supplier language. Refers to po_vendor_sites_all.language
VENDOR_ID NUMBER

Supplier unique identifier (References PO_VENDORS.vendor_id)
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
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 VARCHAR2 (20)
Concurrent Program who column - date when a program last updated this row).
ORG_ID NUMBER

Organization identifier
COMMENTS VARCHAR2 (240)
Descriptive comments for the document
REPLY_DATE VARCHAR2 (20)
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 VARCHAR2 (20)
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
CLOSED_DATE VARCHAR2 (20)
Date the document was closed
USER_HOLD_FLAG VARCHAR2 (1)
Indicates whether the purchase order is on hold or not
APPROVAL_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether a quote or RFQ requires approval
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 VARCHAR2 (20)
Date from which the purchase order is firmed
FROZEN_FLAG VARCHAR2 (1)
Indicates whether the document is frozen or not
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.
EDI_PROCESSED_STATUS VARCHAR2 (10)
EDI processing status flag
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
VENDOR_CONTACT_ID NUMBER

Supplier contact unique identifier (References PO_VENDOR_CONTACTS.vendor_contact_id)
TERMS_ID NUMBER

Payment terms unique identifier
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.
RATE_TYPE VARCHAR2 (30)
Currency conversion rate type
RATE_DATE VARCHAR2 (20)
Currency conversion date
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
AUTHORIZATION_STATUS VARCHAR2 (25)
Authorization status of the purchase order
APPROVED_DATE VARCHAR2 (20)
Date the purchase order was last approved
AMOUNT_LIMIT VARCHAR2 (4000)
"Maximum amount that can be released against the purchase order (blanket, contract, or planned)"
MIN_RELEASE_AMOUNT VARCHAR2 (4000)
Minimum amount that can be released against the purchase order (blanket or planned)
NOTE_TO_AUTHORIZER VARCHAR2 (240)
Not currently used
NOTE_TO_RECEIVER VARCHAR2 (480)
Note to the receiver of the purchase order
VENDOR_ORDER_NUM VARCHAR2 (25)
"Indicates supplier document number, it gets copied from PO_HEADERS_INTERFACE.vendor_doc_num"
LAST_UPDATE_DATE VARCHAR2 (20)
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).
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 VARCHAR2 (20)
Key Flexfield start date
END_DATE_ACTIVE VARCHAR2 (20)
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).
SUPPLY_AGREEMENT_FLAG VARCHAR2 (1)
Supply agreement flag for Supplier Scheduling
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
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
PCARD_ID NUMBER (15)
Unique Identifier for Procurement Card
PRICE_UPDATE_TOLERANCE VARCHAR2 (4000)
Catalog Price Update Tolerance for EDI 832 Update Action
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: Concatenated string 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 VARCHAR2 (20)
Date on which XML was generated for a new PO, if XML delivery was chosen.
XML_CHANGE_SEND_DATE VARCHAR2 (20)
"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 VARCHAR2 (20)
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
SHIPPING_CONTROL VARCHAR2 (80)
Indicator of who is responsible for arranging transportation
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 VARCHAR2 (20)
"Timestamp for the last update to Contract Clauses. Applicable to Purchasing document of type Standard, Contract, Blanket"
CONTERMS_DELIV_UPD_DATE VARCHAR2 (20)
"Timestamp for the last update to Contract Deliverables Definition. Applicable to Purchasing document of type Standard, Contract, Blanket"
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"
OU_NAME VARCHAR2 (4000)
Indicates Operating unit name.
OU_ADDR1 VARCHAR2 (4000)
Holds Operating Unit address line 1.
OU_ADDR2 VARCHAR2 (4000)
Holds Operating Unit address line 2.
OU_ADDR3 VARCHAR2 (4000)
Holds Operating Unit address line 3.
OU_TOWN_CITY VARCHAR2 (4000)
Holds Operating Unit town_or_city.
OU_REGION2 VARCHAR2 (4000)
Holds Operating Unit state or province or county.
OU_POSTALCODE VARCHAR2 (4000)
Holds Operating Unit postal code.
OU_COUNTRY VARCHAR2 (4000)
Holds Operating Unit country.
BUYER_LOCATION_ID NUMBER

Buyer location unique identifier. References PO_AGENTS.location_id
BUYER_ADDRESS_LINE1 VARCHAR2 (4000)
Buyer address line 1.
BUYER_ADDRESS_LINE2 VARCHAR2 (4000)
Buyer address line 2.
BUYER_ADDRESS_LINE3 VARCHAR2 (4000)
Buyer address line 3.
BUYER_ADDRESS_LINE4 VARCHAR2 (4000)
Buyer address line 4.
BUYER_CITY_STATE_ZIP VARCHAR2 (4000)
"Concatenated value of Buyer city, state and zip."
BUYER_CONTACT_PHONE VARCHAR2 (4000)
Buyer Contact phone.
BUYER_CONTACT_EMAIL VARCHAR2 (4000)
Buyer Contact Email
BUYER_CONTACT_FAX VARCHAR2 (4000)
Buyer Contact fax.
VENDOR_FAX VARCHAR2 (15)
Supplier fax number. References po_vendor_sites_all.fax
TOTAL_AMOUNT VARCHAR2 (4000)
Total amount of Standard Purchase Order. Retrieved from PO_CORE_S.GET_ARCHIVE_TOTAL_FOR_ANY_REV function.
BUYER_COUNTRY VARCHAR2 (4000)
Buyer Country.
VENDOR_ADDRESS_LINE4 VARCHAR2 (240)
Supplier address line 4. References po_vendor_sites_all.ADDRESS_LINE4
VENDOR_AREA_CODE VARCHAR2 (10)
Supplier phone area code. References po_vendor_sites_all.area_code
VENDOR_CONTACT_AREA_CODE VARCHAR2 (10)
Supplier contact phone area code. References vendor_sites.area_code
LE_NAME VARCHAR2 (4000)
Legal Entity name of the Organization.
LE_ADDR1 VARCHAR2 (4000)
Legal Entity address line 1.
LE_ADDR2 VARCHAR2 (4000)
Legal Entity address line 2.
LE_ADDR3 VARCHAR2 (4000)
Legal Entity address line 3.
LE_TOWN_CITY VARCHAR2 (4000)
Legal Entity town or city name.
LE_STAE_PROVINCE VARCHAR2 (4000)
Legal Entity state or province.
LE_POSTALCODE VARCHAR2 (4000)
Legal Entity postal code.
LE_COUNTRY VARCHAR2 (4000)
Legal Entity country.
CANCEL_DATE DATE

Date the purchase order was cancelled
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...
ENCUMBRANCE_REQUIRED_FLAG VARCHAR2 (1)
Blanket or Global Agreement only: Indicates whether the document is to be encumbred or not
LATEST_EXTERNAL_FLAG VARCHAR2 (1)
Indicates whether this is the latest archived revision
STYLE_DISPLAY_NAME VARCHAR2 (240)
Style Display Name
Query Text

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


SELECT TYPE_LOOKUP_CODE
,      SEGMENT1
,      REVISION_NUM
,      PRINT_COUNT
,      CREATION_DATE
,      PRINTED_DATE
,      REVISED_DATE
,      START_DATE
,      END_DATE
,      NOTE_TO_VENDOR
,      DOCUMENT_BUYER_FIRST_NAME
,      DOCUMENT_BUYER_LAST_NAME
,      DOCUMENT_BUYER_TITLE
,      DOCUMENT_BUYER_AGENT_ID
,      ARCHIVE_BUYER_AGENT_ID
,      ARCHIVE_BUYER_FIRST_NAME
,      ARCHIVE_BUYER_LAST_NAME
,      ARCHIVE_BUYER_TITLE
,      AMOUNT_AGREED
,      CANCEL_FLAG
,      CONFIRMING_ORDER_FLAG
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      CURRENCY_CODE
,      CURRENCY_NAME
,      RATE
,      SHIP_VIA
,      FOB
,      FREIGHT_TERMS
,      PAYMENT_TERMS
,      CUSTOMER_NUM
,      VENDOR_NUM
,      VENDOR_NAME
,      VENDOR_ADDRESS_LINE1
,      VENDOR_ADDRESS_LINE2
,      VENDOR_ADDRESS_LINE3
,      VENDOR_CITY
,      VENDOR_STATE
,      VENDOR_POSTAL_CODE
,      VENDOR_COUNTRY
,      VENDOR_PHONE
,      VENDOR_CONTACT_FIRST_NAME
,      VENDOR_CONTACT_LAST_NAME
,      VENDOR_CONTACT_TITLE
,      VENDOR_CONTACT_PHONE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION_NAME
,      SHIP_TO_ADDRESS_LINE1
,      SHIP_TO_ADDRESS_LINE2
,      SHIP_TO_ADDRESS_LINE3
,      SHIP_TO_ADDRESS_LINE4
,      SHIP_TO_ADDRESS_INFO
,      SHIP_TO_COUNTRY
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION_NAME
,      BILL_TO_ADDRESS_LINE1
,      BILL_TO_ADDRESS_LINE2
,      BILL_TO_ADDRESS_LINE3
,      BILL_TO_ADDRESS_LINE4
,      BILL_TO_ADDRESS_INFO
,      BILL_TO_COUNTRY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      APPROVED_FLAG
,      LANGUAGE
,      VENDOR_ID
,      CLOSED_CODE
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      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
,      CLOSED_DATE
,      USER_HOLD_FLAG
,      APPROVAL_REQUIRED_FLAG
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      FROZEN_FLAG
,      EDI_PROCESSED_FLAG
,      EDI_PROCESSED_STATUS
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      VENDOR_CONTACT_ID
,      TERMS_ID
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      STATUS_LOOKUP_CODE
,      RATE_TYPE
,      RATE_DATE
,      FROM_HEADER_ID
,      FROM_TYPE_LOOKUP_CODE
,      AUTHORIZATION_STATUS
,      APPROVED_DATE
,      AMOUNT_LIMIT
,      MIN_RELEASE_AMOUNT
,      NOTE_TO_AUTHORIZER
,      NOTE_TO_RECEIVER
,      VENDOR_ORDER_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_LOGIN
,      SUPPLY_AGREEMENT_FLAG
,      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
,      INTERFACE_SOURCE_CODE
,      REFERENCE_NUM
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      PCARD_ID
,      PRICE_UPDATE_TOLERANCE
,      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
,      SHIPPING_CONTROL
,      CONTERMS_EXIST_FLAG
,      CONTERMS_ARTICLES_UPD_DATE
,      CONTERMS_DELIV_UPD_DATE
,      PENDING_SIGNATURE_FLAG
,      OU_NAME
,      OU_ADDR1
,      OU_ADDR2
,      OU_ADDR3
,      OU_TOWN_CITY
,      OU_REGION2
,      OU_POSTALCODE
,      OU_COUNTRY
,      BUYER_LOCATION_ID
,      BUYER_ADDRESS_LINE1
,      BUYER_ADDRESS_LINE2
,      BUYER_ADDRESS_LINE3
,      BUYER_ADDRESS_LINE4
,      BUYER_CITY_STATE_ZIP
,      BUYER_CONTACT_PHONE
,      BUYER_CONTACT_EMAIL
,      BUYER_CONTACT_FAX
,      VENDOR_FAX
,      TOTAL_AMOUNT
,      BUYER_COUNTRY
,      VENDOR_ADDRESS_LINE4
,      VENDOR_AREA_CODE
,      VENDOR_CONTACT_AREA_CODE
,      LE_NAME
,      LE_ADDR1
,      LE_ADDR2
,      LE_ADDR3
,      LE_TOWN_CITY
,      LE_STAE_PROVINCE
,      LE_POSTALCODE
,      LE_COUNTRY
,      CANCEL_DATE
,      CHANGE_SUMMARY
,      DOCUMENT_CREATION_METHOD
,      ENCUMBRANCE_REQUIRED_FLAG
,      LATEST_EXTERNAL_FLAG
,      STYLE_DISPLAY_NAME
FROM APPS.PO_HEADERS_ARCHIVE_XML;

Dependencies

[top of page]

APPS.PO_HEADERS_ARCHIVE_XML references the following:

SchemaAPPS
SynonymAP_TERMS
SynonymFND_CURRENCIES_TL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymFND_TERRITORIES_TL
SynonymORG_FREIGHT_TL
SynonymPER_ALL_PEOPLE_F
SynonymPO_AGENTS
PL/SQL PackagePO_COMMUNICATION_PVT - show dependent code
PL/SQL PackagePO_CORE_S - show dependent code
SynonymPO_DOC_STYLE_LINES_TL
SynonymPO_HEADERS_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.PO_HEADERS_ARCHIVE_XML is not referenced by any database object