Skip to content

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

VIEW: EC.ECE_PO_DISTRIBUTIONS#

Object Details
Object Name: ECE_PO_DISTRIBUTIONS#
Object Type: VIEW
Owner: EC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER
Yes
PO_HEADER_ID NUMBER

PO_RELEASE_ID NUMBER

PO_LINE_ID NUMBER

LINE_LOCATION_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

DISTRIBUTION_NUM NUMBER

PROJECT_NUMBER VARCHAR2 (25)
PROJECT_TYPE VARCHAR2 (20)
TASK_NUMBER VARCHAR2 (25)
QUANTITY_ORDERED NUMBER

QUANTITY_DELIVERED NUMBER

QUANTITY_BILLED NUMBER

QUANTITY_CANCELLED NUMBER

AMOUNT_BILLED NUMBER

CONVERSION_RATE NUMBER

CONVERSION_DATE DATE

DESTINATION_TYPE_CODE VARCHAR2 (25)
DS_ATTRIBUTE_CATEGORY VARCHAR2 (25)
DS_ATTRIBUTE1 VARCHAR2 (150)
DS_ATTRIBUTE2 VARCHAR2 (150)
DS_ATTRIBUTE3 VARCHAR2 (150)
DS_ATTRIBUTE4 VARCHAR2 (150)
DS_ATTRIBUTE5 VARCHAR2 (150)
DS_ATTRIBUTE6 VARCHAR2 (150)
DS_ATTRIBUTE7 VARCHAR2 (150)
DS_ATTRIBUTE8 VARCHAR2 (150)
DS_ATTRIBUTE9 VARCHAR2 (150)
DS_ATTRIBUTE10 VARCHAR2 (150)
DS_ATTRIBUTE11 VARCHAR2 (150)
DS_ATTRIBUTE12 VARCHAR2 (150)
DS_ATTRIBUTE13 VARCHAR2 (150)
DS_ATTRIBUTE14 VARCHAR2 (150)
DS_ATTRIBUTE15 VARCHAR2 (150)
DELIVER_TO_LOCATION_CODE VARCHAR2 (60)
DELIVER_TO_LOCATION_CODE_INT VARCHAR2 (20)
DELIVER_TO_LOCATION_CODE_EXT1 VARCHAR2 (20)
DELIVER_TO_LOCATION_CODE_EXT2 VARCHAR2 (20)
DELIVER_TO_LOCATION_CODE_EXT3 VARCHAR2 (20)
DELIVER_TO_LOCATION_CODE_EXT4 VARCHAR2 (20)
DELIVER_TO_LOCATION_CODE_EXT5 VARCHAR2 (20)
DELIVER_TO_SITE_NAME VARCHAR2 (240)
DELIVER_TO_CONTACT_LAST_NAME VARCHAR2 (150)
DELIVER_TO_CONTACT_FIRST_NAME VARCHAR2 (150)
DELIVER_TO_ADDRESS_LINE_1 VARCHAR2 (240)
DELIVER_TO_ADDRESS_LINE_2 VARCHAR2 (240)
DELIVER_TO_ADDRESS_LINE_3 VARCHAR2 (240)
DELIVER_TO_CITY VARCHAR2 (30)
DELIVER_TO_POSTAL_CODE VARCHAR2 (30)
DELIVER_TO_COUNTRY VARCHAR2 (60)
DELIVER_TO_REGION_1 VARCHAR2 (120)
DELIVER_TO_REGION_2 VARCHAR2 (120)
DELIVER_TO_REGION_3 VARCHAR2 (120)
DELIVER_TO_CONTACT_JOB_TITLE VARCHAR2 (30)
DELIVER_TO_PHONE1_AREA_CODE VARCHAR2 (10)
DELIVER_TO_PHONE1 VARCHAR2 (60)
DELIVER_TO_PHONE2_AREA_CODE VARCHAR2 (10)
DELIVER_TO_PHONE2 VARCHAR2 (60)
DELIVER_TO_PHONE3_AREA_CODE VARCHAR2 (10)
DELIVER_TO_PHONE3 VARCHAR2 (60)
DELIVER_TO_LOCATION_ID NUMBER (22)
DELIVER_TO_PERSON_ID NUMBER (22)
RELEASE_NUMBER NUMBER (22)
SHIPMENT_NUMBER NUMBER (22)
DELIVER_TO_COUNTRY_EXT1 VARCHAR2 (3)
DELIVER_TO_COUNTRY_EXT2 VARCHAR2 (3)
DELIVER_TO_COUNTRY_EXT3 VARCHAR2 (3)
DELIVER_TO_COUNTRY_EXT4 VARCHAR2 (3)
DELIVER_TO_COUNTRY_EXT5 VARCHAR2 (3)
DELIVER_TO_REGION_1_EXT1 VARCHAR2 (30)
DELIVER_TO_REGION_1_EXT2 VARCHAR2 (30)
DELIVER_TO_REGION_1_EXT3 VARCHAR2 (30)
DELIVER_TO_REGION_1_EXT4 VARCHAR2 (30)
DELIVER_TO_REGION_1_EXT5 VARCHAR2 (30)
DELIVER_TO_REGION_2_EXT1 VARCHAR2 (30)
DELIVER_TO_REGION_2_EXT2 VARCHAR2 (30)
DELIVER_TO_REGION_2_EXT3 VARCHAR2 (30)
DELIVER_TO_REGION_2_EXT4 VARCHAR2 (30)
DELIVER_TO_REGION_2_EXT5 VARCHAR2 (30)
DELIVER_TO_REGION_3_EXT1 VARCHAR2 (30)
DELIVER_TO_REGION_3_EXT2 VARCHAR2 (30)
DELIVER_TO_REGION_3_EXT3 VARCHAR2 (30)
DELIVER_TO_REGION_3_EXT4 VARCHAR2 (30)
DELIVER_TO_REGION_3_EXT5 VARCHAR2 (30)
TRANSACTION_RECORD_ID NUMBER
Yes
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

DELIVER_TO_ADDRESS_LINE_4 VARCHAR2 (35)
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# references the following:

SchemaEC
TableECE_PO_DISTRIBUTIONS
EC.ECE_PO_DISTRIBUTIONS# is referenced by following:

SchemaAPPS
SynonymECE_PO_DISTRIBUTIONS