[Home] [Help] [Dependency Information]
Object Name: | WSH_CC_TRANS_LINES |
---|---|
Object Type: | TABLE |
Owner: | WSH |
FND Design Data: | WSH.WSH_CC_TRANS_LINES |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_LINE_ID | NUMBER | Yes | Primary key for the table | |
TRANSACTION_HEADER_ID | NUMBER | Yes | Foreign key references WSH_CC_TRANS_HEADERS.TRANSACTION_HEADER_ID | |
ORIGINAL_SYSTEM_LINE_REFERENCE | NUMBER | reference Order Line Number | ||
ORIGINAL_SYSTEM_REFERENCE | NUMBER | reference Order Header id (OM) | ||
SHIP_FROM_ORG_ID | NUMBER | Ship from org identifier | ||
SHIP_TO_ORG_ID | NUMBER | Ship to org identifier | ||
INTMED_SHIP_TO_ORG_ID | NUMBER | Intermediate Ship to org identifier | ||
SF_COUNTRY | VARCHAR2 | (35) | Ship from country | |
ST_COUNTRY | VARCHAR2 | (35) | Ship to country | |
SF_PARTY_NAME | VARCHAR2 | (240) | Ship from party name | |
SF_PARTY_ADDRESS | VARCHAR2 | (2000) | Ship from Party address | |
SF_PARTY_CITY | VARCHAR2 | (240) | Ship from party city | |
SF_PARTY_STATE | VARCHAR2 | (240) | Ship from party state | |
SF_PARTY_COUNTRY | VARCHAR2 | (240) | Ship from party country | |
SF_POSTAL_CODE | VARCHAR2 | (240) | Ship from postal code | |
ST_PARTY_NAME | VARCHAR2 | (240) | Ship to party name | |
ST_PARTY_ADDRESS | VARCHAR2 | (2000) | Ship to party address | |
ST_PARTY_CITY | VARCHAR2 | (240) | Ship to party city | |
ST_PARTY_STATE | VARCHAR2 | (240) | Ship to party state | |
ST_PARTY_COUNTRY | VARCHAR2 | (240) | Ship to party country | |
ST_POSTAL_CODE | VARCHAR2 | (240) | Ship to postal code | |
INT_PARTY_NAME | VARCHAR2 | (240) | Intermediate Party name | |
INT_PARTY_ADDRESS | VARCHAR2 | (2000) | Intermediate party Address | |
INT_PARTY_CITY | VARCHAR2 | (240) | Intermediate Party City | |
INT_PARTY_STATE | VARCHAR2 | (240) | Intermediate party state | |
INT_PARTY_COUNTRY | VARCHAR2 | (240) | Intermediate Party Country | |
INT_POSTAL_CODE | VARCHAR2 | (240) | Intermediate Postal Code | |
PR_LOOKUP | VARCHAR2 | (1) | Product Lookup | |
PR_PRODUCT_ID | VARCHAR2 | (35) | Product Identifier | |
PR_END_USE_TYPE | VARCHAR2 | (35) | Product End Use Type | |
PR_CLASSIFIER_TYPE | VARCHAR2 | (35) | Product Classifier Type | |
PR_CLASSIFIER_LABEL | VARCHAR2 | (35) | Product Classifier Label | |
PR_CLASSIFICATION_TYPE | VARCHAR2 | (35) | Product Classification type | |
PR_CLASSIFICATION_LABEL | VARCHAR2 | (35) | Product Classification label | |
PR_ENC_MASSMARKET | VARCHAR2 | (1) | Product encryption for the Mass market | |
PR_ENC_PUBLIC | VARCHAR2 | (1) | Indicates if the product is publicly available | |
PR_ENC_TYPE | VARCHAR2 | (100) | Type of encryption used for the product | |
LICENSE_EXCEPTION | VARCHAR2 | (35) | License number or exception depending on the exception type | |
LICENSE_EXCEPTION_TYPE | VARCHAR2 | (35) | License exception Type | |
LICENSE_VALID_FR_DT_VALUE | VARCHAR2 | (30) | License Validity Start date | |
LICENSE_VALID_TO_DT_VALUE | VARCHAR2 | (30) | License Validity End Date | |
WF_ITEM_KEY | NUMBER | Workflow Item Key | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfields | |
SF_CONTACT_NAME | VARCHAR2 | (240) | Ship From Contact name | |
SF_PHONE | VARCHAR2 | (240) | Ship From Phone Number | |
SF_EMAIL | VARCHAR2 | (240) | Ship From email | |
SF_FAX | VARCHAR2 | (240) | Ship From fax number | |
ST_CONTACT_NAME | VARCHAR2 | (240) | Ship to contact name | |
ST_PHONE | VARCHAR2 | (240) | Ship to phone | |
ST_EMAIL | VARCHAR2 | (240) | Ship to email | |
ST_FAX | VARCHAR2 | (240) | Ship to fax number | |
INT_CONTACT_NAME | VARCHAR2 | (240) | Intermediate Contact Name | |
INT_PHONE | VARCHAR2 | (240) | Intermediate Phone Number | |
INT_EMAIL | VARCHAR2 | (240) | Intermediate email | |
INT_FAX | VARCHAR2 | (240) | Intermediate Fax Number | |
CREATION_DATE | DATE | Standard Who Columns | ||
CREATED_BY | NUMBER | Standard Who Columns | ||
LAST_UPDATE_DATE | DATE | Standard Who Columns | ||
LAST_UPDATED_BY | NUMBER | Standard Who Columns | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Columns | ||
INVOICE_TO_ORG_ID | NUMBER | Invoice to Org identifier | ||
DELIVER_TO_ORG_ID | NUMBER | Deliver to Org identifier | ||
DT_PARTY_NAME | VARCHAR2 | (240) | Deliver to party Name | |
DT_PARTY_ADDRESS | VARCHAR2 | (2000) | Deliver to party Address | |
DT_PARTY_CITY | VARCHAR2 | (240) | Deliver to Party City | |
DT_PARTY_STATE | VARCHAR2 | (240) | Deliver to party state | |
DT_PARTY_COUNTRY | VARCHAR2 | (240) | Deliver to party Country | |
DT_POSTAL_CODE | VARCHAR2 | (240) | Deliver to postal Code | |
DT_CONTACT_NAME | VARCHAR2 | (240) | Deliver to contact Name | |
DT_PHONE | VARCHAR2 | (240) | Deliver to Phone Number | |
DT_EMAIL | VARCHAR2 | (240) | Deliver to email | |
DT_FAX | VARCHAR2 | (240) | Deliver to fax Number | |
IT_PARTY_NAME | VARCHAR2 | (240) | Invoice to Party Name | |
IT_PARTY_ADDRESS | VARCHAR2 | (2000) | Invoice to party address | |
IT_PARTY_CITY | VARCHAR2 | (240) | Invoice to Party City | |
IT_PARTY_STATE | VARCHAR2 | (240) | Invoice to Party State | |
IT_PARTY_COUNTRY | VARCHAR2 | (240) | Invoice to Party Country | |
IT_POSTAL_CODE | VARCHAR2 | (240) | Invoice to Postal Code | |
IT_CONTACT_NAME | VARCHAR2 | (240) | Invoice to Contact name | |
IT_PHONE | VARCHAR2 | (240) | Invoice to Phone | |
IT_EMAIL | VARCHAR2 | (240) | Invoice to email | |
IT_FAX | VARCHAR2 | (240) | Invoice to fax Number |
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 does not reference any database object
WSH.WSH_CC_TRANS_LINES is referenced by following:
|
|
|