[Home] [Help] [Dependency Information]
Object Name: | WSH_CC_RESPONSE_LINES |
---|---|
Object Type: | TABLE |
Owner: | WSH |
FND Design Data: | WSH.WSH_CC_RESPONSE_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: |
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 |
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 |
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;
WSH.WSH_CC_RESPONSE_LINES does not reference any database object
WSH.WSH_CC_RESPONSE_LINES is referenced by following:
|
|
|