VIEW: APPS.PN_XLA_EXTRACT_HEADERS_V

Source

View Text - Preformatted

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 ,substr(cust.party_name,1,240) 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 locn.active_start_date (+) <= term.start_date AND locn.active_end_date (+) >= term.end_date 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

View Text - HTML Formatted

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
, SUBSTR(CUST.PARTY_NAME
, 1
, 240) 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 LOCN.ACTIVE_START_DATE (+) <= TERM.START_DATE
AND LOCN.ACTIVE_END_DATE (+) >= TERM.END_DATE
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