Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

field not found on sub view

RobeenAug 5 2021

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

This post has been answered by Frank Kulash on Aug 5 2021
Jump to Answer
Comments
Post Details
Added on Aug 5 2021
15 comments
471 views