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_PRJ_AST_LINE_DTLS

Object Details

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

PA_MC_PRJ_AST_LINE_DTLS is an MRC sub table of
PA_PROJECT_ASSET_LINE_DETAILS. It stores currency related
information about project asset line details for each reporting set of
books associated with the parent record on
PA_PROJECT_ASSET_LINE_DETAILS.
The primary key on this table is: SET_OF_BOOKS_ID,
PROJ_ASSET_LINE_DTL_UNIQ_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_MC_PROJ_ASSET_LINE_DTLS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID PROJ_ASSET_LINE_DTL_UNIQ_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The reporting ledger unique identifier
PROJ_ASSET_LINE_DTL_UNIQ_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the detail asset line
PROJECT_ASSET_LINE_DETAIL_ID	NUMBER	(15)	Yes	The attribute relating detail records to asset lines
CIP_COST	NUMBER		Yes	The cip cost amount in the reporting currency from the associated cost distribution line.
CURRENCY_CODE	VARCHAR2	(30)		The currency code associated with the reporting ledger.
EXCHANGE_RATE	NUMBER			The exchange rate used to convert from the functional currency to the reporting currency on the conversion
CONVERSION_DATE	DATE			The conversion date on which the reporting currency amounts were converted.

Query Text

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


SELECT SET_OF_BOOKS_ID
,      PROJ_ASSET_LINE_DTL_UNIQ_ID
,      PROJECT_ASSET_LINE_DETAIL_ID
,      CIP_COST
,      CURRENCY_CODE
,      EXCHANGE_RATE
,      CONVERSION_DATE
FROM PA.PA_MC_PRJ_AST_LINE_DTLS;

Dependencies

[top of page]

PA.PA_MC_PRJ_AST_LINE_DTLS does not reference any database object

PA.PA_MC_PRJ_AST_LINE_DTLS is referenced by following:

PA: PA_MC_PRJ_AST_LINE_DTLS#