View: PN_XLA_EXTRACT_HEADERS_V

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

View Text

SELECT LEASE_CLASS_LKUP.MEANING LEASE_CLASS
, LEASE.NAME LEASE_NAME
, LEASE.LEASE_NUM LEASE_NUMBER
, TERM.LOCATION_ID LOCATION_ID
, LOCN.LOCATION_CODE LOCATION_CODE
, ITEM.PAYMENT_ITEM_ID PAYMENT_ITEM_ID
, ITEM.PAYMENT_TERM_ID PAYMENT_TERM_ID
, TERM_PURPOSE_LKUP.MEANING PAYMENT_PURPOSE
, TERM_TYPE_LKUP.MEANING PAYMENT_TYPE
, TERM_FREQ_LKUP.MEANING PAYMENT_TERM_FREQUENCY
, PROP.PROPERTY_CODE PROPERTY_CODE
, PROP.PROPERTY_NAME PROPERTY_NAME
, TERM.CUSTOMER_ID CUSTOMER_ACCOUNT_ID
, CUST.PARTY_NAME CUSTOMER_NAME
, CUST_SITE.LOCATION CUSTOMER_SITE
, TERM.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_ID
, TERM.VENDOR_ID SUPPLIER_ID
, TERM.VENDOR_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER.VENDOR_NAME SUPPLIER_NAME
, SUPPLIER_SITE.VENDOR_SITE_CODE SUPPLIER_SITE
, XE.EVENT_ID EVENT_ID
, TERM.ATTRIBUTE_CATEGORY TERM_ATTRIBUTE_CATEGORY
, TERM.ATTRIBUTE1 TERM_ATTRIBUTE1
, TERM.ATTRIBUTE2 TERM_ATTRIBUTE2
, TERM.ATTRIBUTE3 TERM_ATTRIBUTE3
, TERM.ATTRIBUTE4 TERM_ATTRIBUTE4
, TERM.ATTRIBUTE5 TERM_ATTRIBUTE5
, TERM.ATTRIBUTE6 TERM_ATTRIBUTE6
, TERM.ATTRIBUTE7 TERM_ATTRIBUTE7
, TERM.ATTRIBUTE8 TERM_ATTRIBUTE8
, TERM.ATTRIBUTE9 TERM_ATTRIBUTE9
, TERM.ATTRIBUTE10 TERM_ATTRIBUTE10
, TERM.ATTRIBUTE11 TERM_ATTRIBUTE11
, TERM.ATTRIBUTE12 TERM_ATTRIBUTE12
, TERM.ATTRIBUTE13 TERM_ATTRIBUTE13
, TERM.ATTRIBUTE14 TERM_ATTRIBUTE14
, TERM.ATTRIBUTE15 TERM_ATTRIBUTE15
, ITEM.ATTRIBUTE_CATEGORY ITEM_ATTRIBUTE_CATEGORY
, ITEM.ATTRIBUTE1 ITEM_ATTRIBUTE1
, ITEM.ATTRIBUTE2 ITEM_ATTRIBUTE2
, ITEM.ATTRIBUTE3 ITEM_ATTRIBUTE3
, ITEM.ATTRIBUTE4 ITEM_ATTRIBUTE4
, ITEM.ATTRIBUTE5 ITEM_ATTRIBUTE5
, ITEM.ATTRIBUTE6 ITEM_ATTRIBUTE6
, ITEM.ATTRIBUTE7 ITEM_ATTRIBUTE7
, ITEM.ATTRIBUTE8 ITEM_ATTRIBUTE8
, ITEM.ATTRIBUTE9 ITEM_ATTRIBUTE9
, ITEM.ATTRIBUTE10 ITEM_ATTRIBUTE10
, ITEM.ATTRIBUTE11 ITEM_ATTRIBUTE11
, ITEM.ATTRIBUTE12 ITEM_ATTRIBUTE12
, ITEM.ATTRIBUTE13 ITEM_ATTRIBUTE13
, ITEM.ATTRIBUTE14 ITEM_ATTRIBUTE14
, ITEM.ATTRIBUTE15 ITEM_ATTRIBUTE15
FROM PN_PAYMENT_ITEMS ITEM
, PN_PAYMENT_TERMS_ALL TERM
, PN_LOCATIONS_ALL LOCN
, PN_PROPERTIES_ALL PROP
, PN_LEASES_ALL LEASE
, FND_LOOKUPS LEASE_CLASS_LKUP
, FND_LOOKUPS TERM_PURPOSE_LKUP
, FND_LOOKUPS TERM_TYPE_LKUP
, FND_LOOKUPS TERM_FREQ_LKUP
, PO_VENDORS SUPPLIER
, PO_VENDOR_SITES_ALL SUPPLIER_SITE
, HZ_PARTIES CUST
, HZ_CUST_ACCOUNTS_ALL CUST_ACCT
, HZ_CUST_SITE_USES_ALL CUST_SITE
, XLA_EVENTS XE
, XLA_TRANSACTION_ENTITIES XTE
WHERE TERM.PAYMENT_TERM_ID = ITEM.PAYMENT_TERM_ID
AND TERM.LEASE_ID = LEASE.LEASE_ID
AND LOCN.LOCATION_ID (+) = TERM.LOCATION_ID
AND PROP.PROPERTY_ID (+) = LOCN.PROPERTY_ID
AND LEASE_CLASS_LKUP.LOOKUP_TYPE = 'PN_LEASE_CLASS'
AND LEASE_CLASS_LKUP.LOOKUP_CODE = LEASE.LEASE_CLASS_CODE
AND TERM_PURPOSE_LKUP.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND TERM_PURPOSE_LKUP.LOOKUP_CODE = TERM.PAYMENT_TERM_TYPE_CODE
AND TERM_TYPE_LKUP.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND TERM_TYPE_LKUP.LOOKUP_CODE = TERM.PAYMENT_PURPOSE_CODE
AND TERM_FREQ_LKUP.LOOKUP_TYPE = 'PN_PAYMENT_FREQUENCY_TYPE'
AND TERM_FREQ_LKUP.LOOKUP_CODE = TERM.FREQUENCY_CODE
AND TERM.VENDOR_ID = SUPPLIER.VENDOR_ID (+)
AND TERM.VENDOR_SITE_ID = SUPPLIER_SITE.VENDOR_SITE_ID (+)
AND CUST_ACCT.PARTY_ID = CUST.PARTY_ID (+)
AND TERM.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID (+)
AND TERM.CUSTOMER_SITE_USE_ID = CUST_SITE.SITE_USE_ID (+)
AND ITEM.PAYMENT_ITEM_TYPE_LOOKUP_CODE = 'NORMALIZED'
AND XE.ENTITY_ID = XTE.ENTITY_ID
AND ITEM.PAYMENT_ITEM_ID = XTE.SOURCE_ID_INT_1
AND XE.APPLICATION_ID = 240

Columns