PO_NOTIFICATION_CONTROLS
PO_NOTIFICATION_CONTROLS contains information about the notification control rules for blanket, planned, and contract purchase orders. There is one record in this table for each notification control rule that an employee creates for a purchase order header. Oracle Alert uses the notification control rules to determine the type of notification to send, the effective date range for the notification, and the document amount that triggers the notification. . NOTIFICATION_ID is the unique system-generated primary key and is invisible to the user. . You enter notification control information in the Notification Controls window, accessible through the Purchase Orders window. .
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PO_NOTIFICATION_CONTROLS_PK |
NOTIFICATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| NOTIFICATION_ID | NUMBER | 18 | Yes | Notification control unique identifier | ||
| PO_HEADER_ID | NUMBER | 18 | Yes | Blanket, planned and contract purchase order header unique identifier | ||
| START_DATE_ACTIVE | DATE | Effective date of the notification | ||||
| END_DATE_ACTIVE | DATE | Expiration date of the notification | ||||
| NOTIFICATION_AMOUNT | NUMBER | Notification amount of document total | ||||
| NOTIFICATION_CONDITION_CODE | VARCHAR2 | 25 | Notification type | |||
| NOTIFICATION_QTY_PERCENTAGE | NUMBER | Notification percentage of document total | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | |||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Purchase Agreement Notification Controls (PO_NOTIFICATION_CONTROLS) | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PO_NOTIFICATION_CONTROLS | po_headers_all | PO_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PO_NOTIFICATION_CONTROLS_N1 | Non Unique | Default | PO_HEADER_ID |
| PO_NOTIFICATION_CONTROLS_N2 | Non Unique | Default | NOTIFICATION_CONDITION_CODE |
| PO_NOTIFICATION_CONTROLS_U1 | Unique | Default | NOTIFICATION_ID |