[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#;
|
|
|