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: TableSQLAP.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_INV_APRVL_HIST_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPROVAL_HISTORY_ID
AP_INV_APRVL_HIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_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:

SchemaAP
ViewAP_INV_APRVL_HIST_ALL#