ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F11D3869E053B46B63588994 SELECT XR.registered_name LEGAL_ENTITY_NAME ,XR.registration_number TAX_PAYER_ID ,FT.territory_short_name LE_COUNTRY ,HL.address_line_1 ADDRESS_LINE_1 ,HL.address_line_2 ADDRESS_LINE_2 ,HL.address_line_3 ADDRESS_LINE_3 ,HL.town_or_city TOWN_OR_CITY ,HL.postal_code POSTAL_CODE ,hp.party_id LE_PARTY_ID ,HL.region_1 REGION ,ZPTP.rep_registration_number VAT_REGISTRATION_NUMBER ,gll.currency_code CURRENCY_CODE FROM xle_registrations XR ,xle_entity_profiles XEP ,hr_locations_all HL ,hz_parties HP ,fnd_territories_vl FT ,ZX_PARTY_TAX_PROFILE ZPTP ,XLE_ETB_PROFILES XETPB ,GL_LEDGER_LE_V GLL WHERE XR.source_id = XEP.legal_entity_id AND XR.source_table = 'XLE_ENTITY_PROFILES' AND XEP.legal_entity_id = :P_LEGAL_ENTITY_ID AND XR.location_id = HL.location_id AND HL.country = FT.TERRITORY_CODE AND XEP.party_id = HP.party_id AND ZPTP.PARTY_TYPE_CODE = 'LEGAL_ESTABLISHMENT' AND XETPB.party_id=ZPTP.party_id AND XETPB.legal_entity_id = XEP.legal_entity_id AND GLL.legal_entity_id=XEP.legal_entity_id AND XETPB.MAIN_ESTABLISHMENT_FLAG = 'Y' AND XR.identifying_flag = 'Y' AND GLL.ledger_category_code = 'PRIMARY' Y JE JEITWHYL_XMLP AR JE تقرير الاستقطاع السنوي في إيطاليا Application: المحليات الأوروبية Source: تقرير الاستقطاع السنوي في إيطاليا Short Name: JEITWHYL_XMLP DB package: JE_ITWHYE_AP_PKG D JE Jährliche Steuereinbehaltung Application: Europäische Lokalisierungen Source: Italien: Jährliche Steuereinbehaltung Short Name: JEITWHYL_XMLP DB package: JE_ITWHYE_AP_PKG F JE Italie - Etat annuel des retenues fiscales Application: European Localizations Source: Italie - Etat annuel des retenues fiscales Short Name: JEITWHYL_XMLP DB package: JE_ITWHYE_AP_PKG US JE Italian Withholding Yearly Application: European Localizations Source: Italian Withholding Yearly Report Short Name: JEITWHYL_XMLP DB package: JE_ITWHYE_AP_PKG BI Publisher :cp_comm_num :cp_dummy_taxid :cp_precision :cp_set_of_books_id :cp_year_end_date :cp_year_start_date :errcode :g_inps :g_irpef :g_num_request_id :ln_amount_etrd :p_conc_request_id :p_legal_entity_id :p_org_id 1 10 :p_legal_entity_id LOV Oracle JE_ITWHYE_FIRSTPARTY Y select legal_entity_id id, name value, legal_entity_identifier description from xle_entity_profiles where transacting_entity_flag='Y' and legal_entity_id in( select nvl(hrou.default_legal_context_id, hrou.organization_id) from hr_operating_units hrou, per_security_profiles persp where hrou.business_group_id=persp.business_group_id and persp.security_profile_id= fnd_profile.value('PER_SECURITY_PROFILE_ID')) order by value,description Y AR الكيان القانوني D Mandant F Entité juridique US Legal Entity 2 20 :p_year Number Y AR السنة D Jahr F Année US Year 3 30 :p_order_by LOV Oracle JE_ITWHYE_ORDER_BY Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JE_ITWHYE_ORDER_BY' order by value,description Y AR ترتيب بواسطة D Sortieren nach F Tri par US Order By