ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F16E3869E053B46B63588994 SELECT ap1.appraiser_name appraiser_name, substr(ap1.appraiser_address1,1,40) ||', '|| substr(ap1.appraiser_address2,1,40) ||', '|| substr(ap1.appraiser_city,1,20) address, ap1.appraisal_date appraisal_date, ap1.fiscal_year fiscal_year, ap1.currency_code currency_code, flh.meaning hdr_status, asp1.asset_number asset_number, adtl.description description, ad.tag_number tag_number, asp1.appraisal_value appraisal_value, fld.meaning status, JL_JLCOFAAR_XMLP_PKG.cf_1formula() CF_1 FROM jl_co_fa_appraisals ap1, jl_co_fa_asset_apprs asp1, fa_additions_b ad, fa_additions_tl adtl, fnd_lookups flh, fnd_lookups fld WHERE ad.asset_id = adtl.asset_id AND adtl.language = userenv('LANG') AND ap1.appraisal_id = :P_APPRAISAL_ID AND asp1.appraisal_id = ap1.appraisal_id AND asp1.asset_number = ad.asset_number(+) &C_STATUS AND flh.lookup_type = 'JLCO_FA_ASSET_APPRAISAL_STATUS' AND flh.lookup_code = ap1.appraisal_status AND fld.lookup_type = flh.lookup_type AND fld.lookup_code = asp1.status AND UPPER(fld.enabled_flag) = 'Y' AND SYSDATE BETWEEN NVL(fld.start_date_active,SYSDATE-1) AND NVL(fld.end_date_active,SYSDATE+1) UNION SELECT ap1.appraiser_name appraiser_name, substr(ap1.appraiser_address1,1,40) ||', '|| substr(ap1.appraiser_address2,1,40) ||', '|| substr(ap1.appraiser_city,1,20) address, ap1.appraisal_date appraisal_date, ap1.fiscal_year fiscal_year, ap1.currency_code currency_code, flh.meaning hdr_status, asp1.asset_number asset_number, null description, null tag_number, asp1.appraisal_value appraisal_value, fld.meaning status, JL_JLCOFAAR_XMLP_PKG.cf_1formula() CF_1 FROM jl_co_fa_appraisals ap1, jl_co_fa_asset_apprs asp1, fnd_lookups flh, fnd_lookups fld WHERE ap1.appraisal_id = :P_APPRAISAL_ID AND asp1.appraisal_id = ap1.appraisal_id AND NOT EXISTS (select ad.asset_number from fa_additions_b ad where ad.asset_number = asp1.asset_number) &C_STATUS AND flh.lookup_type = 'JLCO_FA_ASSET_APPRAISAL_STATUS' AND flh.lookup_code = ap1.appraisal_status AND fld.lookup_type = flh.lookup_type AND fld.lookup_code = asp1.status AND UPPER(fld.enabled_flag) = 'Y' AND SYSDATE BETWEEN NVL(fld.start_date_active,SYSDATE-1) AND NVL(fld.end_date_active,SYSDATE+1) UNION SELECT ap1.appraiser_name appraiser_name, substr(ap1.appraiser_address1,1,40) ||', '|| substr(ap1.appraiser_address2,1,40) ||', '|| substr(ap1.appraiser_city,1,20) address, ap1.appraisal_date appraisal_date, ap1.fiscal_year fiscal_year, ap1.currency_code currency_code, flh.meaning hdr_status, null asset_number, null description, null tag_number, 0 appraisal_value, null status, JL_JLCOFAAR_XMLP_PKG.cf_1formula() CF_1 FROM jl_co_fa_appraisals ap1, fnd_lookups flh WHERE ap1.appraisal_id = :P_APPRAISAL_ID AND ap1.appraisal_status = 'V' AND (:P_ALL_ROWS <> 'Y' AND :P_ALL_ROWS is not null) AND flh.lookup_type = 'JLCO_FA_ASSET_APPRAISAL_STATUS' AND flh.lookup_code = ap1.appraisal_status AND UPPER(flh.enabled_flag) = 'Y' AND SYSDATE BETWEEN NVL(flh.start_date_active,SYSDATE-1) AND NVL(flh.end_date_active,SYSDATE+1) ORDER BY asset_number Y JL JLCOFAAR_XML US JL Colombian Fixed Assets Technical Appraisal Additions - draft Application: Latin America Localizations Source: Colombian Fixed Assets Technical Appraisal Additions Report (XML) - Not Supported: Reserved For Future Use Short Name: JLCOFAAR_XML DB package: JL_JLCOFAAR_XMLP_PKG BI Publisher &c_status :c_company_name :c_status :cp_valid_curr_code :p_all_rows :p_appraisal_id :p_conc_request_id :p_end_of_report :p_min_precision :p_no_data_found 1 10 :p_appraisal_id LOV Oracle JLCO_FA_APPRAISALS Y select appraisal_id id, appraisal_id value, appraiser_name description from jl_co_fa_appraisals order by appraisal_id Y US Appraisal Number 2 20 :p_all_rows LOV Oracle GL_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' US All Rows