View: PN_AEL_PAY_GL_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_AEL_PAY_GL_V

View Text

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(+)

Columns