Oracle DB 12.1.0.2
Hello Team,
trust you are fine.
the query below
SELECT CEBank.Bank_Party_Id Bank_Party_Id, CEBank.HOME_COUNTRY Home_Country, CEBank.BANK_NAME Bank_Name, CEBank.Bank_Number Bank_Number,
CEBank.Bank_Institution_Type Bank_Institution_Type, CEBank.Bank_Name_Alt Bank_Name_Alt, CEBank.short_bank_name Short_Bank_Name,
CEBank.description Description, CEBank.end_date End_Date, CEBank.ADDRESS_line1 Address1, CEBank.ADDRESS_line2 Address2,
CEBank.ADDRESS_line3 Address3, CEBank.City City, CEBank.State State, CEBank.zip Zipcode, CEBank.country Country, 1 CREATED_BY,
sysdate CREATION_DATE, 1 LAST_UPDATED_BY, sysdate LAST_UPDATE_DATE, 1 LAST_UPDATE_LOGIN, 1 OBJECT_VERSION_NUMBER, 'Y' Operation_Flag,
SITE_LOCATION_ID SITE_LOCATION_ID, CEBANK.TAX_PAYER_ID TAX_PAYER_ID
from ce_banks_v cebank;
will select the fields in the SELECT statement from ce_banks_v. I noticed the fields SITE_LOCATION_ID SITE_LOCATION_ID, CEBANK.TAX_PAYER_ID TAX_PAYER_ID are not present in view 'ce_banks_v' but still I am able to view the data.
ce_banks_v DDL
SELECT BankParty.ROWID ROW_ID, BankOrgProfile.HOME_COUNTRY Home_Country, BankParty.PARTY_ID Bank_Party_Id, BankParty.PARTY_NAME Bank_Name, BankParty.ORGANIZATION_NAME_PHONETIC Bank_Name_Alt, BankParty.KNOWN_AS Short_Bank_Name, BankOrgProfile.BANK_OR_BRANCH_NUMBER Bank_Number, BankCA.start_date_active Start_Date, BankCA.end_date_active End_Date, BankParty.address1 Address_Line1, BankParty.address2 Address_Line2, BankParty.address3 Address_Line3, BankParty.address4 Address_Line4, BankParty.city City, BankParty.state State, BankParty.province Province, BankParty.postal_code Zip, BankParty.country Country, BankCA.class_code Bank_Institution_Type, BankParty.mission_statement Description, BankParty.PARTY_ID, HL.ADDRESS1, HL.ADDRESS2, HL.ADDRESS3, HL.ADDRESS4, HL.CITY, HL.STATE, HL.COUNTY, HL.POSTAL_CODE, HL.COUNTRY, HL.PROVINCE, HL.LOCATION_ID, BankParty.JGZZ_FISCAL_CODE
From HZ_PARTIES BankParty, HZ_ORGANIZATION_PROFILES BankOrgProfile, HZ_CODE_ASSIGNMENTS BankCA, HZ_PARTY_SITES PS, HZ_LOCATIONS HL
WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
And NVL(BankParty.status, 'A') = 'A'
And BankParty.PARTY_ID = BankOrgProfile.PARTY_ID And SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
And BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
And BankCA.CLASS_CODE in ('BANK', 'CLEARINGHOUSE')
And BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
And BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
And NVL(BankCA.STATUS, 'A') = 'A'
AND BankParty.PARTY_ID = PS.PARTY_ID (+)
AND PS.IDENTIFYING_ADDRESS_FLAG (+) = 'Y'
AND PS.LOCATION_ID = HL.LOCATION_ID (+)
Kindly advise.
Thanks