eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: WSH.WSH_CC_RESPONSE_LINES

Object Details

Object Name:	WSH_CC_RESPONSE_LINES
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_CC_RESPONSE_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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_CC_RESPONSE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESPONSE_HEADER_ID DENIED_PARTY_FLAG
WSH_CC_RESPONSE_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESPONSE_HEADER_ID EMBARGO_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
RESPONSE_LINE_ID	NUMBER		Yes	Primary Key for the Table
RESPONSE_HEADER_ID	NUMBER		Yes	Foreign Key - references WSH_CC_RESPONSE_HEADERS.RESPONSE_HEADER_ID
SERVICE_TYPE_CODE	VARCHAR2	(35)		Service Type Code references - WSH_CC_SERVICE_SETUPS.SERVICE_TYPE_CODE
USER_DEF_ID1	VARCHAR2	(70)		In request value supplied in User defined attribute at transaction level
USER_DEF_ID2	VARCHAR2	(70)		Currently not in use
TRANSACTION_SOURCE_TYPE	VARCHAR2	(35)		Transaction Source Identifier
EMBARGO_FLAG	VARCHAR2	(1)		Indicates if the embargo exists for Export Shipments
LICENSE_REQUIRED	VARCHAR2	(1)		Indicates if the license is required for Export Shipments
LICENSE_CLASSIFIER	VARCHAR2	(10)		Type attribute of License element in the request
LICENSE_EXCEPTION	VARCHAR2	(35)		Value of License Exception if Exception is permitted for obtaining the license for Export Shipment
LICENSE_EXC_TYPE	VARCHAR2	(240)		License Exception Type
EXCEPTION_TYPE_CODE	VARCHAR2	(35)		Valid Exception Symbol for the License Exception
RED_FLAG_WORDS	VARCHAR2	(2000)		Indicates that a potentail match was found for the Red Flag checking
DENIED_PARTY_FLAG	VARCHAR2	(1)		Indicates if any denied Parties were found
REASON	VARCHAR2	(240)		Reasons Listing, delimited list
ERROR_CODE	VARCHAR2	(35)		Error Code returned along with response
ERROR_TEXT	VARCHAR2	(2000)		Error Text
ERROR_SOURCE	VARCHAR2	(240)		Error Source returned along with the Request
ERROR_TYPE	VARCHAR2	(30)		Error Type returned along with Response
ENTITY_CODE	VARCHAR2	(35)		Party Type eg SHIP_TO, SHIP_FROM or SOLD_TO
ENTITY_ID	NUMBER			Party Type identifier eg SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID or SOLD_TO_ORG_ID etc.
ORIGINAL_SYSTEM_REFERENCE	NUMBER			Reference Number eg Order Header id (OM)
ORIGINAL_SYSTEM_LINE_REFERENCE	NUMBER			Reference Number eg Order Line id (OM)
CREATION_DATE	VARCHAR2	(240)		Standard Who Columns
CREATED_BY	NUMBER			Standard Who Columns
LAST_UPDATED_BY	NUMBER			Standard Who Columns
LAST_UPDATE_DATE	DATE			Standard Who Columns
LAST_UPDATE_LOGIN	NUMBER			Standard Who Columns

Query Text

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


SELECT RESPONSE_LINE_ID
,      RESPONSE_HEADER_ID
,      SERVICE_TYPE_CODE
,      USER_DEF_ID1
,      USER_DEF_ID2
,      TRANSACTION_SOURCE_TYPE
,      EMBARGO_FLAG
,      LICENSE_REQUIRED
,      LICENSE_CLASSIFIER
,      LICENSE_EXCEPTION
,      LICENSE_EXC_TYPE
,      EXCEPTION_TYPE_CODE
,      RED_FLAG_WORDS
,      DENIED_PARTY_FLAG
,      REASON
,      ERROR_CODE
,      ERROR_TEXT
,      ERROR_SOURCE
,      ERROR_TYPE
,      ENTITY_CODE
,      ENTITY_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM WSH.WSH_CC_RESPONSE_LINES;

Dependencies

[top of page]

WSH.WSH_CC_RESPONSE_LINES does not reference any database object

WSH.WSH_CC_RESPONSE_LINES is referenced by following:

WSH: WSH_CC_RESPONSE_LINES#