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.ECE_PO_DISTRIBUTIONS_V

Object Details

Object Name:	ECE_PO_DISTRIBUTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EC.ECE_PO_DISTRIBUTIONS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view extracts distribution information
for the outbound Purchase Order (850/ORDERS) and
outbound Purchase Order Change (860/ORDCHG) transactions.

[View Source]

Columns

Name	Datatype	Length	Comments
PO_HEADER_ID	NUMBER		PO Header ID
PO_RELEASE_ID	NUMBER		PO Release ID
PO_LINE_ID	NUMBER		PO Line ID
LINE_LOCATION_ID	NUMBER		Line Location ID
PO_DISTRIBUTION_ID	NUMBER		PO Distribution ID
PROJECT_ID	NUMBER		Project ID
TASK_ID	NUMBER		Task ID
DISTRIBUTION_NUM	NUMBER		Distribution Number
QUANTITY_ORDERED	NUMBER		Quantity Ordered
QUANTITY_DELIVERED	NUMBER		Quantity Delivered
QUANTITY_BILLED	NUMBER		Quantity Billed
QUANTITY_CANCELLED	NUMBER		Quantity Cancelled
AMOUNT_BILLED	NUMBER		Amount Billed
CONVERSION_RATE	NUMBER		Conversion Rate
CONVERSION_DATE	DATE		Conversion Date
DESTINATION_TYPE_CODE	VARCHAR2	(25)	Destination Type Code
DS_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Distribution Attribute Category
DS_ATTRIBUTE1	VARCHAR2	(150)	Distribution Attribute 1
DS_ATTRIBUTE2	VARCHAR2	(150)	Distribution Attribute 2
DS_ATTRIBUTE3	VARCHAR2	(150)	Distribution Attribute 3
DS_ATTRIBUTE4	VARCHAR2	(150)	Distribution Attribute 4
DS_ATTRIBUTE5	VARCHAR2	(150)	Distribution Attribute 5
DS_ATTRIBUTE6	VARCHAR2	(150)	Distribution Attribute 6
DS_ATTRIBUTE7	VARCHAR2	(150)	Distribution Attribute 7
DS_ATTRIBUTE8	VARCHAR2	(150)	Distribution Attribute 8
DS_ATTRIBUTE9	VARCHAR2	(150)	Distribution Attribute 9
DS_ATTRIBUTE10	VARCHAR2	(150)	Distribution Attribute 10
DS_ATTRIBUTE11	VARCHAR2	(150)	Distribution Attribute 11
DS_ATTRIBUTE12	VARCHAR2	(150)	Distribution Attribute 12
DS_ATTRIBUTE13	VARCHAR2	(150)	Distribution Attribute 13
DS_ATTRIBUTE14	VARCHAR2	(150)	Distribution Attribute 14
DS_ATTRIBUTE15	VARCHAR2	(150)	Distribution Attribute 15
DELIVER_TO_LOCATION_CODE	VARCHAR2	(60)	Deliver to Location Code
DELIVER_TO_CONTACT_LAST_NAME	VARCHAR2	(150)	Deliver to Contact Last Name
DELIVER_TO_CONTACT_FIRST_NAME	VARCHAR2	(150)	Deliver to Contact First Name
DELIVER_TO_ADDRESS_LINE_1	VARCHAR2	(240)	Deliver to Address Line 1
DELIVER_TO_ADDRESS_LINE_2	VARCHAR2	(240)	Deliver to address Line 2
DELIVER_TO_ADDRESS_LINE_3	VARCHAR2	(240)	Deliver to Address Line 3
DELIVER_TO_CITY	VARCHAR2	(30)	Deliver to City
DELIVER_TO_POSTAL_CODE	VARCHAR2	(30)	Deliver to Postal Code
DELIVER_TO_COUNTRY	VARCHAR2	(60)	Deliver to Country
DELIVER_TO_REGION_1	VARCHAR2	(120)	Deliver to Region 1
DELIVER_TO_REGION_2	VARCHAR2	(120)	Deliver to Region 2
DELIVER_TO_REGION_3	VARCHAR2	(120)	Deliver to Region 3
DELIVER_TO_PHONE1	VARCHAR2	(60)	Deliver to Phone 1
DELIVER_TO_PHONE2	VARCHAR2	(60)	Deliver to Phone 2
DELIVER_TO_PHONE3	VARCHAR2	(60)	Deliver to Phone3
DELIVER_TO_LOCATION_ID	NUMBER		Deliver to Location ID
DELIVER_TO_PERSON_ID	NUMBER	(9)	Deliver to Person ID
POR_RELEASE_NUM	NUMBER		PO Release Number
SHIPMENT_NUMBER	NUMBER		Shipment Number
DELIVER_TO_EDI_LOCATION_CODE	VARCHAR2	(35)	DELIVER_TO_EDI_LOCATION_CODE

Query Text

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


SELECT PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PROJECT_ID
,      TASK_ID
,      DISTRIBUTION_NUM
,      QUANTITY_ORDERED
,      QUANTITY_DELIVERED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      AMOUNT_BILLED
,      CONVERSION_RATE
,      CONVERSION_DATE
,      DESTINATION_TYPE_CODE
,      DS_ATTRIBUTE_CATEGORY
,      DS_ATTRIBUTE1
,      DS_ATTRIBUTE2
,      DS_ATTRIBUTE3
,      DS_ATTRIBUTE4
,      DS_ATTRIBUTE5
,      DS_ATTRIBUTE6
,      DS_ATTRIBUTE7
,      DS_ATTRIBUTE8
,      DS_ATTRIBUTE9
,      DS_ATTRIBUTE10
,      DS_ATTRIBUTE11
,      DS_ATTRIBUTE12
,      DS_ATTRIBUTE13
,      DS_ATTRIBUTE14
,      DS_ATTRIBUTE15
,      DELIVER_TO_LOCATION_CODE
,      DELIVER_TO_CONTACT_LAST_NAME
,      DELIVER_TO_CONTACT_FIRST_NAME
,      DELIVER_TO_ADDRESS_LINE_1
,      DELIVER_TO_ADDRESS_LINE_2
,      DELIVER_TO_ADDRESS_LINE_3
,      DELIVER_TO_CITY
,      DELIVER_TO_POSTAL_CODE
,      DELIVER_TO_COUNTRY
,      DELIVER_TO_REGION_1
,      DELIVER_TO_REGION_2
,      DELIVER_TO_REGION_3
,      DELIVER_TO_PHONE1
,      DELIVER_TO_PHONE2
,      DELIVER_TO_PHONE3
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_ID
,      POR_RELEASE_NUM
,      SHIPMENT_NUMBER
,      DELIVER_TO_EDI_LOCATION_CODE
FROM APPS.ECE_PO_DISTRIBUTIONS_V;

Dependencies

[top of page]

APPS.ECE_PO_DISTRIBUTIONS_V references the following:

APPS: HR_LOCATIONS_ALL; PER_ALL_PEOPLE_F; PO_DISTRIBUTIONS; PO_LINE_LOCATIONS; PO_RELEASES

APPS.ECE_PO_DISTRIBUTIONS_V is not referenced by any database object