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_CCDL_LINES_V

Object Details

Object Name:	PA_XLA_CCDL_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_XLA_CCDL_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	Mandatory
EVENT_ID	NUMBER	(15)
EXPENDITURE_ITEM_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
LEDGER_ID	NUMBER	(15)	Yes
LINE_TYPE	VARCHAR2	(2)	Yes
CC_DIST_LINE_ID	NUMBER		Yes
DIST_LINE_ID_REVERSED	VARCHAR2	(40)
REVERSING_LINE_FLAG	VARCHAR2	(1)
CC_CROSS_CHARGE_CODE	VARCHAR2	(1)	Yes
PCCDL_REFERENCE_1	NUMBER
PCCDL_REFERENCE_2	VARCHAR2	(240)
PCCDL_REFERENCE_3	NUMBER
ENTERED_CURRENCY_CODE	VARCHAR2	(15)
LINE_NUM_REVERSED	NUMBER
RECEIVER_CCID	NUMBER
PROVIDER_CCID	NUMBER
DESTINATION_CCID	NUMBER
SOURCE_CCID	NUMBER
ALLOW_OVERRIDE_CCID_FLAG	VARCHAR2	(1)
ADJ_RECEIVER_CCID	NUMBER
ADJ_PROVIDER_CCID	NUMBER
ADJ_DESTINATION_CCID	NUMBER
ADJ_SOURCE_CCID	NUMBER
ENTERED_AMOUNT	NUMBER
ACCT_AMOUNT	NUMBER		Yes
EXCHANGE_RATE	NUMBER
EXCHANGE_RATE_DATE	DATE
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
USE_ACT_UPG_ATTRIB_FLAG	VARCHAR2	(1)
ACTUAL_UPG_DR_ACCT_CLASS	VARCHAR2	(19)
ACTUAL_UPG_CR_ACCT_CLASS	VARCHAR2	(14)

Query Text

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


SELECT EVENT_ID
,      EXPENDITURE_ITEM_ID
,      LINE_NUMBER
,      LEDGER_ID
,      LINE_TYPE
,      CC_DIST_LINE_ID
,      DIST_LINE_ID_REVERSED
,      REVERSING_LINE_FLAG
,      CC_CROSS_CHARGE_CODE
,      PCCDL_REFERENCE_1
,      PCCDL_REFERENCE_2
,      PCCDL_REFERENCE_3
,      ENTERED_CURRENCY_CODE
,      LINE_NUM_REVERSED
,      RECEIVER_CCID
,      PROVIDER_CCID
,      DESTINATION_CCID
,      SOURCE_CCID
,      ALLOW_OVERRIDE_CCID_FLAG
,      ADJ_RECEIVER_CCID
,      ADJ_PROVIDER_CCID
,      ADJ_DESTINATION_CCID
,      ADJ_SOURCE_CCID
,      ENTERED_AMOUNT
,      ACCT_AMOUNT
,      EXCHANGE_RATE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE_TYPE
,      USE_ACT_UPG_ATTRIB_FLAG
,      ACTUAL_UPG_DR_ACCT_CLASS
,      ACTUAL_UPG_CR_ACCT_CLASS
FROM APPS.PA_XLA_CCDL_LINES_V;

Dependencies

[top of page]

APPS.PA_XLA_CCDL_LINES_V references the following:

APPS: PA_CC_DIST_LINES_ALL; PA_COST_DISTRIBUTION_LINES_ALL; PA_EXPENDITURE_ITEMS_ALL; PA_IMPLEMENTATIONS_ALL; PA_XLA_INTERFACE_PKG - show dependent code

APPS.PA_XLA_CCDL_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