VIEW: APPS.PN_XLA_EXTRACT_LINES_V

Source

View Text - Preformatted

SELECT nvl(pid.accounted_amount,0) accounted_amount, pid.entered_amount, pid.code_combination_id, item.accounted_date conversion_date, to_number(NULL) conversion_rate, NULL conversion_rate_type, item.export_currency_code currency_code, pid.account_class distribution_type, item.set_of_books_id ledger_id, xe.event_id event_id, pid.line_number line_number FROM pn_payment_items item, pn_payment_item_dist_all pid, xla_events xe, xla_transaction_entities xte WHERE item.payment_item_id = pid.payment_item_id 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(PID.ACCOUNTED_AMOUNT
, 0) ACCOUNTED_AMOUNT
, PID.ENTERED_AMOUNT
, PID.CODE_COMBINATION_ID
, ITEM.ACCOUNTED_DATE CONVERSION_DATE
, TO_NUMBER(NULL) CONVERSION_RATE
, NULL CONVERSION_RATE_TYPE
, ITEM.EXPORT_CURRENCY_CODE CURRENCY_CODE
, PID.ACCOUNT_CLASS DISTRIBUTION_TYPE
, ITEM.SET_OF_BOOKS_ID LEDGER_ID
, XE.EVENT_ID EVENT_ID
, PID.LINE_NUMBER LINE_NUMBER
FROM PN_PAYMENT_ITEMS ITEM
, PN_PAYMENT_ITEM_DIST_ALL PID
, XLA_EVENTS XE
, XLA_TRANSACTION_ENTITIES XTE
WHERE ITEM.PAYMENT_ITEM_ID = PID.PAYMENT_ITEM_ID
AND XTE.SOURCE_ID_INT_1 = ITEM.PAYMENT_ITEM_ID
AND XE.ENTITY_ID = XTE.ENTITY_ID
AND XE.APPLICATION_ID = 240