View: PN_AEL_BILL_GL_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_AEL_BILL_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.CUSTOMER_ID THIRD_PARTY_ID
, HP.PARTY_NAME THIRD_PARTY_NAME
, HCSU.LOCATION 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
, FND_LOOKUPS L1
, FND_LOOKUPS L2
, FND_LOOKUPS L3
, FND_LOOKUPS L10
, FND_LOOKUPS L11
, HZ_CUST_SITE_USES HCSU
, HZ_CUST_ACCT_SITES HCAS
, HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HCA
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE L1.LOOKUP_CODE = PT.PAYMENT_PURPOSE_CODE AND L1.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE' AND 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_REC_ACCOUNT_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 PI.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND PI.CUSTOMER_SITE_USE_ID = HCSU.SITE_USE_ID
AND HP.PARTY_ID = HCA.PARTY_ID
AND HCAS.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND HCSU.SITE_USE_CODE = 'BILL_TO'
AND JC.JE_CATEGORY_NAME = AEH.AE_CATEGORY 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 LE.LEASE_ID = PT.LEASE_ID
AND AEL.GL_SL_LINK_ID = R.GL_SL_LINK_ID
AND AEL.CURRENCY_CONVERSION_TYPE = GLCT.CONVERSION_TYPE(+)

Columns