ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1603869E053B46B63588994 select A.NAME, A.ADDRESS_LINE_1, A.ADDRESS_LINE_2, A.ADDRESS_LINE_3, A.TOWN_OR_CITY , A.REGISTRATION_NUMBER, To_Char (fnd_conc_date.STRING_TO_DATE(A.EFFECTIVE_FROM), 'DD-MON-YY' ) EFFECTIVE_FROM , (select H.LOCATION_CODE from HR_LOCATIONS H where H.LOCATION_ID = A.LOCATION_ID ) LOCATION from XLE_FIRSTPARTY_INFORMATION_V A , GL_LEDGER_LE_V G where A.LEGAL_ENTITY_ID= :P_LEGAL_ENTITY_ID and A.LEGAL_ENTITY_ID = G.legal_entity_id and G.LEDGER_ID = :P_LEDGER_ID JL JLBRLOCP US JL Brazilian Opening and Closing Pages Application: Latin America Localizations Source: Brazilian Opening and Closing Pages Report Short Name: JLBRLOCP DB package: BI Publisher :operating_unit :p_ledger_id :p_legal_entity_id 1 10 :p_sob_id Number Y US JLBR_SRS_SET_OF_BOOKS 2 20 :p_company LOV Oracle JLBR_SRS_COMPANY Y select accounting_balancing_segment id, accounting_balancing_segment value, name description from jl_br_company_infos where set_of_books_id=:$flex$.jlbr_srs_set_of_books and nvl(inactive_date,sysdate+1)>sysdate order by value,description Y US Company 3 30 :p_daily_ledger_flag Char Y US Daily / Ledger Flag 4 40 :p_parent_request_id Number US Request Id :$flex$.jlbr_srs_set_of_books JLBR_SRS_SET_OF_BOOKS Company