View: PN_PAYMENT_TERMS_HISTORY_V

Product:	PN - Property Manager
Description:	Term History Form View.
Implementation/DBA Data:	APPS.PN_PAYMENT_TERMS_HISTORY_V

View Text

SELECT PTH.TERM_HISTORY_ID TERM_HISTORY_ID
, PTH.PREV_TERM_HISTORY_ID PREV_TERM_HISTORY_ID
, PTH.DISTRIBUTION_CHANGE_ID DISTRIBUTION_CHANGE_ID
, PTH.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PTH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTH.LAST_UPDATED_BY LAST_UPDATED_BY
, PTH.CREATION_DATE CREATION_DATE
, PTH.CREATED_BY CREATED_BY
, PTH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PTH.PAYMENT_PURPOSE_CODE PAYMENT_PURPOSE_CODE
, PTH.PAYMENT_TERM_TYPE_CODE PAYMENT_TERM_TYPE_CODE
, PTH.FREQUENCY_CODE FREQUENCY_CODE
, PTH.NORMALIZE NORMALIZE
, PTH.LEASE_ID LEASE_ID
, PTH.LEASE_CHANGE_ID LEASE_CHANGE_ID
, PTH.START_DATE START_DATE
, PTH.END_DATE END_DATE
, PTH.VENDOR_ID VENDOR_ID
, PTH.VENDOR_SITE_ID VENDOR_SITE_ID
, PTH.CUSTOMER_ID CUSTOMER_ID
, PTH.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PTH.TARGET_DATE TARGET_DATE
, PTH.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PTH.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PTH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PTH.CURRENCY_CODE CURRENCY_CODE
, PTH.RATE RATE
, PTH.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PTH.ATTRIBUTE1 ATTRIBUTE1
, PTH.ATTRIBUTE2 ATTRIBUTE2
, PTH.ATTRIBUTE3 ATTRIBUTE3
, PTH.ATTRIBUTE4 ATTRIBUTE4
, PTH.ATTRIBUTE5 ATTRIBUTE5
, PTH.ATTRIBUTE6 ATTRIBUTE6
, PTH.ATTRIBUTE7 ATTRIBUTE7
, PTH.ATTRIBUTE8 ATTRIBUTE8
, PTH.ATTRIBUTE9 ATTRIBUTE9
, PTH.ATTRIBUTE10 ATTRIBUTE10
, PTH.ATTRIBUTE11 ATTRIBUTE11
, PTH.ATTRIBUTE12 ATTRIBUTE12
, PTH.ATTRIBUTE13 ATTRIBUTE13
, PTH.ATTRIBUTE14 ATTRIBUTE14
, PTH.ATTRIBUTE15 ATTRIBUTE15
, PTH.LOCATION_ID LOCATION_ID
, PTH.SCHEDULE_DAY SCHEDULE_DAY
, PTH.CUST_SHIP_SITE_ID CUST_SHIP_SITE_ID
, PTH.AP_AR_TERM_ID AP_AR_TERM_ID
, PTH.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, PTH.PROJECT_ID PROJECT_ID
, PTH.TASK_ID TASK_ID
, PTH.ORGANIZATION_ID ORGANIZATION_ID
, PTH.EXPENDITURE_TYPE EXPENDITURE_TYPE
, PTH.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PTH.TAX_GROUP_ID TAX_GROUP_ID
, PTH.TAX_CODE_ID TAX_CODE_ID
, PTH.TAX_INCLUDED TAX_INCLUDED
, PTH.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, PTH.INV_RULE_ID INV_RULE_ID
, PTH.ACCOUNT_RULE_ID ACCOUNT_RULE_ID
, PTH.SALESREP_ID SALESREP_ID
, PTH.APPROVED_BY APPROVED_BY
, PTH.STATUS STATUS
, PTH.INDEX_PERIOD_ID INDEX_PERIOD_ID
, PTH.INDEX_TERM_INDICATOR INDEX_TERM_INDICATOR
, PTH.PO_HEADER_ID PO_HEADER_ID
, PTH.CUST_PO_NUMBER CUST_PO_NUMBER
, PTH.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, PTH.VAR_RENT_INV_ID VAR_RENT_INV_ID
, PTH.VAR_RENT_TYPE VAR_RENT_TYPE
, PTH.CHANGED_FLAG CHANGED_FLAG
, PTH.RECOVERABLE_FLAG RECOVERABLE_FLAG
, PTH.PERIOD_BILLREC_ID PERIOD_BILLREC_ID
, PTH.REC_AGR_LINE_ID REC_AGR_LINE_ID
, PTH.AMOUNT_TYPE AMOUNT_TYPE
, PTH.NORM_START_DATE NORM_START_DATE
, PTH.PROJECT_ATTRIBUTE_CATEGORY INTERFACE_LINE_CONTEXT
, PTH.PROJECT_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1
, PTH.PROJECT_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, PTH.PROJECT_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3
, PTH.PROJECT_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4
, PTH.PROJECT_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5
, PTH.PROJECT_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6
, PTH.PROJECT_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7
, PTH.PROJECT_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8
, PTH.PROJECT_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9
, PTH.PROJECT_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10
, PTH.PROJECT_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11
, PTH.PROJECT_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12
, PTH.PROJECT_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13
, PTH.PROJECT_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14
, PTH.PROJECT_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15
, PTH.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, PPLOOK.MEANING PAYMENT_PURPOSE
, PTLOOK.MEANING PAYMENT_TERM_TYPE
, PFLOOK.MEANING FREQUENCY_TYPE
, POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.VENDOR_SITE_CODE VENDOR_SITE
, NULL AS TAX_FLAG
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCSU_BILL.LOCATION CUSTOMER_SITE_USE
, HCSU_SHIP.LOCATION CUST_SHIP_SITE_USE
, PNP_UTIL_FUNC.GET_TOTAL_PAYMENT_TERM_AMT(PTH.PAYMENT_TERM_ID) TOTAL_PAYMENT
, PNP_UTIL_FUNC.GET_TOTAL_LEASED_AREA(PTH.LEASE_ID
, PTH.START_DATE) LEASED_AREA
, PTH.AREA_TYPE_CODE AREA_TYPE_CODE
, PTH.AREA AREA
, PTH.GROUPING_RULE_ID GROUPING_RULE_ID
, PPGR.NAME INV_GROUP_NAME
, PTEMP.NAME TERM_TEMPLATE
, PTH.TERM_COMMENTS TERM_COMMENTS
, PTH.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PCLOOK.MEANING TCC_PAYMENT
, PCLOOK.MEANING TCC_BILLING
FROM HZ_CUST_SITE_USES_ALL HCSU_BILL
, HZ_CUST_SITE_USES_ALL HCSU_SHIP
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, FND_LOOKUPS PFLOOK
, FND_LOOKUPS PTLOOK
, FND_LOOKUPS PPLOOK
, FND_LOOKUPS PCLOOK
, PN_PAY_GROUP_RULES PPGR
, PN_PAYMENT_TERMS_HISTORY PTH
, PN_TERM_TEMPLATES_ALL PTEMP
, PN_LEASES_ALL PLEASES
WHERE PTH.LEASE_ID = PLEASES.LEASE_ID
AND PLEASES.LEASE_CLASS_CODE IN ('DIRECT'
, 'PAY')
AND PCLOOK.LOOKUP_TYPE(+) = 'ZX_INPUT_CLASSIFICATIONS'
AND PCLOOK.LOOKUP_CODE(+) = PTH.TAX_CLASSIFICATION_CODE
AND PPLOOK.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND PPLOOK.LOOKUP_CODE = PTH.PAYMENT_PURPOSE_CODE
AND PTLOOK.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND PTLOOK.LOOKUP_CODE = PTH.PAYMENT_TERM_TYPE_CODE
AND PFLOOK.LOOKUP_TYPE = 'PN_PAYMENT_FREQUENCY_TYPE'
AND PFLOOK.LOOKUP_CODE = PTH.FREQUENCY_CODE
AND POV.VENDOR_ID (+)= PTH.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+)= PTH.VENDOR_SITE_ID
AND HCA.CUST_ACCOUNT_ID (+)= PTH.CUSTOMER_ID
AND HZP.PARTY_ID (+)= HCA.PARTY_ID
AND HCSU_BILL.SITE_USE_ID (+)= PTH.CUSTOMER_SITE_USE_ID
AND HCSU_SHIP.SITE_USE_ID (+)= PTH.CUST_SHIP_SITE_ID
AND PPGR.GROUPING_RULE_ID (+)= PTH.GROUPING_RULE_ID
AND PTH.TERM_TEMPLATE_ID = PTEMP.TERM_TEMPLATE_ID(+) UNION ALL SELECT PTH.TERM_HISTORY_ID TERM_HISTORY_ID
, PTH.PREV_TERM_HISTORY_ID PREV_TERM_HISTORY_ID
, PTH.DISTRIBUTION_CHANGE_ID DISTRIBUTION_CHANGE_ID
, PTH.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PTH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTH.LAST_UPDATED_BY LAST_UPDATED_BY
, PTH.CREATION_DATE CREATION_DATE
, PTH.CREATED_BY CREATED_BY
, PTH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PTH.PAYMENT_PURPOSE_CODE PAYMENT_PURPOSE_CODE
, PTH.PAYMENT_TERM_TYPE_CODE PAYMENT_TERM_TYPE_CODE
, PTH.FREQUENCY_CODE FREQUENCY_CODE
, PTH.NORMALIZE NORMALIZE
, PTH.LEASE_ID LEASE_ID
, PTH.LEASE_CHANGE_ID LEASE_CHANGE_ID
, PTH.START_DATE START_DATE
, PTH.END_DATE END_DATE
, PTH.VENDOR_ID VENDOR_ID
, PTH.VENDOR_SITE_ID VENDOR_SITE_ID
, PTH.CUSTOMER_ID CUSTOMER_ID
, PTH.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, PTH.TARGET_DATE TARGET_DATE
, PTH.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PTH.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PTH.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PTH.CURRENCY_CODE CURRENCY_CODE
, PTH.RATE RATE
, PTH.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PTH.ATTRIBUTE1 ATTRIBUTE1
, PTH.ATTRIBUTE2 ATTRIBUTE2
, PTH.ATTRIBUTE3 ATTRIBUTE3
, PTH.ATTRIBUTE4 ATTRIBUTE4
, PTH.ATTRIBUTE5 ATTRIBUTE5
, PTH.ATTRIBUTE6 ATTRIBUTE6
, PTH.ATTRIBUTE7 ATTRIBUTE7
, PTH.ATTRIBUTE8 ATTRIBUTE8
, PTH.ATTRIBUTE9 ATTRIBUTE9
, PTH.ATTRIBUTE10 ATTRIBUTE10
, PTH.ATTRIBUTE11 ATTRIBUTE11
, PTH.ATTRIBUTE12 ATTRIBUTE12
, PTH.ATTRIBUTE13 ATTRIBUTE13
, PTH.ATTRIBUTE14 ATTRIBUTE14
, PTH.ATTRIBUTE15 ATTRIBUTE15
, PTH.LOCATION_ID LOCATION_ID
, PTH.SCHEDULE_DAY SCHEDULE_DAY
, PTH.CUST_SHIP_SITE_ID CUST_SHIP_SITE_ID
, PTH.AP_AR_TERM_ID AP_AR_TERM_ID
, PTH.CUST_TRX_TYPE_ID CUST_TRX_TYPE_ID
, PTH.PROJECT_ID PROJECT_ID
, PTH.TASK_ID TASK_ID
, PTH.ORGANIZATION_ID ORGANIZATION_ID
, PTH.EXPENDITURE_TYPE EXPENDITURE_TYPE
, PTH.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PTH.TAX_GROUP_ID TAX_GROUP_ID
, PTH.TAX_CODE_ID TAX_CODE_ID
, PTH.TAX_INCLUDED TAX_INCLUDED
, PTH.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, PTH.INV_RULE_ID INV_RULE_ID
, PTH.ACCOUNT_RULE_ID ACCOUNT_RULE_ID
, PTH.SALESREP_ID SALESREP_ID
, PTH.APPROVED_BY APPROVED_BY
, PTH.STATUS STATUS
, PTH.INDEX_PERIOD_ID INDEX_PERIOD_ID
, PTH.INDEX_TERM_INDICATOR INDEX_TERM_INDICATOR
, PTH.PO_HEADER_ID PO_HEADER_ID
, PTH.CUST_PO_NUMBER CUST_PO_NUMBER
, PTH.RECEIPT_METHOD_ID RECEIPT_METHOD_ID
, PTH.VAR_RENT_INV_ID VAR_RENT_INV_ID
, PTH.VAR_RENT_TYPE VAR_RENT_TYPE
, PTH.CHANGED_FLAG CHANGED_FLAG
, PTH.RECOVERABLE_FLAG RECOVERABLE_FLAG
, PTH.PERIOD_BILLREC_ID PERIOD_BILLREC_ID
, PTH.REC_AGR_LINE_ID REC_AGR_LINE_ID
, PTH.AMOUNT_TYPE AMOUNT_TYPE
, PTH.NORM_START_DATE NORM_START_DATE
, PTH.PROJECT_ATTRIBUTE_CATEGORY INTERFACE_LINE_CONTEXT
, PTH.PROJECT_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1
, PTH.PROJECT_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, PTH.PROJECT_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3
, PTH.PROJECT_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4
, PTH.PROJECT_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5
, PTH.PROJECT_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6
, PTH.PROJECT_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7
, PTH.PROJECT_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8
, PTH.PROJECT_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9
, PTH.PROJECT_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10
, PTH.PROJECT_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11
, PTH.PROJECT_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12
, PTH.PROJECT_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13
, PTH.PROJECT_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14
, PTH.PROJECT_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15
, PTH.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, PPLOOK.MEANING PAYMENT_PURPOSE
, PTLOOK.MEANING PAYMENT_TERM_TYPE
, PFLOOK.MEANING FREQUENCY_TYPE
, POV.VENDOR_NAME VENDOR_NAME
, POV.SEGMENT1 VENDOR_NUMBER
, POVS.VENDOR_SITE_CODE VENDOR_SITE
, NULL AS TAX_FLAG
, HZP.PARTY_NAME CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCSU_BILL.LOCATION CUSTOMER_SITE_USE
, HCSU_SHIP.LOCATION CUST_SHIP_SITE_USE
, PNP_UTIL_FUNC.GET_TOTAL_PAYMENT_TERM_AMT(PTH.PAYMENT_TERM_ID) TOTAL_PAYMENT
, PNP_UTIL_FUNC.GET_TOTAL_LEASED_AREA(PTH.LEASE_ID
, PTH.START_DATE) LEASED_AREA
, PTH.AREA_TYPE_CODE AREA_TYPE_CODE
, PTH.AREA AREA
, PTH.GROUPING_RULE_ID GROUPING_RULE_ID
, PPGR.NAME INV_GROUP_NAME
, PTEMP.NAME TERM_TEMPLATE
, PTH.TERM_COMMENTS TERM_COMMENTS
, PTH.TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, PCLOOK.MEANING TCC_PAYMENT
, PCLOOK.MEANING TCC_BILLING
FROM HZ_CUST_SITE_USES_ALL HCSU_BILL
, HZ_CUST_SITE_USES_ALL HCSU_SHIP
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HCA
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, FND_LOOKUPS PFLOOK
, FND_LOOKUPS PTLOOK
, FND_LOOKUPS PPLOOK
, FND_LOOKUPS PCLOOK
, PN_PAY_GROUP_RULES PPGR
, PN_PAYMENT_TERMS_HISTORY PTH
, PN_TERM_TEMPLATES_ALL PTEMP
, PN_LEASES_ALL PLEASES
WHERE PTH.LEASE_ID = PLEASES.LEASE_ID
AND PLEASES.LEASE_CLASS_CODE IN ('THIRD_PARTY'
, 'SUB_LEASE'
, 'REC')
AND PCLOOK.LOOKUP_TYPE(+) = 'ZX_OUTPUT_CLASSIFICATIONS'
AND PCLOOK.LOOKUP_CODE(+) = PTH.TAX_CLASSIFICATION_CODE
AND PPLOOK.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND PPLOOK.LOOKUP_CODE = PTH.PAYMENT_PURPOSE_CODE
AND PTLOOK.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND PTLOOK.LOOKUP_CODE = PTH.PAYMENT_TERM_TYPE_CODE
AND PFLOOK.LOOKUP_TYPE = 'PN_PAYMENT_FREQUENCY_TYPE'
AND PFLOOK.LOOKUP_CODE = PTH.FREQUENCY_CODE
AND POV.VENDOR_ID (+)= PTH.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+)= PTH.VENDOR_SITE_ID
AND HCA.CUST_ACCOUNT_ID (+)= PTH.CUSTOMER_ID
AND HZP.PARTY_ID (+)= HCA.PARTY_ID
AND HCSU_BILL.SITE_USE_ID (+)= PTH.CUSTOMER_SITE_USE_ID
AND HCSU_SHIP.SITE_USE_ID (+)= PTH.CUST_SHIP_SITE_ID
AND PPGR.GROUPING_RULE_ID (+)= PTH.GROUPING_RULE_ID
AND PTH.TERM_TEMPLATE_ID = PTEMP.TERM_TEMPLATE_ID(+)

Columns