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]

TABLE: EC.ECE_PO_DISTRIBUTIONS

Object Details

Object Name:	ECE_PO_DISTRIBUTIONS
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_PO_DISTRIBUTIONS
Subobject Name:
Status:	VALID

ECE_PO_DISTRIBUTIONS contains temporary project data and PO Distributions for
Purchase Orders. It contains information necessary in order to extract Project Accounting information for the Purchase Order (850/ORDERS) and the Purchase Order Change
(860/ORDCHG) transactions.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_PO_DISTRIBUTIONS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_RECORD_ID
ECE_PO_DISTRIBUTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RUN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RUN_ID	NUMBER		Yes	Run ID
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			PO Line Location ID
PO_DISTRIBUTION_ID	NUMBER			PO Distribution ID
PROJECT_ID	NUMBER			Unique Project ID
TASK_ID	NUMBER			Unique Project Task ID
DISTRIBUTION_NUM	NUMBER			PO Distribution Number
PROJECT_NUMBER	VARCHAR2	(25)		Project Number
PROJECT_TYPE	VARCHAR2	(20)		Project Type
TASK_NUMBER	VARCHAR2	(25)		Project Task 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	(25)		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_LOCATION_CODE_INT	VARCHAR2	(20)		Deliver to Location Code (Internal)
DELIVER_TO_LOCATION_CODE_EXT1	VARCHAR2	(20)		Deliver to Location Code (External1)
DELIVER_TO_LOCATION_CODE_EXT2	VARCHAR2	(20)		Deliver to Location Code (External 2)
DELIVER_TO_LOCATION_CODE_EXT3	VARCHAR2	(20)		Deliver to Location Code (External 3)
DELIVER_TO_LOCATION_CODE_EXT4	VARCHAR2	(20)		Deliver to Location Code(External 4)
DELIVER_TO_LOCATION_CODE_EXT5	VARCHAR2	(20)		Deliver to Location Code(External 5)
DELIVER_TO_SITE_NAME	VARCHAR2	(240)		Deliver to Site Name
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(Internal)
DELIVER_TO_REGION_2	VARCHAR2	(120)		Deliver to Region 2(Internal)
DELIVER_TO_REGION_3	VARCHAR2	(120)		Deliver to Region 3(Internal)
DELIVER_TO_CONTACT_JOB_TITLE	VARCHAR2	(30)		Deliver to Contact Job Title
DELIVER_TO_PHONE1_AREA_CODE	VARCHAR2	(10)		Deliver to Phone Area Code 1
DELIVER_TO_PHONE1	VARCHAR2	(60)		Deliver to Phone1
DELIVER_TO_PHONE2_AREA_CODE	VARCHAR2	(10)		Deliver to Phone2 Area code
DELIVER_TO_PHONE2	VARCHAR2	(60)		Deliver to Phone2
DELIVER_TO_PHONE3_AREA_CODE	VARCHAR2	(10)		Deliver to Phone3 Area Code
DELIVER_TO_PHONE3	VARCHAR2	(60)		Deliver to Phone3
DELIVER_TO_LOCATION_ID	NUMBER	(22)		Deliver to Location ID
DELIVER_TO_PERSON_ID	NUMBER	(22)		Deliver to Person ID
RELEASE_NUMBER	NUMBER	(22)		Release Number
SHIPMENT_NUMBER	NUMBER	(22)		Shipment Number
DELIVER_TO_COUNTRY_EXT1	VARCHAR2	(3)		Deliver to Country Ext1
DELIVER_TO_COUNTRY_EXT2	VARCHAR2	(3)		Deliver to Country Ext2
DELIVER_TO_COUNTRY_EXT3	VARCHAR2	(3)		Deliver to Country Ext3
DELIVER_TO_COUNTRY_EXT4	VARCHAR2	(3)		Deliver to Country Ext4
DELIVER_TO_COUNTRY_EXT5	VARCHAR2	(3)		Deliver to Country Ext5
DELIVER_TO_REGION_1_EXT1	VARCHAR2	(30)		Deliver to Region 1(External1)
DELIVER_TO_REGION_1_EXT2	VARCHAR2	(30)		Deliver to Region 1 (External 2)
DELIVER_TO_REGION_1_EXT3	VARCHAR2	(30)		Deliver to Region 1(External 3)
DELIVER_TO_REGION_1_EXT4	VARCHAR2	(30)		Deliver to Region 1 (External 4)
DELIVER_TO_REGION_1_EXT5	VARCHAR2	(30)		Deliver to Region 1(external 5)
DELIVER_TO_REGION_2_EXT1	VARCHAR2	(30)		Deliver to Region 2(External 1)
DELIVER_TO_REGION_2_EXT2	VARCHAR2	(30)		Deliver to Region 2(External 2)
DELIVER_TO_REGION_2_EXT3	VARCHAR2	(30)		Deliver to Region 2 (External 3)
DELIVER_TO_REGION_2_EXT4	VARCHAR2	(30)		Deliver to Region 2(External 4)
DELIVER_TO_REGION_2_EXT5	VARCHAR2	(30)		Deliver to Region 2(External 5)
DELIVER_TO_REGION_3_EXT1	VARCHAR2	(30)		Deliver to Region 3(External 1)
DELIVER_TO_REGION_3_EXT2	VARCHAR2	(30)		Deliver to Region 3(External 2)
DELIVER_TO_REGION_3_EXT3	VARCHAR2	(30)		Deliver to Region 3 (External 3)
DELIVER_TO_REGION_3_EXT4	VARCHAR2	(30)		Deliver to Region 3(External 4)
DELIVER_TO_REGION_3_EXT5	VARCHAR2	(30)		Deliver to Region 3(External 5)
TRANSACTION_RECORD_ID	NUMBER		Yes	Unique identifier which links the transaction base table to its associated extension table.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
DELIVER_TO_ADDRESS_LINE_4	VARCHAR2	(35)		Deliver to Address Line 4

Query Text

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


SELECT RUN_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PROJECT_ID
,      TASK_ID
,      DISTRIBUTION_NUM
,      PROJECT_NUMBER
,      PROJECT_TYPE
,      TASK_NUMBER
,      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_LOCATION_CODE_INT
,      DELIVER_TO_LOCATION_CODE_EXT1
,      DELIVER_TO_LOCATION_CODE_EXT2
,      DELIVER_TO_LOCATION_CODE_EXT3
,      DELIVER_TO_LOCATION_CODE_EXT4
,      DELIVER_TO_LOCATION_CODE_EXT5
,      DELIVER_TO_SITE_NAME
,      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_CONTACT_JOB_TITLE
,      DELIVER_TO_PHONE1_AREA_CODE
,      DELIVER_TO_PHONE1
,      DELIVER_TO_PHONE2_AREA_CODE
,      DELIVER_TO_PHONE2
,      DELIVER_TO_PHONE3_AREA_CODE
,      DELIVER_TO_PHONE3
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_ID
,      RELEASE_NUMBER
,      SHIPMENT_NUMBER
,      DELIVER_TO_COUNTRY_EXT1
,      DELIVER_TO_COUNTRY_EXT2
,      DELIVER_TO_COUNTRY_EXT3
,      DELIVER_TO_COUNTRY_EXT4
,      DELIVER_TO_COUNTRY_EXT5
,      DELIVER_TO_REGION_1_EXT1
,      DELIVER_TO_REGION_1_EXT2
,      DELIVER_TO_REGION_1_EXT3
,      DELIVER_TO_REGION_1_EXT4
,      DELIVER_TO_REGION_1_EXT5
,      DELIVER_TO_REGION_2_EXT1
,      DELIVER_TO_REGION_2_EXT2
,      DELIVER_TO_REGION_2_EXT3
,      DELIVER_TO_REGION_2_EXT4
,      DELIVER_TO_REGION_2_EXT5
,      DELIVER_TO_REGION_3_EXT1
,      DELIVER_TO_REGION_3_EXT2
,      DELIVER_TO_REGION_3_EXT3
,      DELIVER_TO_REGION_3_EXT4
,      DELIVER_TO_REGION_3_EXT5
,      TRANSACTION_RECORD_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DELIVER_TO_ADDRESS_LINE_4
FROM EC.ECE_PO_DISTRIBUTIONS;

Dependencies

[top of page]

EC.ECE_PO_DISTRIBUTIONS does not reference any database object

EC.ECE_PO_DISTRIBUTIONS is referenced by following:

APPS: ECE_PO_DISTRIBUTIONS