[Home] [Help] [Dependency Information]
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 |
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.
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 | (15) | Yes | 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 |
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;
|
|
|