Product: | PN - Property Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PN_INDEX_EXCLUDE_TERM_V |
SELECT INDEXL.INDEX_LEASE_ID
, TERMS.PAYMENT_TERM_ID
, DECODE(EXCLUDE.INDEX_EXCLUDE_TERM_ID
, NULL
, 'Y'
, 'N') EXCLUDE_FLAG
, TERMS.PAYMENT_PURPOSE
, TERMS.PAYMENT_TERM_TYPE
, TERMS.PAYMENT_TERM_TYPE_CODE
, TERMS.START_DATE
, TERMS.END_DATE
, TERMS.ACTUAL_AMOUNT
, TERMS.VENDOR_NUMBER
, TERMS.VENDOR_NAME
, TERMS.CUSTOMER_NUMBER
, TERMS.CUSTOMER_NAME
, EXCLUDE.LAST_UPDATE_DATE
, EXCLUDE.LAST_UPDATED_BY
, EXCLUDE.CREATION_DATE
, EXCLUDE.CREATED_BY
, EXCLUDE.LAST_UPDATE_LOGIN
, EXCLUDE.ORG_ID
FROM PN_INDEX_EXCLUDE_TERM EXCLUDE
, PN_PAYMENT_TERMS_V TERMS
, PN_INDEX_LEASES_ALL INDEXL
WHERE EXCLUDE.PAYMENT_TERM_ID(+) = TERMS.PAYMENT_TERM_ID AND TERMS.LEASE_ID = INDEXL.LEASE_ID AND DECODE(TERMS.INDEX_PERIOD_ID
, NULL
, 'APPROVED'
, TERMS.STATUS) = 'APPROVED'