VIEW: APPS.PN_AEL_PAY_GL_V

Source

View Text - Preformatted

SELECT R.je_header_id JE_HEADER_ID, R.je_line_num JE_LINE_NUM, 240 APPLICATION_ID , aeh.set_of_books_id SET_OF_BOOKS_ID , aeh.org_id ORG_ID , AEH.PERIOD_NAME ACCOUNTING_RULE_NAME, LE.NAME TRX_CLASS_NAME, L1.MEANING TRX_TYPE_NAME , L10.meaning SALESREP_NAME, L11.MEANING TRX_NUMBER_DISPLAYED, ael.ACCOUNTED_CR ACCOUNTED_CR, ael.ACCOUNTED_DR ACCOUNTED_DR, aeh.accounting_date ACCOUNTING_DATE, ael.ae_line_type_code ACCT_LINE_TYPE, L3.meaning ACCT_LINE_TYPE_NAME, aeh.ae_header_id AEH_ID, ael.ae_line_id AEL_ID, ael.code_combination_id CODE_COMBINATION_ID, ael.currency_code CURRENCY_CODE, ael.CURRENCY_CONVERSION_DATE, ael.CURRENCY_CONVERSION_RATE, ael.CURRENCY_CONVERSION_TYPE, GLCT.user_conversion_type CURRENCY_USER_CONVERSION_TYPE, ael.entered_cr ENTERED_CR, ael.entered_dr ENTERED_DR, ael.source_id SOURCE_ID, ael.source_table SOURCE_TABLE, PI.VENDOR_ID THIRD_PARTY_ID, V.vendor_name THIRD_PARTY_NAME, VS.vendor_site_code THIRD_PARTY_SUB_NAME, Aeh.ae_category JE_CATEGORY, Jc.user_je_category_name USER_JE_CATEGORY_NAME, ael.LAST_UPDATE_DATE LAST_UPDATE_DATE, ael.LAST_UPDATED_BY LAST_UPDATED_BY, ael.CREATION_DATE CREATION_DATE, ael.CREATED_BY CREATED_BY, ael.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ael.REQUEST_ID REQUEST_ID, PI.PAYMENT_ITEM_type_lookup_code TRX_LINE_TYPE, L2.meaning TRX_LINE_TYPE_NAME, ael.ae_line_number ACCOUNTING_LINE_NUMBER, pt.start_date, pt.end_date, pt.payment_term_id TRX_SOURCE_ID FROM gl_import_references R, gl_je_categories jc, pn_ae_lines AEL, pn_ae_headers AEH, PN_PAYMENT_ITEMS_ALL PI, PN_PAYMENT_TERMS_ALL PT, PN_LEASES_ALL LE, po_vendor_sites_all VS, po_vendors V, FND_lookups L1, FND_lookups L2, FND_lookups L3, FND_lookups L10 , FND_lookups L11 , gl_daily_conversion_types GLCT WHERE L2.lookup_code(+) = PI.PAYMENT_ITEM_type_lookup_code AND L2.lookup_type(+) = 'PN_PAYMENT_ITEM_TYPE' and L3.lookup_code = ael.ae_line_type_code AND L3.lookup_type = 'PN_PAY_ACCOUNT_TYPE' AND L1.lookup_code = PT.payment_purpose_code AND L1.lookup_type = 'PN_PAYMENT_PURPOSE_TYPE' AND L10.lookup_code = PT.payment_term_type_code AND L10.lookup_type = 'PN_PAYMENT_TERM_TYPE' AND L11.lookup_code = PT.frequency_code AND L11.lookup_type = 'PN_PAYMENT_FREQUENCY_TYPE' AND jc.je_category_name = aeh.ae_category AND LE.LEASE_ID = PT.LEASE_ID AND VS.VENDOR_SITE_ID = PI.VENDOR_SITE_ID AND VS.VENDOR_ID = V.VENDOR_ID AND V.VENDOR_id = PI.vendor_id AND PT.PAYMENT_TERM_id = PI.payment_term_id AND AEH.ae_header_id = AEL.ae_header_id and ael.source_table = 'PN_PAYMENT_ITEMS' AND AEL.source_id = PI.PAYMENT_ITEM_ID AND AEL.gl_sl_link_id = R.gl_sl_link_id AND ael.currency_conversion_type = GLCT.conversion_type(+)

View Text - HTML Formatted

SELECT R.JE_HEADER_ID JE_HEADER_ID
, R.JE_LINE_NUM JE_LINE_NUM
, 240 APPLICATION_ID
, AEH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AEH.ORG_ID ORG_ID
, AEH.PERIOD_NAME ACCOUNTING_RULE_NAME
, LE.NAME TRX_CLASS_NAME
, L1.MEANING TRX_TYPE_NAME
, L10.MEANING SALESREP_NAME
, L11.MEANING TRX_NUMBER_DISPLAYED
, AEL.ACCOUNTED_CR ACCOUNTED_CR
, AEL.ACCOUNTED_DR ACCOUNTED_DR
, AEH.ACCOUNTING_DATE ACCOUNTING_DATE
, AEL.AE_LINE_TYPE_CODE ACCT_LINE_TYPE
, L3.MEANING ACCT_LINE_TYPE_NAME
, AEH.AE_HEADER_ID AEH_ID
, AEL.AE_LINE_ID AEL_ID
, AEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL.CURRENCY_CODE CURRENCY_CODE
, AEL.CURRENCY_CONVERSION_DATE
, AEL.CURRENCY_CONVERSION_RATE
, AEL.CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE CURRENCY_USER_CONVERSION_TYPE
, AEL.ENTERED_CR ENTERED_CR
, AEL.ENTERED_DR ENTERED_DR
, AEL.SOURCE_ID SOURCE_ID
, AEL.SOURCE_TABLE SOURCE_TABLE
, PI.VENDOR_ID THIRD_PARTY_ID
, V.VENDOR_NAME THIRD_PARTY_NAME
, VS.VENDOR_SITE_CODE THIRD_PARTY_SUB_NAME
, AEH.AE_CATEGORY JE_CATEGORY
, JC.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, AEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AEL.LAST_UPDATED_BY LAST_UPDATED_BY
, AEL.CREATION_DATE CREATION_DATE
, AEL.CREATED_BY CREATED_BY
, AEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AEL.REQUEST_ID REQUEST_ID
, PI.PAYMENT_ITEM_TYPE_LOOKUP_CODE TRX_LINE_TYPE
, L2.MEANING TRX_LINE_TYPE_NAME
, AEL.AE_LINE_NUMBER ACCOUNTING_LINE_NUMBER
, PT.START_DATE
, PT.END_DATE
, PT.PAYMENT_TERM_ID TRX_SOURCE_ID
FROM GL_IMPORT_REFERENCES R
, GL_JE_CATEGORIES JC
, PN_AE_LINES AEL
, PN_AE_HEADERS AEH
, PN_PAYMENT_ITEMS_ALL PI
, PN_PAYMENT_TERMS_ALL PT
, PN_LEASES_ALL LE
, PO_VENDOR_SITES_ALL VS
, PO_VENDORS V
, FND_LOOKUPS L1
, FND_LOOKUPS L2
, FND_LOOKUPS L3
, FND_LOOKUPS L10
, FND_LOOKUPS L11
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE L2.LOOKUP_CODE(+) = PI.PAYMENT_ITEM_TYPE_LOOKUP_CODE
AND L2.LOOKUP_TYPE(+) = 'PN_PAYMENT_ITEM_TYPE'
AND L3.LOOKUP_CODE = AEL.AE_LINE_TYPE_CODE
AND L3.LOOKUP_TYPE = 'PN_PAY_ACCOUNT_TYPE'
AND L1.LOOKUP_CODE = PT.PAYMENT_PURPOSE_CODE
AND L1.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND L10.LOOKUP_CODE = PT.PAYMENT_TERM_TYPE_CODE
AND L10.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND L11.LOOKUP_CODE = PT.FREQUENCY_CODE
AND L11.LOOKUP_TYPE = 'PN_PAYMENT_FREQUENCY_TYPE'
AND JC.JE_CATEGORY_NAME = AEH.AE_CATEGORY
AND LE.LEASE_ID = PT.LEASE_ID
AND VS.VENDOR_SITE_ID = PI.VENDOR_SITE_ID
AND VS.VENDOR_ID = V.VENDOR_ID
AND V.VENDOR_ID = PI.VENDOR_ID
AND PT.PAYMENT_TERM_ID = PI.PAYMENT_TERM_ID
AND AEH.AE_HEADER_ID = AEL.AE_HEADER_ID
AND AEL.SOURCE_TABLE = 'PN_PAYMENT_ITEMS'
AND AEL.SOURCE_ID = PI.PAYMENT_ITEM_ID
AND AEL.GL_SL_LINK_ID = R.GL_SL_LINK_ID
AND AEL.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)