I want to insert few columns only into my view: my columns are COMPANY_SHORT_NAME
- IC_SHORT_NAME
- CURRENCY
- AMOUNT_LIMIT
- TDS
- DAY_COUNT_BASIS
- START_DATE
- END_DATE
- DESCRIPTION
- AGREEMENT_NAME
- APPROVAL_STATUS
- APRROVER
And Code of my view is :- ---------------------------------------------------
CREATE OR REPLACE FORCE EDITIONABLE VIEW "WNS_XTR_LOAN_AGREEMENT_V" ("ROW_ID", "AGREEMENT_ID", "AGREEMENT_NAME", "COMPANY_CODE", "COMPANY_SHORT_NAME", "INTERCOMPANY_CODE", "IC_SHORT_NAME", "CURRENCY", "AMOUNT_LIMIT", "TDS", "DAY_COUNT_BASIS", "START_DATE", "END_DATE", "APPROVAL_STATUS", "APPROVED_BY", "APRROVER", "ATTRIBUTE1", "ATTRIBUTE2", "ATTRIBUTE3", "ATTRIBUTE4", "ATTRIBUTE5", "ATTRIBUTE6", "ATTRIBUTE7", "ATTRIBUTE8", "ATTRIBUTE9", "ATTRIBUTE10", "ATTRIBUTE11", "ATTRIBUTE12", "ATTRIBUTE13", "ATTRIBUTE14", "ATTRIBUTE15", "CREATION_DATE", "CREATED_BY", "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "LAST_UPDATE_LOGIN", "DESCRIPTION") AS
SELECT wxla.ROWID row_id,
wxla.agreement_id,
wxla.agreement_name,
wxla.company_code,
wxpi1.short_name company_short_name,
wxla.intercompany_code,
wxpi2.short_name ic_short_name,
wxla.currency,
wxla.amount_limit,
wxla.tds,
wxla.day_count_basis,
wxla.start_date,
wxla.end_date,
wxla.approval_status,
wxla.approved_by,
(SELECT fu.description
FROM fnd_user fu
WHERE fu.user_id = wxla.approved_by)
AS aprrover,
wxla.attribute1,
wxla.attribute2,
wxla.attribute3,
wxla.attribute4,
wxla.attribute5,
wxla.attribute6,
wxla.attribute7,
wxla.attribute8,
wxla.attribute9,
wxla.attribute10,
wxla.attribute11,
wxla.attribute12,
wxla.attribute13,
wxla.attribute14,
wxla.attribute15,
wxla.creation_date,
wxla.created_by,
wxla.last_update_date,
wxla.last_updated_by,
wxla.last_update_login,
wxla.description
FROM wns_xtr_loan_agreement wxla,
wns_xtr_party_info_b55 wxpi1,
wns_xtr_party_info_b55 wxpi2
WHERE wxla.company_code = wxpi1.party_code
AND wxla.intercompany_code = wxpi2.party_code
ORDER BY wxpi1.short_name,
wxpi2.short_name,
wxla.currency,
wxla.start_date DESC;
--
What is the best way to achive this