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: APPS.PN_XLA_EXTRACT_LINES_V

Object Details

Object Name:	PN_XLA_EXTRACT_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_XLA_EXTRACT_LINES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNTED_AMOUNT	NUMBER			Holds value of actual amount in functional currency, converted using user defined conversion type
ENTERED_AMOUNT	NUMBER			The actual amount to be exported for payment or billing after currency conversion
CODE_COMBINATION_ID	NUMBER			Identifies the row in the GL Code Combinations table associated with this distribution.
CONVERSION_DATE	DATE			The date on which the accounted amount is calculated.
CONVERSION_RATE	NUMBER			Conversion Rate
CONVERSION_RATE_TYPE	VARCHAR2	(0)		Conversion Rate Type
CURRENCY_CODE	VARCHAR2	(15)		Currency code used to export payment and billing items.
DISTRIBUTION_TYPE	VARCHAR2	(30)		Account class of the account in this distribution. The value is populated from the lookups PN_PAY_ACCOUNT_TYPE or PN_REC_ACCOUNT_TYPE.
LEDGER_ID	NUMBER		Yes	General Ledger Set of Books used. Associates the row in GL_SETS_OF_BOOKS with the payment or billing item row.
EVENT_ID	NUMBER	(15)	Yes	Event Id
LINE_NUMBER	NUMBER			The distribution line number displayed in the user interface

Query Text

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


SELECT ACCOUNTED_AMOUNT
,      ENTERED_AMOUNT
,      CODE_COMBINATION_ID
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CONVERSION_RATE_TYPE
,      CURRENCY_CODE
,      DISTRIBUTION_TYPE
,      LEDGER_ID
,      EVENT_ID
,      LINE_NUMBER
FROM APPS.PN_XLA_EXTRACT_LINES_V;

Dependencies

[top of page]

APPS.PN_XLA_EXTRACT_LINES_V references the following:

APPS: PN_PAYMENT_ITEMS; PN_PAYMENT_ITEM_DIST_ALL; XLA_EVENTS; XLA_TRANSACTION_ENTITIES

APPS.PN_XLA_EXTRACT_LINES_V is referenced by following:

APPS: XLA_00240_AAD_S_000003_PKG - show dependent code