[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
|
|
|