eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PO_RELEASE_ARCHIVE_XML

Object Details

Object Name:	PO_RELEASE_ARCHIVE_XML
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_RELEASE_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
SEGMENT1	VARCHAR2	(20)	Yes	Key flexfield segment
REVISION_NUM	NUMBER			Release revision number
PRINT_COUNT	NUMBER			Number of times the release was printed
CREATION_DATE	VARCHAR2	(20)		Standard who column - date when this row was created.
PRINTED_DATE	DATE			Date the release was printed
REVISED_DATE	VARCHAR2	(20)		Last revision date
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.
CANCEL_FLAG	VARCHAR2	(1)		Indicates whether the release is cancelled
ACCEPTANCE_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether an acceptance is required
ACCEPTANCE_DUE_DATE	VARCHAR2	(20)		Date the acceptance is due
CURRENCY_CODE	VARCHAR2	(15)	Yes	Unique identifier for the currency (References FND_CURRENCIES.currency_code)
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 freight 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	(31)		Supplier contact title. References po_vendor_contacts.title
VENDOR_FAX	VARCHAR2	(15)
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
PO_RELEASE_ID	NUMBER		Yes	Release unique identifier
APPROVED_FLAG	VARCHAR2	(1)		Indicates whether the release is approved
LANGUAGE	VARCHAR2	(30)		supplier language. Refers to po_vendor_sites_all.language
VENDOR_ID	NUMBER			Supplier unique identifier (References PO_VENDORS.vendor_id)
CONSIGNED_CONSUMPTION_FLAG	VARCHAR2	(1)		Consigned Consumption Flag
SHIP_TO_LOCATION_ID	VARCHAR2	(40)		Ship-to location unique identifier.
SHIP_TO_LOCATION_NAME	VARCHAR2	(4000)
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_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.
AUTHORIZATION_STATUS	VARCHAR2	(25)		Authorization status of the release
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).
CLOSED_CODE	VARCHAR2	(25)		Describes the closure status of the release
FROZEN_FLAG	VARCHAR2	(1)		Indicates whether the document is frozen
RELEASE_TYPE	VARCHAR2	(25)		Describes whether release is for a blanket or planned purchase order
NOTE_TO_VENDOR	VARCHAR2	(480)		Note to the supplier
ORG_ID	NUMBER			Organization identifier
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).
RELEASE_NUM	NUMBER		Yes	Release number
AGENT_ID	NUMBER	(9)	Yes	Buyer unique identifier
RELEASE_DATE	VARCHAR2	(20)		Date of the release
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
APPROVED_DATE	VARCHAR2	(20)		Date the release was approved
HOLD_BY	NUMBER	(9)		No longer used
HOLD_DATE	VARCHAR2	(20)		No longer used
HOLD_REASON	VARCHAR2	(240)		No longer used
HOLD_FLAG	VARCHAR2	(1)		Indicates whether the release is on hold
CANCELLED_BY	NUMBER	(9)		Unique identifier of the employee who cancelled the release
CANCEL_DATE	VARCHAR2	(20)		Date the release was cancelled
CANCEL_REASON	VARCHAR2	(240)		Reason for cancellation
FIRM_STATUS_LOOKUP_CODE	VARCHAR2	(25)		Firm status
FIRM_DATE	VARCHAR2	(20)		Date the release becomes firmed
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
EDI_PROCESSED_FLAG	VARCHAR2	(1)		This flag is 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.
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
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 the procurement card used on the release
PAY_ON_CODE	VARCHAR2	(25)		Indicator of whether the release will be paid upon receipt.
XML_FLAG	VARCHAR2	(3)		Indicator if the user has chosen XML delivery option for the release PO document. Y if selected.
XML_SEND_DATE	VARCHAR2	(20)		"Date on which XML was generated for a new release, if XML delivery was chosen."
XML_CHANGE_SEND_DATE	VARCHAR2	(20)		"Date on which XML was generated for the last changed release, if XML delivery was chosen."
CBC_ACCOUNTING_DATE	VARCHAR2	(20)		Column used to store the accounting action date for dual budgetary controls
CHANGE_REQUESTED_BY	VARCHAR2	(20)		Column used to store the change request userid
SHIPPING_CONTROL	VARCHAR2	(80)		Indicator of who is responsible for arranging transportation
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)		Operating Unit postal code.
OU_COUNTRY	VARCHAR2	(4000)		Operating Unit Country Name
REL_BUYER_LOCATION_ID	NUMBER
REL_BUYER_ADDRESS_LINE1	VARCHAR2	(4000)
REL_BUYER_ADDRESS_LINE2	VARCHAR2	(4000)
REL_BUYER_ADDRESS_LINE3	VARCHAR2	(4000)
REL_BUYER_ADDRESS_LINE4	VARCHAR2	(4000)
REL_BUYER_CITY_STATE_ZIP	VARCHAR2	(4000)
REL_BUYER_CONTACT_PHONE	VARCHAR2	(4000)
REL_BUYER_CONTACT_EMAIL	VARCHAR2	(4000)
REL_BUYER_CONTACT_FAX	VARCHAR2	(4000)
REL_BUYER_COUNTRY	VARCHAR2	(4000)
TOTAL_AMOUNT	VARCHAR2	(4000)		Total amount of Standard Purchase Order.
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
VENDOR_CONTACT_PHONE	VARCHAR2	(40)		Supplier contact phone. References po_vendor_contacts.phone
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.
START_DATE	VARCHAR2	(20)		Effective date of the document
END_DATE	VARCHAR2	(20)		Expiration date of the document
AMOUNT_AGREED	VARCHAR2	(4000)		Amount agreed for Blanket Release
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)		Document Creation Method - Autocreate, Enter PO, copy, etc...
LATEST_EXTERNAL_FLAG	VARCHAR2	(1)		Indicates whether this is the latest archived revision
VENDOR_ORDER_NUM	VARCHAR2	(25)		Supplier's order number for release

Query Text

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


SELECT SEGMENT1
,      REVISION_NUM
,      PRINT_COUNT
,      CREATION_DATE
,      PRINTED_DATE
,      REVISED_DATE
,      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
,      CANCEL_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_FAX
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      APPROVED_FLAG
,      LANGUAGE
,      VENDOR_ID
,      CONSIGNED_CONSUMPTION_FLAG
,      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
,      AUTHORIZATION_STATUS
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CLOSED_CODE
,      FROZEN_FLAG
,      RELEASE_TYPE
,      NOTE_TO_VENDOR
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      RELEASE_NUM
,      AGENT_ID
,      RELEASE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      APPROVED_DATE
,      HOLD_BY
,      HOLD_DATE
,      HOLD_REASON
,      HOLD_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      ATTRIBUTE_CATEGORY
,      EDI_PROCESSED_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
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      PCARD_ID
,      PAY_ON_CODE
,      XML_FLAG
,      XML_SEND_DATE
,      XML_CHANGE_SEND_DATE
,      CBC_ACCOUNTING_DATE
,      CHANGE_REQUESTED_BY
,      SHIPPING_CONTROL
,      OU_NAME
,      OU_ADDR1
,      OU_ADDR2
,      OU_ADDR3
,      OU_TOWN_CITY
,      OU_REGION2
,      OU_POSTALCODE
,      OU_COUNTRY
,      REL_BUYER_LOCATION_ID
,      REL_BUYER_ADDRESS_LINE1
,      REL_BUYER_ADDRESS_LINE2
,      REL_BUYER_ADDRESS_LINE3
,      REL_BUYER_ADDRESS_LINE4
,      REL_BUYER_CITY_STATE_ZIP
,      REL_BUYER_CONTACT_PHONE
,      REL_BUYER_CONTACT_EMAIL
,      REL_BUYER_CONTACT_FAX
,      REL_BUYER_COUNTRY
,      TOTAL_AMOUNT
,      VENDOR_ADDRESS_LINE4
,      VENDOR_AREA_CODE
,      VENDOR_CONTACT_AREA_CODE
,      VENDOR_CONTACT_PHONE
,      LE_NAME
,      LE_ADDR1
,      LE_ADDR2
,      LE_ADDR3
,      LE_TOWN_CITY
,      LE_STAE_PROVINCE
,      LE_POSTALCODE
,      LE_COUNTRY
,      START_DATE
,      END_DATE
,      AMOUNT_AGREED
,      CHANGE_SUMMARY
,      DOCUMENT_CREATION_METHOD
,      LATEST_EXTERNAL_FLAG
,      VENDOR_ORDER_NUM
FROM APPS.PO_RELEASE_ARCHIVE_XML;

Dependencies

[top of page]

APPS.PO_RELEASE_ARCHIVE_XML references the following:

APPS: AP_TERMS; FND_CURRENCIES_TL; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES; FND_TERRITORIES_TL; ORG_FREIGHT; PER_ALL_PEOPLE_F; PO_AGENTS; PO_COMMUNICATION_PVT - show dependent code; PO_CORE_S - show dependent code; PO_HEADERS_ALL; PO_RELEASES_ARCHIVE_ALL; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.PO_RELEASE_ARCHIVE_XML is not referenced by any database object