AP_APINV_APPROVERS
This table connects approvers to their invoice components, either the invoice header or the invoice line. The records are created during the Invoice Approval Workflow process as the workflow proceeds through the list of approvers generated by the Approval Management Engine. For the most part, the table contains only approvers that either have been notified or need to be notified. While the workflow processes notifications, there will be a brief moment that the Notification_Status will be PEND until the workflow loops to the record and sends the notification. Once the workflow process for an Invoice finishes, the records related to the invoice will be deleted from the table. Additionally, the user action of Stopping an invoice approval will cause records with a Notification_Status of SENT to be deleted. As notifications are sent and responded to, the relevant approver/component records will have their Notification_Status updated.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
AP_APINV_APPROVERS_PK |
LINE_NUMBER, INVOICE_KEY, INVOICE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INVOICE_ID | NUMBER | 18 | Yes | Invoice Id of the Invoice going through approval process. | |
INVOICE_ITERATION | NUMBER | 18 | Count that Invoice has been through the approval process. | ||
INVOICE_KEY | VARCHAR2 | 50 | Yes | The item key used by workflow for the main workflow item type. | |
LINE_NUMBER | NUMBER | 18 | Yes | Line number from the Invoice Line going through approval process. | |
NOTIFICATION_ITERATION | NUMBER | 18 | Count indicating in what order a notification was sent relative to the other notifications. | ||
NOTIFICATION_KEY | VARCHAR2 | 50 | The item key used by workflow for the notification sending sub-process. | ||
NOTIFICATION_STATUS | VARCHAR2 | 50 | Status of record indicating where it is in the notification process. Possible values: PEND, SENT, COMP. | ||
ROLE_NAME | VARCHAR2 | 320 | This is the approvers wf_roles.name value, which essentially identifies the approver uniquely in wf_roles. | ||
ORIG_SYSTEM | VARCHAR2 | 30 | This is the approvers wf_roles.orig_system value. In Workflow Directory Services, an originating system is an application that defines a kind of approver found in wf_roles. For example, some HRMS persons (from the per_all_people_f) table appear in wf_roles with the orig_system value PER. | ||
ORIG_SYSTEM_ID | NUMBER | 18 | This is the approvers wf_roles.orig_system_id value. The combination of the approvers orig_system and orig_system_id values also essentially identifies the approver uniquely in wf_roles. | ||
DISPLAY_NAME | VARCHAR2 | 360 | This is the approvers wf_roles.display_name value. Field value is determined by AME. | ||
APPROVER_CATEGORY | VARCHAR2 | 1 | Indicates whether approver should receive a FYI or a response required notification. Field value is determined by AME. | ||
API_INSERTION | VARCHAR2 | 1 | Indicates how the approver was included in the approval list. Field value is determined by AME. | ||
AUTHORITY | VARCHAR2 | 1 | Indicates what level approver is on record. Field value is determined by AME. | ||
APPROVAL_STATUS | VARCHAR2 | 50 | Indicates status of this approvers approval. Field value is determined by AME. | ||
ACTION_TYPE_ID | NUMBER | 18 | For AME-generated approvers, this field contains the ID that AME assigns to the action type that generated the approver. Field value is determined by AME. | ||
GROUP_OR_CHAIN_ID | NUMBER | 18 | This fields semantics depend on whether the approver belongs to an approval group or a chain of authority. In the former case, the field contains the ID that AME assigns to the approval group. In the latter case, the action type generating the chain of authority assigns its chains ascending positive integer group_or_chain_id values, starting at one. | ||
OCCURRENCE | NUMBER | 18 | The occurrence field indicates how many times the approvers wf_roles.name value has occurred in the approvers approval group or chain of authority, including the present case. | ||
SOURCE | VARCHAR2 | 500 | Field value is determined by AME and should only be interpreted by AME | ||
ITEM_CLASS | VARCHAR2 | 50 | Name of grouping seeded in AME. For example, header, line or distribution. | ||
ITEM_ID | VARCHAR2 | 50 | Unique identifier used by the AME transaction type to identify an item in an Item Class. | ||
ITEM_CLASS_ORDER_NUMBER | NUMBER | 18 | AME uses this field internally to calculate the approvers approver_order_number value. | ||
ITEM_ORDER_NUMBER | NUMBER | 18 | AME uses this field internally to calculate the approvers approver_order_number value. | ||
SUB_LIST_ORDER_NUMBER | NUMBER | 18 | AME uses this field internally to calculate the approvers approver_order_number value. | ||
ACTION_TYPE_ORDER_NUMBER | NUMBER | 18 | AME uses this field internally to calculate the approvers approver_order_number value. | ||
GROUP_OR_CHAIN_ORDER_NUMBER | NUMBER | 18 | AME uses this field internally to calculate the approvers approver_order_number value. | ||
MEMBER_ORDER_NUMBER | NUMBER | 18 | AME uses this field internally to calculate the approvers approver_order_number value. | ||
APPROVER_ORDER_NUMBER | NUMBER | 18 | AME uses the six other order-number fields to calculate the approver_order_number value by treating them as a six-tuple and sorting them in lexicographic order. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
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. | ||
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. | ||
PROGRAM_APPLICATION_ID | NUMBER | 18 | Who column: indicates the application identifier of the row. | ||
PROGRAM_ID | NUMBER | 18 | Who column: indicates the identifier of the row. | ||
PROGRAM_UPDATE_DATE | DATE | Who column: indicates the date and time of the creation of the row. | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
EXTERNAL_ROLE_NAME | VARCHAR2 | 320 | Name of the external supplier role. | ||
ACCESS_CONTROL_FLAG | VARCHAR2 | 1 | This column indicates whether dispute process owner is internal or external. | ||
CHILD_PROCESS_ITEM_TYPE | VARCHAR2 | 50 | Child workflow process item type. For internal use only | ||
CHILD_PROCESS_ITEM_KEY | VARCHAR2 | 50 | Child workflow process item key. For internal use only | ||
ITEM_TYPE | VARCHAR2 | 50 | Workflow process item type. For internal use only | ||
ITEM_KEY | VARCHAR2 | 50 | Workflow process item key. For internal use only | ||
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 |
---|---|---|
AP_APINV_APPROVERS | ap_invoices_all | INVOICE_ID |
AP_APINV_APPROVERS | ap_invoice_lines_all | INVOICE_ID, LINE_NUMBER |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
AP_APINV_APPROVERS_U1 | Unique | Default | LINE_NUMBER, INVOICE_KEY, INVOICE_ID |