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