VIEW: APPS.PN_XLA_EXTRACT_LINES_V

Source

View Text - Preformatted

SELECT (NVL(item.accounted_amount,0) * 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

View Text - HTML Formatted

SELECT (NVL(ITEM.ACCOUNTED_AMOUNT
, 0) * 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