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_AR

Object Details

Object Name:	PA_FI_AMOUNT_DETAILS_AR
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_FI_AMOUNT_DETAILS_AR
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_AR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PURGE_PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PURGE_BATCH_ID	NUMBER	(15)	Yes	Purge batch id
PURGE_RELEASE	VARCHAR2	(50)	Yes	Purge release version
PURGE_PROJECT_ID	NUMBER	(15)	Yes	Purged Project id
FORECAST_ITEM_ID	NUMBER	(15)		The system generated number that uniquely identifies the forecast item
LINE_NUM	NUMBER	(15)		The line number of the forecast item
ITEM_DATE	DATE			The forecast item date
ITEM_UOM	VARCHAR2	(30)		The unit of measure of the forecast item
ITEM_QUANTITY	NUMBER			The quantity of the forecast item
REVERSED_FLAG	VARCHAR2	(1)		Indicates whether the record is a reversal record or not
NET_ZERO_FLAG	VARCHAR2	(1)		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			Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Concurrent program Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent program Who column
PROGRAM_ID	NUMBER	(15)		Concurrent program Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent program Who column
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
PROJFUNC_RATE_DATE	DATE			The project functional currency rate date
PROJFUNC_RATE_TYPE	VARCHAR2	(30)		The project functional currency rate type
PROJFUNC_EXCHANGE_RATE	NUMBER			The project functional currency exchange rate
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

Query Text

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


SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      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
,      PROJFUNC_RATE_DATE
,      PROJFUNC_RATE_TYPE
,      PROJFUNC_EXCHANGE_RATE
,      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
FROM PA.PA_FI_AMOUNT_DETAILS_AR;

Dependencies

[top of page]

PA.PA_FI_AMOUNT_DETAILS_AR does not reference any database object

PA.PA_FI_AMOUNT_DETAILS_AR is referenced by following:

APPS: PA_FI_AMOUNT_DETAILS_AR