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]

VIEW: APPS.CST_PAC_AE_LINES_V

Object Details

Object Name:	CST_PAC_AE_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_PAC_AE_LINES_V
Subobject Name:
Status:	VALID

PAC Accounting Line view

[View Source]

Columns

Name	Datatype	Length	Comments
AE_LINE_ID	NUMBER	(15)	AE Line ID
AE_HEADER_ID	NUMBER	(15)	AE Header ID
AE_LINE_NUMBER	NUMBER		AE Line Number
AE_LINE_TYPE_CODE	VARCHAR2	(30)	Accounting Line Type
CODE_COMBINATION_ID	NUMBER	(15)	Code Combination ID
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)	Currency Conversion Type
CURRENCY_CONVERSION_DATE	DATE		Currency Conversion Date
CURRENCY_CONVERSION_RATE	NUMBER		Currency Conversion Rate
ENTERED_DR	NUMBER		Entered Debit
ENTERED_CR	NUMBER		Entered Credit
ACCOUNTED_DR	NUMBER		Accounted Debit
ACCOUNTED_CR	NUMBER		Accounted Credit
SOURCE_TABLE	VARCHAR2	(30)	Source Table
SOURCE_ID	NUMBER	(15)	Source ID
RATE_OR_AMOUNT	NUMBER		Rate Or Amount
BASIS_TYPE	NUMBER		Basis Type
RESOURCE_ID	NUMBER		Resource ID
COST_ELEMENT_ID	NUMBER		Cost Element ID
ACTIVITY_ID	NUMBER		Activity ID
REPETITIVE_SCHEDULE_ID	NUMBER		Repetitive Schedule ID
OVERHEAD_BASIS_FACTOR	NUMBER		Overhead Basis Factor
BASIS_RESOURCE_ID	NUMBER	(15)	Basis Resource ID
GL_SL_LINK_ID	NUMBER	(15)	GL Sl Link ID
DESCRIPTION	VARCHAR2	(240)	Description
ACCOUNTING_ERROR_CODE	VARCHAR2	(30)	Accounting Error Code
STAT_AMOUNT	NUMBER		Statistical Amount
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
SUBLEDGER_DOC_SEQUENCE_ID	NUMBER	(15)	Subledger Document Sequence ID
SUBLEDGER_DOC_SEQUENCE_VALUE	NUMBER		Subledger Document Sequence Value
GL_TRANSFER_ERROR_CODE	VARCHAR2	(240)	GL transfer error code
REFERENCE1	VARCHAR2	(240)	Reference 1
REFERENCE2	VARCHAR2	(240)	Reference 2
REFERENCE3	VARCHAR2	(240)	Reference 3
REFERENCE4	VARCHAR2	(240)	Reference 4
REFERENCE5	VARCHAR2	(240)	Reference 5
REFERENCE6	VARCHAR2	(240)	Reference 6
REFERENCE7	VARCHAR2	(240)	Reference 7
REFERENCE8	VARCHAR2	(240)	Reference 8
REFERENCE9	VARCHAR2	(240)	Reference 9
REFERENCE10	VARCHAR2	(240)	Reference 10
CREATION_DATE	DATE		Creation Date
CREATED_BY	NUMBER	(15)	Created By
LAST_UPDATE_DATE	DATE		Last Update date
LAST_UPDATED_BY	NUMBER	(15)	Last Updated By
LAST_UPDATE_LOGIN	NUMBER	(15)	Last Update Login
PROGRAM_UPDATE_DATE	DATE		Program Update Date
PROGRAM_APPLICATION_ID	NUMBER	(15)	Program Application ID
PROGRAM_ID	NUMBER	(15)	Program ID
REQUEST_ID	NUMBER	(15)	Request ID
PO_DISTRIBUTION_ID	NUMBER		PO Distribution ID
BALANCE_TYPE	CHAR	(1)	Balance Type

Query Text

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


SELECT AE_LINE_ID
,      AE_HEADER_ID
,      AE_LINE_NUMBER
,      AE_LINE_TYPE_CODE
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      SOURCE_TABLE
,      SOURCE_ID
,      RATE_OR_AMOUNT
,      BASIS_TYPE
,      RESOURCE_ID
,      COST_ELEMENT_ID
,      ACTIVITY_ID
,      REPETITIVE_SCHEDULE_ID
,      OVERHEAD_BASIS_FACTOR
,      BASIS_RESOURCE_ID
,      GL_SL_LINK_ID
,      DESCRIPTION
,      ACCOUNTING_ERROR_CODE
,      STAT_AMOUNT
,      USSGL_TRANSACTION_CODE
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      GL_TRANSFER_ERROR_CODE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      PO_DISTRIBUTION_ID
,      BALANCE_TYPE
FROM APPS.CST_PAC_AE_LINES_V;

Dependencies

[top of page]

APPS.CST_PAC_AE_LINES_V references the following:

APPS: CST_AE_LINES; CST_ENCUMBRANCE_LINES

APPS.CST_PAC_AE_LINES_V is referenced by following:

APPS: CST_PAC_AEL_GL_RCV_V; CST_PAC_AEL_SL_INV_V; CST_PAC_AEL_SL_RCV_V; CST_PAC_AEL_SL_WIP_V