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_LINE_APRVL_HIST_ALL

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_APRVL_HISTORY_ID	NUMBER	(15)	Yes	Invoice line approval history identifier.
LINE_NUMBER	NUMBER		Yes	Invoice Line Number
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
ITEM_CLASS	VARCHAR2	(50)		Item class for the invoice line defined by Approval Manager
ITEM_ID	VARCHAR2	(50)		Item id for the invoice line returned from Approval Manager
NOTIFICATION_KEY	VARCHAR2	(50)
ITERATION	NUMBER	(9)		Count of times invoice line has passed through the Invoice Approval Workflow process.
NOTIFICATION_ORDER	NUMBER	(9)		Order of notification being sent.
RESPONSE	VARCHAR2	(50)		Response from approver
APPROVER_ID	NUMBER	(15)	Yes	Approver identifier
LINE_AMOUNT_APPROVED	NUMBER			Invoice line amount approved.
TAX_AMOUNT_APPROVED	NUMBER			Tax amount approved.
FREIGHT_AMOUNT_APPROVED	NUMBER			Freight amount approved.
MISC_AMOUNT_APPROVED	NUMBER			Miscellaneous amount approved
APPROVER_COMMENTS	VARCHAR2	(240)		Comments of approver
ORG_ID	NUMBER	(15)		Organization identifier
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - user who last updated this row
NEW_LINE_NUMBER	NUMBER			New line number
HISTORY_TYPE	VARCHAR2	(30)		Either NEGOTIATION, COMMENT, or APPROVAL
ACCESS_TYPE_CODE	VARCHAR2	(30)		Either EXTERNAL or INTERNAL, and is the lookup value of the ACCESS_TYPE lookup type
ALTERED_FIELD_CODE	VARCHAR2	(30)		Name of the column updated and is the lookup value of the LINE_FIELD lookup type
ALTERED_FIELD_DATA_TYPE	VARCHAR2	(30)		Data type of the updated field
ORIGINAL_VALUE	VARCHAR2	(240)		Original value of the updated field
NEW_VALUE	VARCHAR2	(240)		New value of the updated field

Query Text

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


SELECT LINE_APRVL_HISTORY_ID
,      LINE_NUMBER
,      INVOICE_ID
,      ITEM_CLASS
,      ITEM_ID
,      NOTIFICATION_KEY
,      ITERATION
,      NOTIFICATION_ORDER
,      RESPONSE
,      APPROVER_ID
,      LINE_AMOUNT_APPROVED
,      TAX_AMOUNT_APPROVED
,      FREIGHT_AMOUNT_APPROVED
,      MISC_AMOUNT_APPROVED
,      APPROVER_COMMENTS
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NEW_LINE_NUMBER
,      HISTORY_TYPE
,      ACCESS_TYPE_CODE
,      ALTERED_FIELD_CODE
,      ALTERED_FIELD_DATA_TYPE
,      ORIGINAL_VALUE
,      NEW_VALUE
FROM AP.AP_LINE_APRVL_HIST_ALL;

Dependencies

[top of page]

AP.AP_LINE_APRVL_HIST_ALL does not reference any database object

AP.AP_LINE_APRVL_HIST_ALL is referenced by following:

AP: AP_LINE_APRVL_HIST_ALL#