[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WSH_CC_TRANS_LINES# |
|---|---|
| Object Type: | VIEW |
| Owner: | WSH |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_LINE_ID | NUMBER | Yes | ||
| TRANSACTION_HEADER_ID | NUMBER | Yes | ||
| ORIGINAL_SYSTEM_LINE_REFERENCE | NUMBER | |||
| ORIGINAL_SYSTEM_REFERENCE | NUMBER | |||
| SHIP_FROM_ORG_ID | NUMBER | |||
| SHIP_TO_ORG_ID | NUMBER | |||
| INTMED_SHIP_TO_ORG_ID | NUMBER | |||
| SF_COUNTRY | VARCHAR2 | (35) | ||
| ST_COUNTRY | VARCHAR2 | (35) | ||
| SF_PARTY_NAME | VARCHAR2 | (240) | ||
| SF_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
| SF_PARTY_CITY | VARCHAR2 | (240) | ||
| SF_PARTY_STATE | VARCHAR2 | (240) | ||
| SF_PARTY_COUNTRY | VARCHAR2 | (240) | ||
| SF_POSTAL_CODE | VARCHAR2 | (240) | ||
| ST_PARTY_NAME | VARCHAR2 | (240) | ||
| ST_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
| ST_PARTY_CITY | VARCHAR2 | (240) | ||
| ST_PARTY_STATE | VARCHAR2 | (240) | ||
| ST_PARTY_COUNTRY | VARCHAR2 | (240) | ||
| ST_POSTAL_CODE | VARCHAR2 | (240) | ||
| INT_PARTY_NAME | VARCHAR2 | (240) | ||
| INT_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
| INT_PARTY_CITY | VARCHAR2 | (240) | ||
| INT_PARTY_STATE | VARCHAR2 | (240) | ||
| INT_PARTY_COUNTRY | VARCHAR2 | (240) | ||
| INT_POSTAL_CODE | VARCHAR2 | (240) | ||
| PR_LOOKUP | VARCHAR2 | (1) | ||
| PR_PRODUCT_ID | VARCHAR2 | (35) | ||
| PR_END_USE_TYPE | VARCHAR2 | (35) | ||
| PR_CLASSIFIER_TYPE | VARCHAR2 | (35) | ||
| PR_CLASSIFIER_LABEL | VARCHAR2 | (35) | ||
| PR_CLASSIFICATION_TYPE | VARCHAR2 | (35) | ||
| PR_CLASSIFICATION_LABEL | VARCHAR2 | (35) | ||
| PR_ENC_MASSMARKET | VARCHAR2 | (1) | ||
| PR_ENC_PUBLIC | VARCHAR2 | (1) | ||
| PR_ENC_TYPE | VARCHAR2 | (100) | ||
| LICENSE_EXCEPTION | VARCHAR2 | (35) | ||
| LICENSE_EXCEPTION_TYPE | VARCHAR2 | (35) | ||
| LICENSE_VALID_FR_DT_VALUE | VARCHAR2 | (30) | ||
| LICENSE_VALID_TO_DT_VALUE | VARCHAR2 | (30) | ||
| WF_ITEM_KEY | NUMBER | |||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| SF_CONTACT_NAME | VARCHAR2 | (240) | ||
| SF_PHONE | VARCHAR2 | (240) | ||
| SF_EMAIL | VARCHAR2 | (240) | ||
| SF_FAX | VARCHAR2 | (240) | ||
| ST_CONTACT_NAME | VARCHAR2 | (240) | ||
| ST_PHONE | VARCHAR2 | (240) | ||
| ST_EMAIL | VARCHAR2 | (240) | ||
| ST_FAX | VARCHAR2 | (240) | ||
| INT_CONTACT_NAME | VARCHAR2 | (240) | ||
| INT_PHONE | VARCHAR2 | (240) | ||
| INT_EMAIL | VARCHAR2 | (240) | ||
| INT_FAX | VARCHAR2 | (240) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | |||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | |||
| LAST_UPDATE_LOGIN | NUMBER | |||
| INVOICE_TO_ORG_ID | NUMBER | |||
| DELIVER_TO_ORG_ID | NUMBER | |||
| DT_PARTY_NAME | VARCHAR2 | (240) | ||
| DT_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
| DT_PARTY_CITY | VARCHAR2 | (240) | ||
| DT_PARTY_STATE | VARCHAR2 | (240) | ||
| DT_PARTY_COUNTRY | VARCHAR2 | (240) | ||
| DT_POSTAL_CODE | VARCHAR2 | (240) | ||
| DT_CONTACT_NAME | VARCHAR2 | (240) | ||
| DT_PHONE | VARCHAR2 | (240) | ||
| DT_EMAIL | VARCHAR2 | (240) | ||
| DT_FAX | VARCHAR2 | (240) | ||
| IT_PARTY_NAME | VARCHAR2 | (240) | ||
| IT_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
| IT_PARTY_CITY | VARCHAR2 | (240) | ||
| IT_PARTY_STATE | VARCHAR2 | (240) | ||
| IT_PARTY_COUNTRY | VARCHAR2 | (240) | ||
| IT_POSTAL_CODE | VARCHAR2 | (240) | ||
| IT_CONTACT_NAME | VARCHAR2 | (240) | ||
| IT_PHONE | VARCHAR2 | (240) | ||
| IT_EMAIL | VARCHAR2 | (240) | ||
| IT_FAX | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_LINE_ID
, TRANSACTION_HEADER_ID
, ORIGINAL_SYSTEM_LINE_REFERENCE
, ORIGINAL_SYSTEM_REFERENCE
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID
, INTMED_SHIP_TO_ORG_ID
, SF_COUNTRY
, ST_COUNTRY
, SF_PARTY_NAME
, SF_PARTY_ADDRESS
, SF_PARTY_CITY
, SF_PARTY_STATE
, SF_PARTY_COUNTRY
, SF_POSTAL_CODE
, ST_PARTY_NAME
, ST_PARTY_ADDRESS
, ST_PARTY_CITY
, ST_PARTY_STATE
, ST_PARTY_COUNTRY
, ST_POSTAL_CODE
, INT_PARTY_NAME
, INT_PARTY_ADDRESS
, INT_PARTY_CITY
, INT_PARTY_STATE
, INT_PARTY_COUNTRY
, INT_POSTAL_CODE
, PR_LOOKUP
, PR_PRODUCT_ID
, PR_END_USE_TYPE
, PR_CLASSIFIER_TYPE
, PR_CLASSIFIER_LABEL
, PR_CLASSIFICATION_TYPE
, PR_CLASSIFICATION_LABEL
, PR_ENC_MASSMARKET
, PR_ENC_PUBLIC
, PR_ENC_TYPE
, LICENSE_EXCEPTION
, LICENSE_EXCEPTION_TYPE
, LICENSE_VALID_FR_DT_VALUE
, LICENSE_VALID_TO_DT_VALUE
, WF_ITEM_KEY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SF_CONTACT_NAME
, SF_PHONE
, SF_EMAIL
, SF_FAX
, ST_CONTACT_NAME
, ST_PHONE
, ST_EMAIL
, ST_FAX
, INT_CONTACT_NAME
, INT_PHONE
, INT_EMAIL
, INT_FAX
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, INVOICE_TO_ORG_ID
, DELIVER_TO_ORG_ID
, DT_PARTY_NAME
, DT_PARTY_ADDRESS
, DT_PARTY_CITY
, DT_PARTY_STATE
, DT_PARTY_COUNTRY
, DT_POSTAL_CODE
, DT_CONTACT_NAME
, DT_PHONE
, DT_EMAIL
, DT_FAX
, IT_PARTY_NAME
, IT_PARTY_ADDRESS
, IT_PARTY_CITY
, IT_PARTY_STATE
, IT_PARTY_COUNTRY
, IT_POSTAL_CODE
, IT_CONTACT_NAME
, IT_PHONE
, IT_EMAIL
, IT_FAX
FROM WSH.WSH_CC_TRANS_LINES#;
WSH
WSH_CC_TRANS_LINES
APPS
WSH_CC_TRANS_LINES
|
|
|
|