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_CXML_DELIVERTO_ARCH_V

Object Details

Object Name:	PO_CXML_DELIVERTO_ARCH_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_CXML_DELIVERTO_ARCH_V
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
REVISION_NUM	NUMBER			Document revision number
PO_RELEASE_ID	NUMBER			Release unique identifier
PO_DISTRIBUTION_ID	NUMBER		Yes	Document distribution unique identifier
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
PO_LINE_ID	NUMBER			Document line unique identifier
PO_LINE_LOC_ID	NUMBER			Document shipment schedule unique identifier
DELIVER_TO_LOCATION_ID	NUMBER			Unique identifier for the delivery location
DISTRIBUTION_NUM	NUMBER		Yes	Distribution number
QUANTITY	NUMBER			Quantity ordered minus Quantity cancelled on the distribution
REQUESTOR	VARCHAR2	(240)		Concatenation of last name, title, first name, middle names and the name the person is known by.
REQUESTOR_EMAIL	VARCHAR2	(240)
DESTINATION_TYPE	VARCHAR2	(25)		Final destination of the purchased items
LOCATION_CODE	VARCHAR2	(60)		Location name.
ADDRESS_LINE	VARCHAR2	(720)		Location Address.
COUNTRY	VARCHAR2	(60)		Country.
POSTAL_CODE	VARCHAR2	(30)		Postal code.
TOWN_OR_CITY	VARCHAR2	(30)		Town or city.
STATE	VARCHAR2	(120)		State (US), Province of work (CA).

Query Text

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


SELECT REVISION_NUM
,      PO_RELEASE_ID
,      PO_DISTRIBUTION_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOC_ID
,      DELIVER_TO_LOCATION_ID
,      DISTRIBUTION_NUM
,      QUANTITY
,      REQUESTOR
,      REQUESTOR_EMAIL
,      DESTINATION_TYPE
,      LOCATION_CODE
,      ADDRESS_LINE
,      COUNTRY
,      POSTAL_CODE
,      TOWN_OR_CITY
,      STATE
FROM APPS.PO_CXML_DELIVERTO_ARCH_V;

Dependencies

[top of page]

APPS.PO_CXML_DELIVERTO_ARCH_V references the following:

APPS: HR_LOCATIONS_ALL; PER_ALL_PEOPLE_F; PO_DISTRIBUTIONS_ARCHIVE_ALL

APPS.PO_CXML_DELIVERTO_ARCH_V is referenced by following:

APPS: PO_XML_DELIVERY - show dependent code