[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_PO_DISTRIBUTIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | EC |
| Subobject Name: | |
| Status: | VALID |
| 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) |
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#;
EC
ECE_PO_DISTRIBUTIONS
APPS
ECE_PO_DISTRIBUTIONS
|
|
|
|