[Home] [Help] [Dependency Information]
Object Name: | WSH_CALENDAR_ASSIGNMENTS |
---|---|
Object Type: | TABLE |
Owner: | WSH |
FND Design Data: | WSH.WSH_CALENDAR_ASSIGNMENTS |
Subobject Name: | |
Status: | VALID |
WSH_CALENDAR_ASSIGNMENTS contains calendar assignments.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSH_CALENDAR_ASSIGNMENTS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | CALENDAR_ASSIGNMENT_ID |
WSH_CALENDAR_ASSIGNMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | CALENDAR_CODE |
WSH_CALENDAR_ASSIGNMENTS_N10 | NORMAL | NONUNIQUE | APPS_TS_SEED | FREIGHT_ORG_ID |
WSH_CALENDAR_ASSIGNMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | LOCATION_ASSOCIATION_ID |
WSH_CALENDAR_ASSIGNMENTS_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | ORGANIZATION_ID |
WSH_CALENDAR_ASSIGNMENTS_N4 | NORMAL | NONUNIQUE | APPS_TS_SEED | LOCATION_ID |
WSH_CALENDAR_ASSIGNMENTS_N5 | NORMAL | NONUNIQUE | APPS_TS_SEED | VENDOR_ID |
WSH_CALENDAR_ASSIGNMENTS_N6 | NORMAL | NONUNIQUE | APPS_TS_SEED | VENDOR_SITE_ID |
WSH_CALENDAR_ASSIGNMENTS_N7 | NORMAL | NONUNIQUE | APPS_TS_SEED | CUSTOMER_ID |
WSH_CALENDAR_ASSIGNMENTS_N8 | NORMAL | NONUNIQUE | APPS_TS_SEED | CUSTOMER_SITE_USE_ID |
WSH_CALENDAR_ASSIGNMENTS_N9 | NORMAL | NONUNIQUE | APPS_TS_SEED | FREIGHT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_ASSIGNMENT_ID | NUMBER | Yes | Primary Key for the table | |
CALENDAR_CODE | VARCHAR2 | (10) | Yes | Foreign Key to BOM_CALENDARS.CALENDAR_CODE |
CALENDAR_TYPE | VARCHAR2 | (10) | Yes | SHIPPING, RECEIVING or CARRIER |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Enables the calendar assignment if Y |
ASSOCIATION_TYPE | VARCHAR2 | (20) | Yes | CUSTOMER, CUSTOMER_SITE, VENDOR, VENDOR_SITE, CARRIER, ORGANIZATION, or HR_LOCATION |
LOCATION_ASSOCIATION_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | Foreign Key to HR_ORGANIZATION_UNITS.ORGANIZATION_ID | ||
VENDOR_ID | NUMBER | Foreign Key to PO_VENDORS.VENDOR_ID | ||
CUSTOMER_ID | NUMBER | Foreign Key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID | ||
CUSTOMER_SITE_USE_ID | NUMBER | Foreign key to HZ_CUST_SITE_USES_ALL.SITE_USE_IDHZ_CUST_SITE_USES_ALL | ||
FREIGHT_CODE | VARCHAR2 | (25) | Foreign Key to ORG_FREIGHT.FREIGHT_CODE | |
FREIGHT_ORG_ID | NUMBER | Foreign Key to ORG_FREIGHT.ORGANIZATION_ID | ||
HR_LOCATION_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | Foreign Key to PO_VENDOR_SITES | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive Flexfields | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
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 | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
LOCATION_ID | NUMBER | Foreign Key to HR_LOCATIONS | ||
CARRIER_ID | NUMBER | Foreign Key to WSH_CARRIERS | ||
CARRIER_SITE_ID | NUMBER | Foreign Key to WSH_CARRIER_SITES |
Cut, paste (and edit) the following text to query this object:
SELECT CALENDAR_ASSIGNMENT_ID
, CALENDAR_CODE
, CALENDAR_TYPE
, ENABLED_FLAG
, ASSOCIATION_TYPE
, LOCATION_ASSOCIATION_ID
, ORGANIZATION_ID
, VENDOR_ID
, CUSTOMER_ID
, CUSTOMER_SITE_USE_ID
, FREIGHT_CODE
, FREIGHT_ORG_ID
, HR_LOCATION_ID
, VENDOR_SITE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, REQUEST_ID
, PROGRAM_UPDATE_DATE
, LOCATION_ID
, CARRIER_ID
, CARRIER_SITE_ID
FROM WSH.WSH_CALENDAR_ASSIGNMENTS;
WSH.WSH_CALENDAR_ASSIGNMENTS does not reference any database object
WSH.WSH_CALENDAR_ASSIGNMENTS is referenced by following:
|
|
|