View: PN_XLA_EXTRACT_LINES_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.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