SELECT organization_id legal_entity_id,
business_group_id,
name,
date_from,
date_to,
set_of_books_id,
vat_registration_number
FROM hr_legal_entities
WHERE set_of_books_id = 1
and business_group_id=202
business_group_id,
name,
date_from,
date_to,
set_of_books_id,
vat_registration_number
FROM hr_legal_entities
WHERE set_of_books_id = 1
and business_group_id=202
Regards
ReplyDeleteSridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.