DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_FP_TXN_CURRENCIES#

Object Details
Object Name: PA_FP_TXN_CURRENCIES#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FP_TXN_CURRENCY_ID NUMBER (15) Yes
PROJ_FP_OPTIONS_ID NUMBER (15) Yes
PROJECT_ID NUMBER (15) Yes
FIN_PLAN_TYPE_ID NUMBER (15)
FIN_PLAN_VERSION_ID NUMBER (15)
TXN_CURRENCY_CODE VARCHAR2 (15) Yes
DEFAULT_REV_CURR_FLAG VARCHAR2 (1)
DEFAULT_COST_CURR_FLAG VARCHAR2 (1)
DEFAULT_ALL_CURR_FLAG VARCHAR2 (1)
PROJECT_CURRENCY_FLAG VARCHAR2 (1)
PROJFUNC_CURRENCY_FLAG VARCHAR2 (1)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
PROJECT_COST_EXCHANGE_RATE NUMBER

PROJECT_REV_EXCHANGE_RATE NUMBER

PROJFUNC_COST_EXCHANGE_RATE NUMBER

PROJFUNC_REV_EXCHANGE_RATE NUMBER

Query Text

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


SELECT FP_TXN_CURRENCY_ID
,      PROJ_FP_OPTIONS_ID
,      PROJECT_ID
,      FIN_PLAN_TYPE_ID
,      FIN_PLAN_VERSION_ID
,      TXN_CURRENCY_CODE
,      DEFAULT_REV_CURR_FLAG
,      DEFAULT_COST_CURR_FLAG
,      DEFAULT_ALL_CURR_FLAG
,      PROJECT_CURRENCY_FLAG
,      PROJFUNC_CURRENCY_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_COST_EXCHANGE_RATE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJFUNC_REV_EXCHANGE_RATE
FROM PA.PA_FP_TXN_CURRENCIES#;

Dependencies

[top of page]

PA.PA_FP_TXN_CURRENCIES# references the following:

SchemaPA
TablePA_FP_TXN_CURRENCIES
PA.PA_FP_TXN_CURRENCIES# is referenced by following:

SchemaAPPS
SynonymPA_FP_TXN_CURRENCIES