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_INV_APRVL_HIST_ALL

Object Details

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

AP_INV_APRVL_HIST_ALL contains the approval and rejection history of each invoice that passes through the Invoice Approval Workflow process. The process inserts a record for each approver assigned to review an invoice. This table corresponds to the Invoice Approval History window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_INV_APRVL_HIST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPROVAL_HISTORY_ID	NUMBER	(15)	Yes	Approval history identifier
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
ITERATION	NUMBER	(9)		Count of times invoice has passed through the Invoice Approval Workflow process
RESPONSE	VARCHAR2	(50)		Response from approver
APPROVER_ID	NUMBER	(15)		Approver identifier
APPROVER_NAME	VARCHAR2	(150)		No longer used
AMOUNT_APPROVED	NUMBER			Invoice amount at time of approver response
APPROVER_COMMENTS	VARCHAR2	(240)		Comments of approver
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID	NUMBER	(15)		Organization identifier
NOTIFICATION_ORDER	NUMBER	(9)		Order that the notifications were sent to approvers
ORIG_SYSTEM	VARCHAR2	(30)		Originating system for the approver_id
ITEM_CLASS	VARCHAR2	(50)		The AME Item Class that required this approval
ITEM_ID	VARCHAR2	(50)		Unique identifier used by the AME transaction type to identify an item in an Item Class. The AME item Id for the Item Class that required this approval.
LINE_NUMBER	NUMBER	(15)		Invoice line number
HOLD_ID	NUMBER	(15)		Hold identifier
HISTORY_TYPE	VARCHAR2	(30)		For internal use only

Query Text

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


SELECT APPROVAL_HISTORY_ID
,      INVOICE_ID
,      ITERATION
,      RESPONSE
,      APPROVER_ID
,      APPROVER_NAME
,      AMOUNT_APPROVED
,      APPROVER_COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      NOTIFICATION_ORDER
,      ORIG_SYSTEM
,      ITEM_CLASS
,      ITEM_ID
,      LINE_NUMBER
,      HOLD_ID
,      HISTORY_TYPE
FROM AP.AP_INV_APRVL_HIST_ALL;

Dependencies

[top of page]

AP.AP_INV_APRVL_HIST_ALL does not reference any database object

AP.AP_INV_APRVL_HIST_ALL is referenced by following:

APPS: AP_INV_APRVL_HIST; AP_INV_APRVL_HIST_ALL