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: ViewPO.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:

SchemaAPPS
SynonymAP_TERMS
SynonymFND_CURRENCIES_TL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymFND_TERRITORIES_TL
SynonymORG_FREIGHT
SynonymPER_ALL_PEOPLE_F
SynonymPO_AGENTS
PL/SQL PackagePO_COMMUNICATION_PVT - show dependent code
PL/SQL PackagePO_CORE_S - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.PO_RELEASE_ARCHIVE_XML is not referenced by any database object