View: PN_VAR_TERMS_V

Product:	PN - Property Manager
Description:	Form view used to view abatement details for an invoice.
Implementation/DBA Data:	APPS.PN_VAR_TERMS_V

View Text

SELECT VINV.INVOICE_DATE INVOICE_DATE
, VINV.VAR_RENT_INV_ID VAR_RENT_INV_ID
, VINV.VAR_RENT_ID VAR_RENT_ID
, VINV.PERIOD_ID PERIOD_ID
, PN_VAR_ABATEMENT_AMOUNT_PKG.GET_TERM_EXISTS(PTERM.PAYMENT_TERM_ID
, VINV.VAR_RENT_INV_ID) INCLUDE_TERM
, PTERM.ROWID ROW_ID
, PTERM.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PTERM.LEASE_ID LEASE_ID
, PTERM.START_DATE START_DATE
, PTERM.END_DATE END_DATE
, 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
, HZ.PARTY_NAME CUSTOMER_NAME
, HZ.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCSU.LOCATION CUSTOMER_SITE_USE
, PTERM.NORMALIZE NORMALIZE
, PTERM.ACTUAL_AMOUNT ACTUAL_AMOUNT
, PTERM.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, PTERM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTERM.LAST_UPDATED_BY LAST_UPDATED_BY
, PTERM.CREATION_DATE CREATION_DATE
, PTERM.CREATED_BY CREATED_BY
, PTERM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, VRENT.ORG_ID ORG_ID
, PTERM.CURRENCY_CODE CURRENCY_CODE
FROM (SELECT HP.PARTY_NAME
, HCA.CUST_ACCOUNT_ID
, HCA.ACCOUNT_NUMBER
FROM HZ_CUST_ACCOUNTS_ALL HCA
, HZ_PARTIES HP
WHERE HP.PARTY_ID = HCA.PARTY_ID) HZ
, HZ_CUST_SITE_USES_ALL HCSU
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, FND_LOOKUPS PFLOOK
, FND_LOOKUPS PTLOOK
, FND_LOOKUPS PPLOOK
, PN_PAYMENT_TERMS_ALL PTERM
, PN_VAR_RENTS VRENT
, PN_VAR_RENT_INV_ALL VINV
WHERE PPLOOK.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND PPLOOK.LOOKUP_CODE = PTERM.PAYMENT_PURPOSE_CODE
AND PTLOOK.LOOKUP_TYPE = 'PN_PAYMENT_TERM_TYPE'
AND PTLOOK.LOOKUP_CODE = PTERM.PAYMENT_TERM_TYPE_CODE
AND PFLOOK.LOOKUP_TYPE = 'PN_PAYMENT_FREQUENCY_TYPE'
AND PFLOOK.LOOKUP_CODE = PTERM.FREQUENCY_CODE
AND POV.VENDOR_ID (+) = PTERM.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+) = PTERM.VENDOR_SITE_ID
AND HZ.CUST_ACCOUNT_ID (+) = PTERM.CUSTOMER_ID
AND HCSU.SITE_USE_ID (+) = PTERM.CUSTOMER_SITE_USE_ID
AND VRENT.LEASE_ID = PTERM.LEASE_ID
AND VRENT.VAR_RENT_ID = VINV.VAR_RENT_ID
AND PTERM.START_DATE <=(SELECT MAX(GD.GRP_END_DATE)
FROM PN_VAR_GRP_DATES GD
WHERE GD.PERIOD_ID = VINV.PERIOD_ID
AND GD.INVOICE_DATE = VINV.INVOICE_DATE)
AND PTERM.END_DATE >=(SELECT MIN(GRP_START_DATE)
FROM PN_VAR_GRP_DATES GD1
WHERE GD1.PERIOD_ID = VINV.PERIOD_ID
AND GD1.INVOICE_DATE = VINV.INVOICE_DATE)
AND PTERM.VAR_RENT_INV_ID IS NULL
AND PTERM.INDEX_PERIOD_ID IS NULL
AND VINV.ADJUST_NUM = 0

Columns