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_MC_EXP_ITEMS_ALL

Object Details

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

PA_MC_EXP_ITEMS_ALL is an MRC sub table of PA_EXPENDITURE_ITEMS_ALL.
It stores currency related information about expenditure items for
each reporting
set of books associated with the parent record on
PA_EXPENDITURE_ITEMS_ALL. The primary key on this table is:
SET_OF_BOOKS_ID, EXPENDITURE_ITEM_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	40
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_MC_EXPENDITURE_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID EXPENDITURE_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The reporting set of books unique identifier
EXPENDITURE_ITEM_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the expenditure item
RAW_COST	NUMBER			The total raw cost of the expenditure item in the reporting currency.
RAW_COST_RATE	NUMBER			The raw cost rate in the reporting currency used to cost the item
BURDEN_COST	NUMBER			Total burdened cost of the expenditure item in the reporting currency.
BURDEN_COST_RATE	NUMBER			The burdened cost rate in the reporting currency of the item.
RAW_REVENUE	NUMBER			The potential revenue of the item in the reporting currency.
BILL_RATE	NUMBER			The bill rate in the reporting currency for the expenditure item.
ACCRUED_REVENUE	NUMBER			The total amount of revenue that the item accrued in the reporting currency.
ACCRUAL_RATE	NUMBER			The rate in the reporting currency based on the accrued revenue.
ADJUSTED_REVENUE	NUMBER			The discounted revenue amount of the item in the reporting currency based on the bill rate schedule
ADJUSTED_RATE	NUMBER			The rate in the reporting currency based on the adjusted revenue.
BILL_AMOUNT	NUMBER			The amount to be billed for the item in the reporting currency.
FORECAST_REVENUE	NUMBER			The forecast revenue amount of a labor item based on T&M bill rates and markups and labor multiplier
NET_ZERO_ADJUSTMENT_FLAG	VARCHAR2	(1)		Flag that indicates whether the item is fully reversed or the item is one of the adjusting items
TRANSFERRED_FROM_EXP_ITEM_ID	NUMBER	(15)		The identifier of the expenditure item from which this expenditure item originated.
PRC_ASSIGNMENT_ID	NUMBER		Yes	The assignment identifier used for project reporting currency
CURRENCY_CODE	VARCHAR2	(30)		The currency code associated with the reporting set of books
COST_EXCHANGE_RATE	NUMBER			The exchange rate used to convert raw cost to the reporting set of books currency
COST_CONVERSION_DATE	DATE			The date used to convert raw cost to the reporting set of books currency
COST_RATE_TYPE	VARCHAR2	(30)		The rate type used to convert raw cost to the reporting set of books currency
REVENUE_EXCHANGE_RATE	NUMBER			The exchange rate used to convert revenue to the reporting set of books currency
REVENUE_CONVERSION_DATE	DATE			The date used to convert revenue to the reporting set of books currency
REVENUE_RATE_TYPE	VARCHAR2	(30)		The rate type used to convert revenue to the reporting set of books currency
TRANSFER_PRICE	NUMBER			The transfer price amount in the reporting currency code
TP_EXCHANGE_RATE	NUMBER			The exchange rate used to convert transfer price amount to the reporting currency code
TP_CONVERSION_DATE	DATE			The date used to convert transfer price amount to the reporting currency code
TP_RATE_TYPE	VARCHAR2	(30)		The rate type used to convert transfer price amount to the reporting currency code
PROJFUNC_INV_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency to project functional currency during invoice generation.
PROJFUNC_INV_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during invoice generation.
PROJFUNC_INV_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency to project functional currency during invoice generation.
PROJFUNC_FCST_RATE_TYPE	VARCHAR2	(30)		Exchange rate type to use for conversion from bill transaction currency to project functional currency during revenue generation.
PROJFUNC_FCST_RATE_DATE	DATE			Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during revenue generation.
PROJFUNC_FCST_EXCHANGE_RATE	NUMBER			Exchange rate to use for conversion from bill transaction currency to project functional currency during revenue generation.

Query Text

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


SELECT SET_OF_BOOKS_ID
,      EXPENDITURE_ITEM_ID
,      RAW_COST
,      RAW_COST_RATE
,      BURDEN_COST
,      BURDEN_COST_RATE
,      RAW_REVENUE
,      BILL_RATE
,      ACCRUED_REVENUE
,      ACCRUAL_RATE
,      ADJUSTED_REVENUE
,      ADJUSTED_RATE
,      BILL_AMOUNT
,      FORECAST_REVENUE
,      NET_ZERO_ADJUSTMENT_FLAG
,      TRANSFERRED_FROM_EXP_ITEM_ID
,      PRC_ASSIGNMENT_ID
,      CURRENCY_CODE
,      COST_EXCHANGE_RATE
,      COST_CONVERSION_DATE
,      COST_RATE_TYPE
,      REVENUE_EXCHANGE_RATE
,      REVENUE_CONVERSION_DATE
,      REVENUE_RATE_TYPE
,      TRANSFER_PRICE
,      TP_EXCHANGE_RATE
,      TP_CONVERSION_DATE
,      TP_RATE_TYPE
,      PROJFUNC_INV_RATE_TYPE
,      PROJFUNC_INV_RATE_DATE
,      PROJFUNC_INV_EXCHANGE_RATE
,      PROJFUNC_FCST_RATE_TYPE
,      PROJFUNC_FCST_RATE_DATE
,      PROJFUNC_FCST_EXCHANGE_RATE
FROM PA.PA_MC_EXP_ITEMS_ALL;

Dependencies

[top of page]

PA.PA_MC_EXP_ITEMS_ALL does not reference any database object

PA.PA_MC_EXP_ITEMS_ALL is referenced by following:

APPS: PA_MC_EXP_ITEMS_ALL