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]

TABLE: PA.PA_FI_AMOUNT_DETAILS

Object Details

Object Name:	PA_FI_AMOUNT_DETAILS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_FI_AMOUNT_DETAILS
Subobject Name:
Status:	VALID

This table stores the amount details information for a forecast item. The table stores the amounts in the project, transaction, expenditure functional and project functional currencies. All applicable currency attributes are also stored here. This table is populated whenever the amount columns in the parent entity PA_FORECAST_ITEMS are modified. Previous entries are reversed and new entries created , based upon the changes in the PA_FORECAST_ITEMS entity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FI_AMOUNT_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORECAST_ITEM_ID LINE_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
FORECAST_ITEM_ID	NUMBER		Yes	The system generated number that uniquely identifies the forecast item
LINE_NUM	NUMBER	(15)	Yes	The line number of the forecast item
ITEM_DATE	DATE		Yes	The forecast item date
ITEM_UOM	VARCHAR2	(30)	Yes	The unit of measure of the forecast item
ITEM_QUANTITY	NUMBER		Yes	The quantity of the forecast item
REVERSED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the record is a reversal record or not
NET_ZERO_FLAG	VARCHAR2	(1)	Yes	Indicates whether the current and reversing line net out each other and therefore both can be deleted after summarization
LINE_NUM_REVERSED	NUMBER			The line number that is reversed by this line
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
REQUEST_ID	NUMBER			Request Id of the Concurrent Process that created this record
PROGRAM_APPLICATION_ID	NUMBER			Identifier of program application that created this record
PROGRAM_ID	NUMBER			Identifier of program that created this record
PROGRAM_UPDATE_DATE	DATE			Program update date
COST_TXN_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code of the cost amount
TXN_RAW_COST	NUMBER			The raw cost in transaction currency
TXN_BURDENED_COST	NUMBER			The burdened cost in transaction currency
REVENUE_TXN_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code of the revenue amount
TXN_REVENUE	NUMBER			The revenue in transaction currency
TP_TXN_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code of the transfer price amount
TXN_TRANSFER_PRICE	NUMBER			The transfer price in transaction currency
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		The project currency code
PROJECT_COST_RATE_DATE	DATE			The project cost rate date
PROJECT_COST_RATE_TYPE	VARCHAR2	(30)		The project cost rate type
PROJECT_COST_EXCHANGE_RATE	NUMBER			The project cost exchange rate
PROJECT_RAW_COST	NUMBER			The raw cost in project currency
PROJECT_BURDENED_COST	NUMBER			The burdened cost in project currency
PROJECT_REVENUE_RATE_DATE	DATE			The project revenue rate date
PROJECT_REVENUE_RATE_TYPE	VARCHAR2	(30)		The project revenue rate type
PROJECT_REVENUE_EXCHANGE_RATE	NUMBER			The project revenue exchange rate
PROJECT_REVENUE	NUMBER			The revenue in project currency
PROJECT_TP_RATE_DATE	DATE			The project transfer price rate date
PROJECT_TP_RATE_TYPE	VARCHAR2	(30)		The project transfer price rate type
PROJECT_TP_EXCHANGE_RATE	NUMBER			The project transfer price exchange rate
PROJECT_TRANSFER_PRICE	NUMBER			The transfer price in project currency
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		The project functional currency code
PROJFUNC_COST_RATE_DATE	DATE			The project functional cost rate date
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)		The project functional cost rate type
PROJFUNC_COST_EXCHANGE_RATE	NUMBER			The project functional cost exchange rate
PROJFUNC_RAW_COST	NUMBER			The raw cost in project functional currency
PROJFUNC_BURDENED_COST	NUMBER			The burdened cost in project functional currency
PROJFUNC_REVENUE	NUMBER			The revenue in project functional currency
PROJFUNC_TRANSFER_PRICE	NUMBER			The transfer price in project functional currency
EXPFUNC_CURRENCY_CODE	VARCHAR2	(15)		The expenditure functional currency code
EXPFUNC_COST_RATE_DATE	DATE			The expenditure functional cost rate date
EXPFUNC_COST_RATE_TYPE	VARCHAR2	(30)		The expenditure functional cost rate type
EXPFUNC_COST_EXCHANGE_RATE	NUMBER			The expenditure functional cost exchange rate
EXPFUNC_RAW_COST	NUMBER			The raw cost in expenditure functional currency
EXPFUNC_BURDENED_COST	NUMBER			The burdened cost in expenditure functional currency
EXPFUNC_TP_RATE_DATE	DATE			The expenditure functional transfer price rate date
EXPFUNC_TP_RATE_TYPE	VARCHAR2	(30)		The expenditure functional transfer price rate type
EXPFUNC_TP_EXCHANGE_RATE	NUMBER			The expenditure functional transfer price exchange rate
EXPFUNC_TRANSFER_PRICE	NUMBER			The transfer price in expenditure functional currency
PROJFUNC_REVENUE_RATE_DATE	DATE			The project functional revenue rate date
PROJFUNC_REVENUE_RATE_TYPE	VARCHAR2	(30)		The project functional revenue rate type
PROJFUNC_REVENUE_EXCHANGE_RATE	NUMBER			The project functional revenue exchange rate
PROJFUNC_TP_RATE_DATE	DATE			The project functional transfer price rate date
PROJFUNC_TP_RATE_TYPE	VARCHAR2	(30)		The project functional transfer price rate type
PROJFUNC_TP_EXCHANGE_RATE	NUMBER			The project functional transfer price exchange rate

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 does not reference any database object

PA.PA_FI_AMOUNT_DETAILS is referenced by following:

APPS: PA_FI_AMOUNT_DETAILS