My view script:
CREATE OR REPLACE FORCE EDITIONABLE VIEW "WNS_XTR_PARTY_INFO_VW4" ("ACCOUNT_MANAGER", "ACCOUNT_STATUS", "ADDRESS_1", "ADDRESS_2", "ADDRESS_3", "ADDRESS_4", "ADDRESS_5", "ADDRESS_6", "ADVISOR_YN", "AUDIT_INDICATOR", "AUTHORISED", "BRANCH_SUBSIDIARY_CODE", "BRANCH_SUBSIDIARY_YN", "BROKER", "BROKERAGE_CATEGORY", "CLIENT_ADVICE", "CLIENT_AGENT1", "CLIENT_AGENT2", "CLIENT_AGENT3", "CLIENT_GROUPING", "CLIENT_YN", "COMMENTS", "CONFO_ACTION_CODE", "CONFO_GROUP_CODE", "CONTACT_NAME", "COUNTRY_CODE", "CROSS_REF_TO_OTHER_PARTY", "CROSS_REF_NAME", "DEFAULT_ADDRESS_DETAILS", "DEFAULT_COMPANY", "DEPOSIT_REF", "EMAIL_ADDRESS", "FAX_NUMBER", "FULL_NAME", "FX_MATCH_ID", "INTERNAL_PTY", "PAGER_NUMBER", "PARTY_CATEGORY", "PARTY_CODE", "PARTY_GROUP", "PARTY_TYPE", "PHONE_NUMBER", "PI_CONSTANT", "P_ADDRESS_1", "P_ADDRESS_2", "P_ADDRESS_3", "P_ADDRESS_4", "RISK_PARTY", "SETTLEMENT_DEFAULT_CATEGORY", "SHORT_NAME", "STATE_CODE", "SWIFT_ID", "TAX_CATEGORY", "TAX_EXEMPTION_CODE", "TAX_NUMBER", "TITLE_DESCRIPTION", "VALUER_YN", "FX_CPARTY", "MM_CPARTY", "LEGAL_ENTITY_ID", "SUSPENSE_CCID", "CONVERSION_TYPE", "SET_OF_BOOKS_ID", "CHART_OF_ACCOUNTS_ID", "EM_CPARTY", "CE_BANK_BRANCH_ID", "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", "ATTRIBUTE_CATEGORY") AS
SELECT
xpi.ACCOUNT_MANAGER,
--ud.DEALER_NAME AS ACCOUNT_MANAGER_NAME,
xpi.ACCOUNT_STATUS,
xpi.ADDRESS_1,
xpi.ADDRESS_2,
xpi.ADDRESS_3,
xpi.ADDRESS_4,
xpi.ADDRESS_5,
xpi.ADDRESS_6,
xpi.ADVISOR_YN,
xpi.AUDIT_INDICATOR,
xpi.AUTHORISED,
xpi.BRANCH_SUBSIDIARY_CODE,
xpi.BRANCH_SUBSIDIARY_YN,
xpi.BROKER,
xpi.BROKERAGE_CATEGORY,
xpi.CLIENT_ADVICE,
xpi.CLIENT_AGENT1,
xpi.CLIENT_AGENT2,
xpi.CLIENT_AGENT3,
xpi.CLIENT_GROUPING,
xpi.CLIENT_YN,
xpi.COMMENTS,
xpi.CONFO_ACTION_CODE,
xpi.CONFO_GROUP_CODE,
xpi.CONTACT_NAME,
--t.TERRITORY_SHORT_NAME,
xpi.COUNTRY_CODE,
xpi.CROSS_REF_TO_OTHER_PARTY,
xpi.SHORT_NAME ,
xpi.DEFAULT_ADDRESS_DETAILS,
xpi.DEFAULT_COMPANY,
xpi.DEPOSIT_REF,
xpi.EMAIL_ADDRESS,
xpi.FAX_NUMBER,
xpi.FULL_NAME,
xpi.FX_MATCH_ID,
xpi.INTERNAL_PTY,
xpi.PAGER_NUMBER,
xpi.PARTY_CATEGORY,
xpi.PARTY_CODE,
xpi.PARTY_GROUP,
xpi.PARTY_TYPE,
xpi.PHONE_NUMBER,
xpi.PI_CONSTANT,
xpi.P_ADDRESS_1,
xpi.P_ADDRESS_2,
xpi.P_ADDRESS_3,
xpi.P_ADDRESS_4,
xpi.RISK_PARTY,
xpi.SETTLEMENT_DEFAULT_CATEGORY,
xpi.SHORT_NAME,
xpi.STATE_CODE,
xpi.SWIFT_ID,
xpi.TAX_CATEGORY,
xpi.TAX_EXEMPTION_CODE,
xpi.TAX_NUMBER,
xpi.TITLE_DESCRIPTION,
xpi.VALUER_YN,
xpi.FX_CPARTY,
xpi.MM_CPARTY,
xpi.LEGAL_ENTITY_ID,
xpi.SUSPENSE_CCID,
xpi.CONVERSION_TYPE,
xpi.SET_OF_BOOKS_ID,
xpi.CHART_OF_ACCOUNTS_ID,
xpi.EM_CPARTY,
xpi.CE_BANK_BRANCH_ID,
xpi.ATTRIBUTE1,
xpi.ATTRIBUTE2,
xpi.ATTRIBUTE3,
xpi.ATTRIBUTE4,
xpi.ATTRIBUTE5,
xpi.ATTRIBUTE6,
xpi.ATTRIBUTE7,
xpi.ATTRIBUTE8,
xpi.ATTRIBUTE9,
xpi.ATTRIBUTE10,
xpi.ATTRIBUTE11,
xpi.ATTRIBUTE12,
xpi.ATTRIBUTE13,
xpi.ATTRIBUTE14,
xpi.ATTRIBUTE15,
xpi.CREATION_DATE,
xpi.CREATED_BY,
xpi.LAST_UPDATE_DATE,
xpi.LAST_UPDATED_BY,
xpi.LAST_UPDATE_LOGIN,
xpi.ATTRIBUTE_CATEGORY
FROM
WNS_XTR_PARTY_INFO_B xpi
LEFT JOIN
fnd_territories_tl t ON xpi.COUNTRY_CODE = t.territory_code
LEFT JOIN
fnd_territories b ON t.language = userenv('LANG') AND b.territory_code = t.territory_code
LEFT JOIN
WNS_XTR_USER_DETAILS ud ON xpi.ACCOUNT_MANAGER = ud.DEALER_CODE;
My Insert Statement in create button:
BEGIN
INSERT INTO WNS_XTR_PARTY_INFO_VW4
(
ACCOUNT_MANAGER,
COMMENTS,
CONTACT\_NAME,
COUNTRY\_CODE,
DEPOSIT\_REF,
EMAIL\_ADDRESS,
FAX\_NUMBER,
FULL\_NAME,
PARTY\_CODE,
PARTY\_GROUP,
PHONE\_NUMBER,
SHORT\_NAME,
SWIFT\_ID,
FX\_CPARTY,
MM\_CPARTY,
EM\_CPARTY
)
VALUES
(
:P7_ACCOUNT_MANAGER,
:P7\_COMMENTS,
:P7\_CONTACT\_NAME,
:P7\_COUNTRY\_CODE,
:P7\_DEPOSIT\_REF,
:P7\_EMAIL\_ADDRESS,
:P7\_FAX\_NUMBER,
:P7\_FULL\_NAME,
:P7\_PARTY\_CODE,
:P7\_PARTY\_GROUP,
:P7\_PHONE\_NUMBER,
:P7\_SHORT\_NAME,
:P7\_SWIFT\_ID,
:P7\_FX\_CPARTY,
:P7\_MM\_CPARTY,
:P7\_EM\_CPARTY
);
END;
----------------------------------
