VIEW: APPS.PN_VAR_LINE_DEFAULTS_V

Source

View Text - Preformatted

SELECT def.ROWID ROW_ID, def.LINE_DEFAULT_ID, def.LINE_NUM, def.VAR_RENT_ID, def.SALES_TYPE_CODE, def.ITEM_CATEGORY_CODE, def.LINE_TEMPLATE_ID, def.AGREEMENT_TEMPLATE_ID, tmp.AGREEMENT_TEMPLATE, def.LINE_START_DATE, def.LINE_END_DATE, def.PROCESSED_FLAG, def.LAST_UPDATE_DATE, def.LAST_UPDATED_BY, def.CREATION_DATE, def.CREATED_BY, def.LAST_UPDATE_LOGIN, def.ORG_ID, fls.meaning SALES_CHANNEL, fli.meaning ITEM_CATEGORY, def.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, def.ATTRIBUTE1 ATTRIBUTE1, def.ATTRIBUTE2 ATTRIBUTE2, def.ATTRIBUTE3 ATTRIBUTE3, def.ATTRIBUTE4 ATTRIBUTE4, def.ATTRIBUTE5 ATTRIBUTE5, def.ATTRIBUTE6 ATTRIBUTE6, def.ATTRIBUTE7 ATTRIBUTE7, def.ATTRIBUTE8 ATTRIBUTE8, def.ATTRIBUTE9 ATTRIBUTE9, def.ATTRIBUTE10 ATTRIBUTE10, def.ATTRIBUTE11 ATTRIBUTE11, def.ATTRIBUTE12 ATTRIBUTE12, def.ATTRIBUTE13 ATTRIBUTE13, def.ATTRIBUTE14 ATTRIBUTE14, def.ATTRIBUTE15 ATTRIBUTE15 FROM PN_VAR_LINE_DEFAULTS def, fnd_lookups fls, fnd_lookups fli, pn_var_templates_ALL tmp WHERE fls.LOOKUP_CODE(+) = def.SALES_TYPE_CODE AND fls.LOOKUP_TYPE(+) = 'PN_SALES_CHANNEL' AND fli.LOOKUP_CODE(+) = def.ITEM_CATEGORY_CODE AND fli.LOOKUP_TYPE(+) = 'PN_ITEM_CATEGORY' AND tmp.agreement_template_id(+) = def.agreement_template_id

View Text - HTML Formatted

SELECT DEF.ROWID ROW_ID
, DEF.LINE_DEFAULT_ID
, DEF.LINE_NUM
, DEF.VAR_RENT_ID
, DEF.SALES_TYPE_CODE
, DEF.ITEM_CATEGORY_CODE
, DEF.LINE_TEMPLATE_ID
, DEF.AGREEMENT_TEMPLATE_ID
, TMP.AGREEMENT_TEMPLATE
, DEF.LINE_START_DATE
, DEF.LINE_END_DATE
, DEF.PROCESSED_FLAG
, DEF.LAST_UPDATE_DATE
, DEF.LAST_UPDATED_BY
, DEF.CREATION_DATE
, DEF.CREATED_BY
, DEF.LAST_UPDATE_LOGIN
, DEF.ORG_ID
, FLS.MEANING SALES_CHANNEL
, FLI.MEANING ITEM_CATEGORY
, DEF.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DEF.ATTRIBUTE1 ATTRIBUTE1
, DEF.ATTRIBUTE2 ATTRIBUTE2
, DEF.ATTRIBUTE3 ATTRIBUTE3
, DEF.ATTRIBUTE4 ATTRIBUTE4
, DEF.ATTRIBUTE5 ATTRIBUTE5
, DEF.ATTRIBUTE6 ATTRIBUTE6
, DEF.ATTRIBUTE7 ATTRIBUTE7
, DEF.ATTRIBUTE8 ATTRIBUTE8
, DEF.ATTRIBUTE9 ATTRIBUTE9
, DEF.ATTRIBUTE10 ATTRIBUTE10
, DEF.ATTRIBUTE11 ATTRIBUTE11
, DEF.ATTRIBUTE12 ATTRIBUTE12
, DEF.ATTRIBUTE13 ATTRIBUTE13
, DEF.ATTRIBUTE14 ATTRIBUTE14
, DEF.ATTRIBUTE15 ATTRIBUTE15
FROM PN_VAR_LINE_DEFAULTS DEF
, FND_LOOKUPS FLS
, FND_LOOKUPS FLI
, PN_VAR_TEMPLATES_ALL TMP
WHERE FLS.LOOKUP_CODE(+) = DEF.SALES_TYPE_CODE
AND FLS.LOOKUP_TYPE(+) = 'PN_SALES_CHANNEL'
AND FLI.LOOKUP_CODE(+) = DEF.ITEM_CATEGORY_CODE
AND FLI.LOOKUP_TYPE(+) = 'PN_ITEM_CATEGORY'
AND TMP.AGREEMENT_TEMPLATE_ID(+) = DEF.AGREEMENT_TEMPLATE_ID