VIEW: APPS.PN_VAR_TEMPLATES_V

Source

View Text - Preformatted

SELECT temp.rowid row_id, temp.AGREEMENT_TEMPLATE_ID agreement_template_id, temp.agreement_template agreement_template, temp.LAST_UPDATE_DATE last_update_date, temp.LAST_UPDATED_BY last_updated_by, temp.CREATION_DATE creation_date, temp.CREATED_BY created_by, temp.LAST_UPDATE_LOGIN last_update_login, temp.PURPOSE_CODE purpose_code, fnd1.meaning purpose, temp.TYPE_CODE type_code, fnd2.meaning type, temp.CUMULATIVE_VOL cumulative_vol, temp.INVOICE_ON invoice_on, temp.NEGATIVE_RENT negative_rent, temp.TERM_TEMPLATE_ID term_template_id, temp.ABATEMENT_AMOUNT abatement_amount, temp.PRORATION_RULE proration_rule, temp.PERIOD_FREQ_CODE period_freq_code, temp.USE_GL_CALENDAR use_gl_calendar, temp.YEAR_START_DATE year_start_date, temp.GL_PERIOD_SET_NAME gl_period_set_name, temp.PERIOD_TYPE period_type, temp.REPTG_FREQ_CODE reptg_freq_code, temp.REPTG_DAY_OF_MONTH reptg_day_of_month, temp.REPTG_DAYS_AFTER reptg_days_after, temp.INVG_FREQ_CODE invg_freq_code, temp.INVG_SPREAD_CODE invg_spread_code, temp.INVG_DAY_OF_MONTH invg_day_of_month, temp.INVG_DAYS_AFTER invg_days_after, temp.COMMENTS comments, temp.ORG_ID org_id, temp.VRG_REPTG_FREQ_CODE vrg_reptg_freq_code, temp.ATTRIBUTE1 attribute1, temp.ATTRIBUTE2 attribute2, temp.ATTRIBUTE3 attribute3, temp.ATTRIBUTE4 attribute4, temp.ATTRIBUTE5 attribute5, temp.ATTRIBUTE6 attribute6, temp.ATTRIBUTE7 attribute7, temp.ATTRIBUTE8 attribute8, temp.ATTRIBUTE9 attribute9, temp.ATTRIBUTE10 attribute10, temp.ATTRIBUTE11 attribute11, temp.ATTRIBUTE12 attribute12, temp.ATTRIBUTE13 attribute13, temp.ATTRIBUTE14 attribute14, temp.ATTRIBUTE15 attribute15, temp.ATTRIBUTE_CATEGORY attribute_category FROM pn_var_templates temp ,fnd_lookups fnd1 ,fnd_lookups fnd2 WHERE fnd1.lookup_type(+) = 'PN_PAYMENT_PURPOSE_TYPE' AND fnd1.lookup_code(+) = temp.purpose_code AND fnd2.lookup_type(+) = 'PN_PAYMENT_TERM_TYPE' AND fnd2.lookup_code(+) = temp.type_code

View Text - HTML Formatted

SELECT TEMP.ROWID ROW_ID
, TEMP.AGREEMENT_TEMPLATE_ID AGREEMENT_TEMPLATE_ID
, TEMP.AGREEMENT_TEMPLATE AGREEMENT_TEMPLATE
, TEMP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TEMP.LAST_UPDATED_BY LAST_UPDATED_BY
, TEMP.CREATION_DATE CREATION_DATE
, TEMP.CREATED_BY CREATED_BY
, TEMP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TEMP.PURPOSE_CODE PURPOSE_CODE
, FND1.MEANING PURPOSE
, TEMP.TYPE_CODE TYPE_CODE
, FND2.MEANING TYPE
, TEMP.CUMULATIVE_VOL CUMULATIVE_VOL
, TEMP.INVOICE_ON INVOICE_ON
, TEMP.NEGATIVE_RENT NEGATIVE_RENT
, TEMP.TERM_TEMPLATE_ID TERM_TEMPLATE_ID
, TEMP.ABATEMENT_AMOUNT ABATEMENT_AMOUNT
, TEMP.PRORATION_RULE PRORATION_RULE
, TEMP.PERIOD_FREQ_CODE PERIOD_FREQ_CODE
, TEMP.USE_GL_CALENDAR USE_GL_CALENDAR
, TEMP.YEAR_START_DATE YEAR_START_DATE
, TEMP.GL_PERIOD_SET_NAME GL_PERIOD_SET_NAME
, TEMP.PERIOD_TYPE PERIOD_TYPE
, TEMP.REPTG_FREQ_CODE REPTG_FREQ_CODE
, TEMP.REPTG_DAY_OF_MONTH REPTG_DAY_OF_MONTH
, TEMP.REPTG_DAYS_AFTER REPTG_DAYS_AFTER
, TEMP.INVG_FREQ_CODE INVG_FREQ_CODE
, TEMP.INVG_SPREAD_CODE INVG_SPREAD_CODE
, TEMP.INVG_DAY_OF_MONTH INVG_DAY_OF_MONTH
, TEMP.INVG_DAYS_AFTER INVG_DAYS_AFTER
, TEMP.COMMENTS COMMENTS
, TEMP.ORG_ID ORG_ID
, TEMP.VRG_REPTG_FREQ_CODE VRG_REPTG_FREQ_CODE
, TEMP.ATTRIBUTE1 ATTRIBUTE1
, TEMP.ATTRIBUTE2 ATTRIBUTE2
, TEMP.ATTRIBUTE3 ATTRIBUTE3
, TEMP.ATTRIBUTE4 ATTRIBUTE4
, TEMP.ATTRIBUTE5 ATTRIBUTE5
, TEMP.ATTRIBUTE6 ATTRIBUTE6
, TEMP.ATTRIBUTE7 ATTRIBUTE7
, TEMP.ATTRIBUTE8 ATTRIBUTE8
, TEMP.ATTRIBUTE9 ATTRIBUTE9
, TEMP.ATTRIBUTE10 ATTRIBUTE10
, TEMP.ATTRIBUTE11 ATTRIBUTE11
, TEMP.ATTRIBUTE12 ATTRIBUTE12
, TEMP.ATTRIBUTE13 ATTRIBUTE13
, TEMP.ATTRIBUTE14 ATTRIBUTE14
, TEMP.ATTRIBUTE15 ATTRIBUTE15
, TEMP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
FROM PN_VAR_TEMPLATES TEMP
, FND_LOOKUPS FND1
, FND_LOOKUPS FND2
WHERE FND1.LOOKUP_TYPE(+) = 'PN_PAYMENT_PURPOSE_TYPE'
AND FND1.LOOKUP_CODE(+) = TEMP.PURPOSE_CODE
AND FND2.LOOKUP_TYPE(+) = 'PN_PAYMENT_TERM_TYPE'
AND FND2.LOOKUP_CODE(+) = TEMP.TYPE_CODE