VIEW: APPS.PN_LEASES_V

Source

View Text - Preformatted

SELECT lease.rowid row_id, lease.lease_id lease_id, lease.last_update_date last_update_date, lease.last_updated_by last_updated_by, lease.creation_date creation_date, lease.created_by created_by, lease.last_update_login last_update_login, lease.name lease_name, lease.lease_num lease_number, lease.parent_lease_id parent_lease_id, lease.lease_type_code lease_type_code, lease.lease_class_code lease_class_code, lease.payment_term_proration_rule payment_term_rule, lease.comments comments, lease.status status, lease.lease_status lease_status, lease.location_id location_id, lease.customer_id customer_id, hzp.party_name customer_name, hca.account_number customer_number, ldet.lease_detail_id lease_detail_id, ldet.attribute_category attribute_category, ldet.attribute1 attribute1, ldet.attribute2 attribute2, ldet.attribute3 attribute3, ldet.attribute4 attribute4, ldet.attribute5 attribute5, ldet.attribute6 attribute6, ldet.attribute7 attribute7, ldet.attribute8 attribute8, ldet.attribute9 attribute9, ldet.attribute10 attribute10, ldet.attribute11 attribute11, ldet.attribute12 attribute12, ldet.attribute13 attribute13, ldet.attribute14 attribute14, ldet.attribute15 attribute15, lchange.lease_change_id lease_change_id, ldet.expense_account_id expense_account_id, ldet.accrual_account_id accrual_account_id, ldet.receivable_account_id receivable_account_id, ldet.term_template_id term_template_id, ldet.lease_commencement_date lease_commencement_date, ldet.lease_termination_date lease_termination_date, ldet.lease_execution_date lease_execution_date, ldet.lease_extension_end_date lease_extension_end_date, (TRUNC(ldet.lease_termination_date) - TRUNC(ldet.lease_commencement_date) + 1) lease_term, lease.abstracted_by_user abstracted_by_user_id, fna.user_name user_abstracted, ldet.responsible_user responsible_user_id, fnr.user_name user_responsible, look.meaning lease_type, look2.meaning lease_class, mlease.lease_num parent_lease_number, mlease.name parent_lease_name, ldet.grouping_rule_id grouping_rule_id, pngr.name inv_group_name, lease.org_id org_id, pnp_util_func.get_loc_name_disp(lease.lease_id,ldet.lease_commencement_date) location_name_disp, pnp_util_func.get_loc_code_disp(lease.lease_id,ldet.lease_commencement_date) location_code_disp, pnp_util_func.get_prop_name_disp(lease.lease_id,ldet.lease_commencement_date) property_name_disp FROM pn_leases_all mlease, pn_lease_changes_all lchange, pn_lease_details_all ldet, fnd_user fna, fnd_user fnr, fnd_lookups look, fnd_lookups look2, hz_parties hzp, hz_cust_accounts hca, pn_leases lease, PN_PAY_GROUP_RULES pngr WHERE mlease.lease_id(+) = lease.parent_lease_id AND lchange.lease_change_number IS NULL AND lchange.lease_id = ldet.lease_id AND ldet.lease_id = lease.lease_id AND fna.user_id = lease.abstracted_by_user AND fnr.user_id = ldet.responsible_user AND look.lookup_type = 'PN_LEASE_TYPE' AND look.lookup_code = lease.lease_type_code AND look2.lookup_type = 'PN_LEASE_CLASS' AND look2.lookup_code = lease.lease_class_code AND hca.cust_account_id (+) = lease.customer_id AND hzp.party_id (+) = hca.party_id AND pngr.grouping_rule_id(+) = ldet.grouping_rule_id

View Text - HTML Formatted

SELECT LEASE.ROWID ROW_ID
, LEASE.LEASE_ID LEASE_ID
, LEASE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LEASE.LAST_UPDATED_BY LAST_UPDATED_BY
, LEASE.CREATION_DATE CREATION_DATE
, LEASE.CREATED_BY CREATED_BY
, LEASE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LEASE.NAME LEASE_NAME
, LEASE.LEASE_NUM LEASE_NUMBER
, LEASE.PARENT_LEASE_ID PARENT_LEASE_ID
, LEASE.LEASE_TYPE_CODE LEASE_TYPE_CODE
, LEASE.LEASE_CLASS_CODE LEASE_CLASS_CODE
, LEASE.PAYMENT_TERM_PRORATION_RULE PAYMENT_TERM_RULE
, LEASE.COMMENTS COMMENTS
, LEASE.STATUS STATUS
, LEASE.LEASE_STATUS LEASE_STATUS
, LEASE.LOCATION_ID LOCATION_ID
, LEASE.CUSTOMER_ID CUSTOMER_ID
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, LDET.LEASE_DETAIL_ID LEASE_DETAIL_ID
, LDET.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LDET.ATTRIBUTE1 ATTRIBUTE1
, LDET.ATTRIBUTE2 ATTRIBUTE2
, LDET.ATTRIBUTE3 ATTRIBUTE3
, LDET.ATTRIBUTE4 ATTRIBUTE4
, LDET.ATTRIBUTE5 ATTRIBUTE5
, LDET.ATTRIBUTE6 ATTRIBUTE6
, LDET.ATTRIBUTE7 ATTRIBUTE7
, LDET.ATTRIBUTE8 ATTRIBUTE8
, LDET.ATTRIBUTE9 ATTRIBUTE9
, LDET.ATTRIBUTE10 ATTRIBUTE10
, LDET.ATTRIBUTE11 ATTRIBUTE11
, LDET.ATTRIBUTE12 ATTRIBUTE12
, LDET.ATTRIBUTE13 ATTRIBUTE13
, LDET.ATTRIBUTE14 ATTRIBUTE14
, LDET.ATTRIBUTE15 ATTRIBUTE15
, LCHANGE.LEASE_CHANGE_ID LEASE_CHANGE_ID
, LDET.EXPENSE_ACCOUNT_ID EXPENSE_ACCOUNT_ID
, LDET.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, LDET.RECEIVABLE_ACCOUNT_ID RECEIVABLE_ACCOUNT_ID
, LDET.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, LDET.LEASE_COMMENCEMENT_DATE LEASE_COMMENCEMENT_DATE
, LDET.LEASE_TERMINATION_DATE LEASE_TERMINATION_DATE
, LDET.LEASE_EXECUTION_DATE LEASE_EXECUTION_DATE
, LDET.LEASE_EXTENSION_END_DATE LEASE_EXTENSION_END_DATE
, (TRUNC(LDET.LEASE_TERMINATION_DATE) - TRUNC(LDET.LEASE_COMMENCEMENT_DATE) + 1) LEASE_TERM
, LEASE.ABSTRACTED_BY_USER ABSTRACTED_BY_USER_ID
, FNA.USER_NAME USER_ABSTRACTED
, LDET.RESPONSIBLE_USER RESPONSIBLE_USER_ID
, FNR.USER_NAME USER_RESPONSIBLE
, LOOK.MEANING LEASE_TYPE
, LOOK2.MEANING LEASE_CLASS
, MLEASE.LEASE_NUM PARENT_LEASE_NUMBER
, MLEASE.NAME PARENT_LEASE_NAME
, LDET.GROUPING_RULE_ID GROUPING_RULE_ID
, PNGR.NAME INV_GROUP_NAME
, LEASE.ORG_ID ORG_ID
, PNP_UTIL_FUNC.GET_LOC_NAME_DISP(LEASE.LEASE_ID
, LDET.LEASE_COMMENCEMENT_DATE) LOCATION_NAME_DISP
, PNP_UTIL_FUNC.GET_LOC_CODE_DISP(LEASE.LEASE_ID
, LDET.LEASE_COMMENCEMENT_DATE) LOCATION_CODE_DISP
, PNP_UTIL_FUNC.GET_PROP_NAME_DISP(LEASE.LEASE_ID
, LDET.LEASE_COMMENCEMENT_DATE) PROPERTY_NAME_DISP
FROM PN_LEASES_ALL MLEASE
, PN_LEASE_CHANGES_ALL LCHANGE
, PN_LEASE_DETAILS_ALL LDET
, FND_USER FNA
, FND_USER FNR
, FND_LOOKUPS LOOK
, FND_LOOKUPS LOOK2
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, PN_LEASES LEASE
, PN_PAY_GROUP_RULES PNGR
WHERE MLEASE.LEASE_ID(+) = LEASE.PARENT_LEASE_ID
AND LCHANGE.LEASE_CHANGE_NUMBER IS NULL
AND LCHANGE.LEASE_ID = LDET.LEASE_ID
AND LDET.LEASE_ID = LEASE.LEASE_ID
AND FNA.USER_ID = LEASE.ABSTRACTED_BY_USER
AND FNR.USER_ID = LDET.RESPONSIBLE_USER
AND LOOK.LOOKUP_TYPE = 'PN_LEASE_TYPE'
AND LOOK.LOOKUP_CODE = LEASE.LEASE_TYPE_CODE
AND LOOK2.LOOKUP_TYPE = 'PN_LEASE_CLASS'
AND LOOK2.LOOKUP_CODE = LEASE.LEASE_CLASS_CODE
AND HCA.CUST_ACCOUNT_ID (+) = LEASE.CUSTOMER_ID
AND HZP.PARTY_ID (+) = HCA.PARTY_ID
AND PNGR.GROUPING_RULE_ID(+) = LDET.GROUPING_RULE_ID