VIEW: APPS.PN_INDEX_EXCLUDE_TERM_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'