eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AP.AP_APINV_APPROVERS

Object Details

Object Name:	AP_APINV_APPROVERS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_APINV_APPROVERS
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INVOICE_ID	NUMBER	(15)	Invoice Id of the Invoice going through approval process.
INVOICE_ITERATION	NUMBER	(15)	Count that Invoice has been through the approval process.
INVOICE_KEY	VARCHAR2	(50)	The item key used by workflow for the main workflow item type.
LINE_NUMBER	NUMBER	(15)	Line number from the Invoice Line going through approval process.
NOTIFICATION_ITERATION	NUMBER	(15)	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 DirectoryServices, an originating system is an application that defines a kind ofapprover found in wf_roles.
ORIG_SYSTEM_ID	NUMBER	(15)	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	(15)	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	(15)	This fields semantics depend on whether the approver belongs to an approvalgroup or a chain of authority.
OCCURRENCE	NUMBER	(15)	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	(15)	AME uses this field internally to calculate the approvers approver_order_number value.
ITEM_ORDER_NUMBER	NUMBER	(15)	AME uses this field internally to calculate the approvers approver_order_number value.
SUB_LIST_ORDER_NUMBER	NUMBER	(15)	AME uses this field internally to calculate the approvers approver_order_number value.
ACTION_TYPE_ORDER_NUMBER	NUMBER	(15)	AME uses this field internally to calculate the approvers approver_order_number value.
GROUP_OR_CHAIN_ORDER_NUMBER	NUMBER	(15)	AME uses this field internally to calculate the approvers approver_order_number value.
MEMBER_ORDER_NUMBER	NUMBER	(15)	AME uses this field internally to calculate the approvers approver_order_number value.
APPROVER_ORDER_NUMBER	NUMBER	(15)	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	NUMBER	(15)	Standard Who Column
LAST_UPDATE_DATE	DATE		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard Who Column
CREATED_BY	NUMBER	(15)	Standard Who Column
CREATION_DATE	DATE		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)	Standard Who Column
PROGRAM_ID	NUMBER	(15)	Standard Who Column
PROGRAM_UPDATE_DATE	DATE		Standard Who Column
REQUEST_ID	NUMBER	(15)	Standard Who Column
EXTERNAL_ROLE_NAME	VARCHAR2	(320)	External (supplier) role name
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVOICE_ID
,      INVOICE_ITERATION
,      INVOICE_KEY
,      LINE_NUMBER
,      NOTIFICATION_ITERATION
,      NOTIFICATION_KEY
,      NOTIFICATION_STATUS
,      ROLE_NAME
,      ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      DISPLAY_NAME
,      APPROVER_CATEGORY
,      API_INSERTION
,      AUTHORITY
,      APPROVAL_STATUS
,      ACTION_TYPE_ID
,      GROUP_OR_CHAIN_ID
,      OCCURRENCE
,      SOURCE
,      ITEM_CLASS
,      ITEM_ID
,      ITEM_CLASS_ORDER_NUMBER
,      ITEM_ORDER_NUMBER
,      SUB_LIST_ORDER_NUMBER
,      ACTION_TYPE_ORDER_NUMBER
,      GROUP_OR_CHAIN_ORDER_NUMBER
,      MEMBER_ORDER_NUMBER
,      APPROVER_ORDER_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      EXTERNAL_ROLE_NAME
,      ACCESS_CONTROL_FLAG
,      CHILD_PROCESS_ITEM_TYPE
,      CHILD_PROCESS_ITEM_KEY
,      ITEM_TYPE
,      ITEM_KEY
FROM AP.AP_APINV_APPROVERS;

Dependencies

[top of page]

AP.AP_APINV_APPROVERS does not reference any database object

AP.AP_APINV_APPROVERS is referenced by following:

AP: AP_APINV_APPROVERS#