[Home] [Help] [Dependency Information]
Object Name: | WSH_OTM_SYNC_REF_DATA |
---|---|
Object Type: | TABLE |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
OTM Integration - store locations/items interfaced to OTM
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_OTM_SYNC_REF_DATA_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SYNC_REF_ID |
WSH_OTM_SYNC_REF_DATA_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ENTITY_ID
ENTITY_TYPE PARENT_ENTITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYNC_REF_ID | NUMBER | Yes | Synchronization Reference Data Identifier (PK) | |
ENTITY_ID | NUMBER | Yes | Entity Identifier. Foreign Key to location_id in HZ_LOCATIONS, HR_LOCATIONS_ALL | |
PARENT_ENTITY_ID | NUMBER | Yes | Parent Entity Identifier. Foreign Key to cust_account_id in HZ_CUST_ACCOUNTS, party_id in HZ_PARTIES, organization_id in HR_ALL_ORGANIZATION_UNITS | |
ENTITY_TYPE | VARCHAR2 | (30) | Yes | Type of entity. Following are the possible values : 'ORG_LOC', 'CUST_LOC', 'ITEM' |
SUBSTITUTE_ENTITY | VARCHAR2 | (50) | Substitute Entity Identifier when the same entity is associated to more than one parent | |
LAST_SENT_DATE | DATE | Yes | Last date on which the corresponding reference entity data was sent | |
CALLED_BY_MODULE | VARCHAR2 | (50) | Called By Module. Not used | |
ADDITIONAL_NUM | NUMBER | Additional Number column. Not used | ||
ADDITIONAL_CHAR | VARCHAR2 | (50) | Additional Character column. Not used | |
ADDITIONAL_DATE | DATE | Additional Date column. Not used | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT SYNC_REF_ID
, ENTITY_ID
, PARENT_ENTITY_ID
, ENTITY_TYPE
, SUBSTITUTE_ENTITY
, LAST_SENT_DATE
, CALLED_BY_MODULE
, ADDITIONAL_NUM
, ADDITIONAL_CHAR
, ADDITIONAL_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM WSH.WSH_OTM_SYNC_REF_DATA;
WSH.WSH_OTM_SYNC_REF_DATA does not reference any database object
WSH.WSH_OTM_SYNC_REF_DATA is referenced by following:
|
|
|