[Home] [Help] [Dependency Information]
Object Name: | CSP_NOTIFICATIONS |
---|---|
Object Type: | TABLE |
Owner: | CSP |
FND Design Data: | CSP.CSP_NOTIFICATIONS |
Subobject Name: | |
Status: | VALID |
CSP_NOTIFICATIONS stores the result of the concurrent program "Create Notifications". Reason identifies one of 3 different types of notifications generated. Above (A) total quantity in loop, Below (B) total quantity in loop and Not enough good parts in loop (N). STATUS shows if it is an open, pending or closed notification.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSP_NOTIFICATIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | NOTIFICATION_ID |
CSP_NOTIFICATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PLANNER_CODE
ORGANIZATION_ID |
CSP_NOTIFICATIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARTS_LOOP_ID
INVENTORY_ITEM_ID |
CSP_NOTIFICATIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOTIFICATION_ID | NUMBER | (35) | Yes | Notification unique identifier |
CREATED_BY | NUMBER | (35) | Yes | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Yes | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
REQUEST_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
PLANNER_CODE | VARCHAR2 | (10) | Planner identifier | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | (35) | Yes | Inventory item identifier |
NOTIFICATION_DATE | DATE | Yes | Date of notification | |
REASON | VARCHAR2 | (240) | Yes | Notification reason A=Above B=Below N=Not enough good parts |
STATUS | VARCHAR2 | (30) | Yes | Notification status 1=Open 2=Pending 3=Closed |
QUANTITY | NUMBER | (35) | Quantity | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
NEED_DATE | DATE | Need by date | ||
SUPPRESS_END_DATE | DATE | Notification suppressed till this date | ||
NOTIFICATION_TYPE | VARCHAR2 | (30) | Notification type |
Cut, paste (and edit) the following text to query this object:
SELECT NOTIFICATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PLANNER_CODE
, PARTS_LOOP_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, NOTIFICATION_DATE
, REASON
, STATUS
, QUANTITY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, NEED_DATE
, SUPPRESS_END_DATE
, NOTIFICATION_TYPE
FROM CSP.CSP_NOTIFICATIONS;
CSP.CSP_NOTIFICATIONS does not reference any database object
CSP.CSP_NOTIFICATIONS is referenced by following:
|
|
|