[Home] [Help]
View: PN_XLA_EXTRACT_LINES_V
View Text
SELECT (ITEM.ACCOUNTED_AMOUNT * DIST.PERCENTAGE / 100) ACCOUNTED_AMOUNT
, (ITEM.EXPORT_CURRENCY_AMOUNT * DIST.PERCENTAGE / 100) ENTERED_AMOUNT
, DIST.ACCOUNT_ID CODE_COMBINATION_ID
, ITEM.ACCOUNTED_DATE CONVERSION_DATE
, TO_NUMBER(NULL) CONVERSION_RATE
, NULL CONVERSION_RATE_TYPE
, ITEM.EXPORT_CURRENCY_CODE CURRENCY_CODE
, DIST.ACCOUNT_CLASS DISTRIBUTION_TYPE
, TERM.SET_OF_BOOKS_ID LEDGER_ID
, XE.EVENT_ID EVENT_ID
, DIST.LINE_NUMBER LINE_NUMBER
FROM PN_PAYMENT_ITEMS ITEM
, PN_PAYMENT_TERMS_ALL TERM
, PN_DISTRIBUTIONS_ALL DIST
, XLA_EVENTS XE
, XLA_TRANSACTION_ENTITIES XTE
WHERE TERM.PAYMENT_TERM_ID = ITEM.PAYMENT_TERM_ID
AND TERM.PAYMENT_TERM_ID = DIST.PAYMENT_TERM_ID
AND ITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'NORMALIZED'
AND XTE.SOURCE_ID_INT_1 = ITEM.PAYMENT_ITEM_ID
AND XE.ENTITY_ID = XTE.ENTITY_ID
AND XE.APPLICATION_ID = 240
Columns
Name |
ACCOUNTED_AMOUNT |
ENTERED_AMOUNT |
CODE_COMBINATION_ID |
CONVERSION_DATE |
CONVERSION_RATE |
CONVERSION_RATE_TYPE |
CURRENCY_CODE |
DISTRIBUTION_TYPE |
LEDGER_ID |
EVENT_ID |
LINE_NUMBER |