Skip to content

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

VIEW: PA.PA_FI_AMOUNT_DETAILS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
FORECAST_ITEM_ID NUMBER
Yes
LINE_NUM NUMBER (15) Yes
ITEM_DATE DATE
Yes
ITEM_UOM VARCHAR2 (30) Yes
ITEM_QUANTITY NUMBER
Yes
REVERSED_FLAG VARCHAR2 (1) Yes
NET_ZERO_FLAG VARCHAR2 (1) Yes
LINE_NUM_REVERSED NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

COST_TXN_CURRENCY_CODE VARCHAR2 (15)
TXN_RAW_COST NUMBER

TXN_BURDENED_COST NUMBER

REVENUE_TXN_CURRENCY_CODE VARCHAR2 (15)
TXN_REVENUE NUMBER

TP_TXN_CURRENCY_CODE VARCHAR2 (15)
TXN_TRANSFER_PRICE NUMBER

PROJECT_CURRENCY_CODE VARCHAR2 (15)
PROJECT_COST_RATE_DATE DATE

PROJECT_COST_RATE_TYPE VARCHAR2 (30)
PROJECT_COST_EXCHANGE_RATE NUMBER

PROJECT_RAW_COST NUMBER

PROJECT_BURDENED_COST NUMBER

PROJECT_REVENUE_RATE_DATE DATE

PROJECT_REVENUE_RATE_TYPE VARCHAR2 (30)
PROJECT_REVENUE_EXCHANGE_RATE NUMBER

PROJECT_REVENUE NUMBER

PROJECT_TP_RATE_DATE DATE

PROJECT_TP_RATE_TYPE VARCHAR2 (30)
PROJECT_TP_EXCHANGE_RATE NUMBER

PROJECT_TRANSFER_PRICE NUMBER

PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
PROJFUNC_COST_RATE_DATE DATE

PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
PROJFUNC_COST_EXCHANGE_RATE NUMBER

PROJFUNC_RAW_COST NUMBER

PROJFUNC_BURDENED_COST NUMBER

PROJFUNC_REVENUE NUMBER

PROJFUNC_TRANSFER_PRICE NUMBER

EXPFUNC_CURRENCY_CODE VARCHAR2 (15)
EXPFUNC_COST_RATE_DATE DATE

EXPFUNC_COST_RATE_TYPE VARCHAR2 (30)
EXPFUNC_COST_EXCHANGE_RATE NUMBER

EXPFUNC_RAW_COST NUMBER

EXPFUNC_BURDENED_COST NUMBER

EXPFUNC_TP_RATE_DATE DATE

EXPFUNC_TP_RATE_TYPE VARCHAR2 (30)
EXPFUNC_TP_EXCHANGE_RATE NUMBER

EXPFUNC_TRANSFER_PRICE NUMBER

PROJFUNC_REVENUE_RATE_DATE DATE

PROJFUNC_REVENUE_RATE_TYPE VARCHAR2 (30)
PROJFUNC_REVENUE_EXCHANGE_RATE NUMBER

PROJFUNC_TP_RATE_DATE DATE

PROJFUNC_TP_RATE_TYPE VARCHAR2 (30)
PROJFUNC_TP_EXCHANGE_RATE NUMBER

Query Text

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


SELECT FORECAST_ITEM_ID
,      LINE_NUM
,      ITEM_DATE
,      ITEM_UOM
,      ITEM_QUANTITY
,      REVERSED_FLAG
,      NET_ZERO_FLAG
,      LINE_NUM_REVERSED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COST_TXN_CURRENCY_CODE
,      TXN_RAW_COST
,      TXN_BURDENED_COST
,      REVENUE_TXN_CURRENCY_CODE
,      TXN_REVENUE
,      TP_TXN_CURRENCY_CODE
,      TXN_TRANSFER_PRICE
,      PROJECT_CURRENCY_CODE
,      PROJECT_COST_RATE_DATE
,      PROJECT_COST_RATE_TYPE
,      PROJECT_COST_EXCHANGE_RATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      PROJECT_REVENUE_RATE_DATE
,      PROJECT_REVENUE_RATE_TYPE
,      PROJECT_REVENUE_EXCHANGE_RATE
,      PROJECT_REVENUE
,      PROJECT_TP_RATE_DATE
,      PROJECT_TP_RATE_TYPE
,      PROJECT_TP_EXCHANGE_RATE
,      PROJECT_TRANSFER_PRICE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJFUNC_RAW_COST
,      PROJFUNC_BURDENED_COST
,      PROJFUNC_REVENUE
,      PROJFUNC_TRANSFER_PRICE
,      EXPFUNC_CURRENCY_CODE
,      EXPFUNC_COST_RATE_DATE
,      EXPFUNC_COST_RATE_TYPE
,      EXPFUNC_COST_EXCHANGE_RATE
,      EXPFUNC_RAW_COST
,      EXPFUNC_BURDENED_COST
,      EXPFUNC_TP_RATE_DATE
,      EXPFUNC_TP_RATE_TYPE
,      EXPFUNC_TP_EXCHANGE_RATE
,      EXPFUNC_TRANSFER_PRICE
,      PROJFUNC_REVENUE_RATE_DATE
,      PROJFUNC_REVENUE_RATE_TYPE
,      PROJFUNC_REVENUE_EXCHANGE_RATE
,      PROJFUNC_TP_RATE_DATE
,      PROJFUNC_TP_RATE_TYPE
,      PROJFUNC_TP_EXCHANGE_RATE
FROM PA.PA_FI_AMOUNT_DETAILS#;

Dependencies

[top of page]

PA.PA_FI_AMOUNT_DETAILS# references the following:

SchemaPA
TablePA_FI_AMOUNT_DETAILS
PA.PA_FI_AMOUNT_DETAILS# is referenced by following:

SchemaAPPS
SynonymPA_FI_AMOUNT_DETAILS