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

TABLE: WSH.WSH_CC_TRANS_LINES

Object Details
Object Name: WSH_CC_TRANS_LINES
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_CC_TRANS_LINES
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

WSH.WSH_CC_TRANS_LINES does not reference any database object

WSH.WSH_CC_TRANS_LINES is referenced by following:

SchemaWSH
ViewWSH_CC_TRANS_LINES#