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: 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
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:

PA: PA_FI_AMOUNT_DETAILS

PA.PA_FI_AMOUNT_DETAILS# is referenced by following:

APPS: PA_FI_AMOUNT_DETAILS