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.PA_XLA_CDL_LINES_V

Object Details

Object Name:	PA_XLA_CDL_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_XLA_CDL_LINES_V
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length
EVENT_ID	NUMBER	(15)
EXPENDITURE_ITEM_ID	NUMBER	(15)
LINE_NUMBER	NUMBER	(15)
LEDGER_ID	NUMBER	(15)
REVERSING_LINE_FLAG	VARCHAR2	(1)
LINE_NUM_REVERSED	NUMBER
LINE_TYPE	VARCHAR2	(1)
ENTERED_CURRENCY_CODE	VARCHAR2	(15)
ENTERED_RAW_COST	NUMBER
ENTERED_BURDENED_COST	NUMBER
ACCT_RAW_COST	NUMBER
ACCT_BURDENED_COST	NUMBER
EXCHANGE_RATE	NUMBER
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_RATE_DATE	DATE
COST_CCID	NUMBER
COST_CLEARING_CCID	NUMBER
ALLOW_OVERRIDE_CCID_FLAG	VARCHAR2	(1)
ADJ_COST_CCID	NUMBER
ADJ_COST_CLEARING_CCID	NUMBER
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
WORK_TYPE_ID	NUMBER
BILLABLE_FLAG	VARCHAR2	(1)
USE_ACT_UPG_ATTRIB_FLAG	CHAR	(1)
ACTUAL_UPG_DR_ACCT_CLASS	CHAR	(4)
ACTUAL_UPG_CR_ACCT_CLASS	CHAR	(13)
BUDGET_CCID	NUMBER	(15)
USE_ENC_UPG_ATTRIB_FLAG	VARCHAR2	(4000)
ENC_UPG_DR_ACCT_CLASS	VARCHAR2	(18)
ENC_UPG_CR_ACCT_CLASS	VARCHAR2	(0)
INVOICE_APPLICATION_ID	NUMBER
INVOICE_DISTRIBUTION_TYPE	VARCHAR2	(12)
INVOICE_ENTITY_CODE	VARCHAR2	(11)
INVOICE_FIRST_DIST_ID	NUMBER
INVOICE_SECOND_DIST_ID	VARCHAR2	(30)
INVOICE_FIRST_SYS_TRANS_ID	NUMBER
PO_APPLICATION_ID	NUMBER
PO_DISTRIBUTION_TYPE	VARCHAR2	(12)
PO_ENTITY_CODE	VARCHAR2	(14)
PO_FIRST_DIST_ID	NUMBER
PO_SECOND_DIST_ID	VARCHAR2	(30)
PO_FIRST_SYS_TRANS_ID	NUMBER
PA_APPLICATION_ID	NUMBER
PA_DISTRIBUTION_TYPE	CHAR	(13)
PA_ENTITY_CODE	CHAR	(7)
PA_FIRST_DIST_ID	NUMBER	(15)
PA_FIRST_SYS_TRANS_ID	NUMBER	(15)
PA_SECOND_DIST_ID	VARCHAR2	(0)
DOCUMENT_TYPE	VARCHAR2	(10)
ENC_ACCT_ENABLED	VARCHAR2	(4000)
ENCUMBRANCE_AMOUNT	NUMBER
ENCUMBRANCE_TYPE_ID	NUMBER
PROJ_ENCUMBRANCE_TYPE_ID	NUMBER
PO_RELEASE_ID	NUMBER
CWK_RATE_BASED_TC_FLAG	VARCHAR2	(1)
LIQUIDATE_ENCUM_FLAG	VARCHAR2	(1)
ENC_JE_LINES_REVERSED_FLAG	VARCHAR2	(4000)

Query Text

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


SELECT EVENT_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUMBER
,      LEDGER_ID
,      REVERSING_LINE_FLAG
,      LINE_NUM_REVERSED
,      LINE_TYPE
,      ENTERED_CURRENCY_CODE
,      ENTERED_RAW_COST
,      ENTERED_BURDENED_COST
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      COST_CCID
,      COST_CLEARING_CCID
,      ALLOW_OVERRIDE_CCID_FLAG
,      ADJ_COST_CCID
,      ADJ_COST_CLEARING_CCID
,      PROJECT_ID
,      TASK_ID
,      WORK_TYPE_ID
,      BILLABLE_FLAG
,      USE_ACT_UPG_ATTRIB_FLAG
,      ACTUAL_UPG_DR_ACCT_CLASS
,      ACTUAL_UPG_CR_ACCT_CLASS
,      BUDGET_CCID
,      USE_ENC_UPG_ATTRIB_FLAG
,      ENC_UPG_DR_ACCT_CLASS
,      ENC_UPG_CR_ACCT_CLASS
,      INVOICE_APPLICATION_ID
,      INVOICE_DISTRIBUTION_TYPE
,      INVOICE_ENTITY_CODE
,      INVOICE_FIRST_DIST_ID
,      INVOICE_SECOND_DIST_ID
,      INVOICE_FIRST_SYS_TRANS_ID
,      PO_APPLICATION_ID
,      PO_DISTRIBUTION_TYPE
,      PO_ENTITY_CODE
,      PO_FIRST_DIST_ID
,      PO_SECOND_DIST_ID
,      PO_FIRST_SYS_TRANS_ID
,      PA_APPLICATION_ID
,      PA_DISTRIBUTION_TYPE
,      PA_ENTITY_CODE
,      PA_FIRST_DIST_ID
,      PA_FIRST_SYS_TRANS_ID
,      PA_SECOND_DIST_ID
,      DOCUMENT_TYPE
,      ENC_ACCT_ENABLED
,      ENCUMBRANCE_AMOUNT
,      ENCUMBRANCE_TYPE_ID
,      PROJ_ENCUMBRANCE_TYPE_ID
,      PO_RELEASE_ID
,      CWK_RATE_BASED_TC_FLAG
,      LIQUIDATE_ENCUM_FLAG
,      ENC_JE_LINES_REVERSED_FLAG
FROM APPS.PA_XLA_CDL_LINES_V;

Dependencies

[top of page]

APPS.PA_XLA_CDL_LINES_V references the following:

APPS: GL_ENCUMBRANCE_TYPES; PA_BC_COMMITMENTS_ALL; PA_BUDGET_LINES; PA_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_FUNDS_CONTROL_UTILS - show dependent code; PA_IMPLEMENTATIONS_ALL; PA_XLA_INTERFACE_PKG - show dependent code

APPS.PA_XLA_CDL_LINES_V is referenced by following:

APPS: XLA_00275_AAD_S_000004_PKG - show dependent code; XLA_00275_AAD_S_000015_PKG - show dependent code; XLA_00275_AAD_S_000016_PKG - show dependent code