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

TABLE: WSH.WSH_CC_TRANS_HEADERS

Object Details
Object Name: WSH_CC_TRANS_HEADERS
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_CC_TRANS_HEADERS
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_HEADER_ID NUMBER
Yes Primary Key of the table
TRANSACTION_CONTROL_ID NUMBER
Yes Foreign key references WSH_CC_TRANS_CONTROL.TRANSACTION_CONTROL_ID
ORIGINAL_SYSTEM_REFERENCE NUMBER
Yes Reference Number eg Order Header id (OM)
SHIP_FROM_ORG_ID NUMBER

Ship From org identifier
SHIP_TO_ORG_ID NUMBER

Ship to org identifier
INVOICE_TO_ORG_ID NUMBER

Invoice to Org Identifier
SOLD_TO_ORG_ID NUMBER

Sold 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
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
CUST_PARTY_NAME VARCHAR2 (240)
Customer name
CUST_PARTY_COUNTRY VARCHAR2 (240)
Customer Party Country
WF_ITEM_KEY NUMBER

Workflow Item Key
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
SF_CONTACT_NAME VARCHAR2 (240)
Ship from contact name
SF_PHONE VARCHAR2 (240)
Ship From Phone
SF_EMAIL VARCHAR2 (240)
Ship From email
SF_FAX VARCHAR2 (240)
Fax Number for Ship from
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
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)
Fax Number for Invoice to
CUST_PARTY_ADDRESS VARCHAR2 (240)
Customer address
CUST_PARTY_CITY VARCHAR2 (240)
City for the customer
CUST_PARTY_STATE VARCHAR2 (240)
Customer State
CUST_POSTAL_CODE VARCHAR2 (240)
Postal Code for Customer
CUST_CONTACT_NAME VARCHAR2 (240)
Customer Contact Name
CUST_PHONE VARCHAR2 (240)
Customer Phone Number
CUST_EMAIL VARCHAR2 (240)
Customer's email
CUST_FAX VARCHAR2 (240)
Customer's 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
DELIVER_TO_ORG_ID NUMBER

Deliver to Org id
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)
Delivery to contact name
DT_PHONE VARCHAR2 (240)
Deliver to Phone
DT_EMAIL VARCHAR2 (240)
Deliver to email
DT_FAX VARCHAR2 (240)
Deliver to fax
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_HEADER_ID
,      TRANSACTION_CONTROL_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      SOLD_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
,      IT_PARTY_NAME
,      IT_PARTY_ADDRESS
,      IT_PARTY_CITY
,      IT_PARTY_STATE
,      IT_PARTY_COUNTRY
,      IT_POSTAL_CODE
,      CUST_PARTY_NAME
,      CUST_PARTY_COUNTRY
,      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
,      IT_CONTACT_NAME
,      IT_PHONE
,      IT_EMAIL
,      IT_FAX
,      CUST_PARTY_ADDRESS
,      CUST_PARTY_CITY
,      CUST_PARTY_STATE
,      CUST_POSTAL_CODE
,      CUST_CONTACT_NAME
,      CUST_PHONE
,      CUST_EMAIL
,      CUST_FAX
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      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
FROM WSH.WSH_CC_TRANS_HEADERS;

Dependencies

[top of page]

WSH.WSH_CC_TRANS_HEADERS does not reference any database object

WSH.WSH_CC_TRANS_HEADERS is referenced by following:

SchemaWSH
ViewWSH_CC_TRANS_HEADERS#