ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4FDFF55867E9D262E0634000000A774F with xtb as (select /*+ parallel(xtb) leading(xtb) NO_MERGE */ xtb.definition_code tb_code, xtdv.name tb_name, nvl(xtb.applied_to_entity_id,xtb.source_entity_id) entity_id, xtb.code_combination_id, xtb.source_application_id, sum (nvl2(xtb.applied_to_entity_id,0,nvl(xtb.entered_unrounded_cr,0) - nvl(xtb.entered_unrounded_dr,0))) entered_unrounded_orig_amount, sum (nvl2(xtb.applied_to_entity_id,0,nvl(xtb.entered_rounded_cr,0) - nvl(xtb.entered_rounded_dr,0))) entered_rounded_orig_amount, sum (nvl2(xtb.applied_to_entity_id,0,nvl(xtb.acctd_unrounded_cr,0) - nvl(xtb.acctd_unrounded_dr,0))) acctd_unrounded_orig_amount, sum (nvl2(xtb.applied_to_entity_id,0,nvl(xtb.acctd_rounded_cr,0) - nvl(xtb.acctd_rounded_dr,0)) ) acctd_rounded_orig_amount, sum (nvl(xtb.entered_unrounded_cr,0)) - sum(nvl(xtb.entered_unrounded_dr,0)) entered_unrounded_rem_amount, sum (nvl(xtb.entered_rounded_cr,0)) - sum(nvl(xtb.entered_rounded_dr,0)) entered_rounded_rem_amount, sum (nvl(xtb.acctd_unrounded_cr,0)) - sum(nvl(xtb.acctd_unrounded_dr,0)) acctd_unrounded_rem_amount, sum (nvl(xtb.acctd_rounded_cr,0)) - sum(nvl(xtb.acctd_rounded_dr,0)) acctd_rounded_rem_amount, case when sum (nvl2(xtb.applied_to_entity_id,0,nvl(xtb.entered_rounded_cr,0) - nvl(xtb.entered_rounded_dr,0))) = 0 then 1 else sum (nvl2(xtb.applied_to_entity_id,0,nvl(xtb.acctd_rounded_cr,0) - nvl(xtb.acctd_rounded_dr,0)) ) / sum (nvl2(xtb.applied_to_entity_id,0,nvl(xtb.entered_rounded_cr,0) - nvl(xtb.entered_rounded_dr,0))) end conversion_rate, xtb.ledger_id, xtb.party_id, xtb.balancing_segment_value, xtb.natural_account_segment_value, xtb.cost_center_segment_value, xtb.intercompany_segment_value, xtb.management_segment_value, dte.as_of_date from xla_trial_balances xtb, xla_tb_definitions_vl xtdv, (select gl.ledger_id, to_date(:P_AS_OF_DATE,'YYYY/MM/DD HH24:MI:SS') as_of_date from gl_ledgers gl where :P_AS_OF_DATE is not null and ( (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N') or (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='Y' and exists (select 1 from gl_access_sets gas, gl_access_set_assignments asa where gas.access_set_id=asa.access_set_id and asa.ledger_id=gl.ledger_id and ( gas.access_set_id=nvl(fnd_profile.value('GL_ACCESS_SET_ID'),'-1') or gas.access_set_id=nvl(fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID'),'-1') ) ) ) ) union select x.ledger_id, x.end_date as_of_date from (select 1-rank() over (partition by gl.name order by ((glp.period_year * 100000) + glp.period_num) desc) relative_period, gl.ledger_id, glp.end_date from gl_ledgers gl ,gl_periods glp ,gl_periods glpc where :P_AS_OF_DATE is null and :P_RELATIVE_PERIOD is not null and ( (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N') or (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='Y' and exists (select 1 from gl_access_sets gas, gl_access_set_assignments asa where gas.access_set_id=asa.access_set_id and asa.ledger_id=gl.ledger_id and ( gas.access_set_id=nvl(fnd_profile.value('GL_ACCESS_SET_ID'),'-1') or gas.access_set_id=nvl(fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID'),'-1') ) ) ) ) and gl.period_set_name=glp.period_set_name and gl.accounted_period_type=glp.period_type and glp.adjustment_period_flag='N' and gl.period_set_name=glpc.period_set_name and gl.accounted_period_type=glpc.period_type and glpc.adjustment_period_flag='N' and trunc(sysdate) between glpc.start_date and glpc.end_date and glp.start_date <= glpc.start_date ) x where x.relative_period = to_number(:P_RELATIVE_PERIOD) ) dte where xtb.ledger_id = dte.ledger_id and xtb.definition_code = xtdv.definition_code and xtb.source_application_id=200 and xtb.gl_date between to_date('01/01/1950','DD/MM/YYYY') and dte.as_of_date and xtdv.enabled_flag='Y' group by xtb.definition_code, xtdv.name, nvl(xtb.applied_to_entity_id,xtb.source_entity_id), xtb.code_combination_id , xtb.source_application_id, xtb.ledger_id, xtb.party_id, xtb.balancing_segment_value, xtb.natural_account_segment_value, xtb.cost_center_segment_value, xtb.intercompany_segment_value, xtb.management_segment_value, dte.as_of_date having sum(nvl(xtb.acctd_rounded_cr,0)) <> sum (nvl(xtb.acctd_rounded_dr,0)) ), ap_inv as (select xtb.as_of_date as_of_date, xtb.tb_code, xtb.tb_name, xtb.ledger_id, gl.name ledger_name, gl.short_name ledger_short_name, gl.currency_code ledger_currency, haouv.name operating_unit, xtb.source_application_id, xtb.entity_id source_entity_id, xte.entity_code source_entity_code, xte.security_id_int_1 org_id, xte.transaction_number source_transaction_number, xetv.name source_trx_type, xtb.code_combination_id, xtb.entered_unrounded_orig_amount, xtb.entered_rounded_orig_amount, xtb.acctd_unrounded_orig_amount, xtb.acctd_rounded_orig_amount, xtb.entered_unrounded_rem_amount, xtb.entered_rounded_rem_amount, xtb.acctd_unrounded_rem_amount, xtb.acctd_rounded_rem_amount, xtb.balancing_segment_value, xtb.natural_account_segment_value, xtb.cost_center_segment_value, xtb.intercompany_segment_value, xtb.management_segment_value, xtb.entity_id applied_to_entity_id, xtb.party_id third_party_number, -- hp.party_name third_party_name, hp.party_id party_id, hps.party_site_name third_party_site_name, ftv2.territory_short_name third_party_site_country, asu.segment1 vendor_number, asu.vendor_name vendor_name, asu.vendor_id vendor_id, assa.vendor_site_code vendor_site, ftv1.territory_short_name vendor_site_country, aia.invoice_num invoice_number, aia.doc_sequence_value invoice_document_number, aia.invoice_date invoice_date, aia.gl_date invoice_gl_date, aia.cancelled_date invoice_cancelled_date, aia.source invoice_source, xxen_util.meaning(aia.invoice_type_lookup_code,'INVOICE TYPE',200) invoice_type, aia.description invoice_description, xxen_util.ap_invoice_status(aia.invoice_id,aia.invoice_amount,aia.payment_status_flag,aia.invoice_type_lookup_code,aia.validation_request_id) invoice_status, xxen_util.meaning(aia.payment_status_flag,'INVOICE PAYMENT STATUS',200) invoice_payment_status, xxen_util.meaning(aia.pay_group_lookup_code,'PAY GROUP',201) pay_group, (select ipmv.payment_method_name from iby_payment_methods_vl ipmv where ipmv.payment_method_code = aia.payment_method_code) payment_method, aia.dispute_reason dispute_reason, apsa.iby_hold_reason payment_hold_reason, aia.invoice_currency_code invoice_currency, aia.invoice_amount invoice_amount, nvl(aia.base_amount,aia.invoice_amount) invoice_base_amount, case when aia.invoice_currency_code != gl.currency_code then aia.exchange_rate end invoice_exchange_rate, case when aia.invoice_currency_code != gl.currency_code then (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = aia.exchange_rate_type) end invoice_exchange_rate_type, case when aia.invoice_currency_code != gl.currency_code then aia.exchange_date end invoice_exchange_rate_date, CASE WHEN aia.invoice_currency_code != gl.currency_code THEN (SELECT CONVERSION_RATE FROM gl_daily_rates dr WHERE dr.FROM_CURRENCY = aia.invoice_currency_code AND dr.TO_CURRENCY = gl.currency_code AND dr.CONVERSION_TYPE = 'Spot' AND trunc(dr.CONVERSION_DATE) = trunc( to_date(:P_AS_OF_DATE,'YYYY/MM/DD HH24:MI:SS'))) END closing_exchange_rate, aia.invoice_id, aia.TOTAL_TAX_AMOUNT, apsa.payment_num, apsa.due_date, apsa.AMOUNT_REMAINING, pay.accounting_date payment_date, ceil(xtb.as_of_date-apsa.due_date) days_due, xtb.acctd_rounded_rem_amount ps_amount_remaining, cbbv.bank_name remit_to_bank_name, cbbv.bank_number remit_to_bank_number, cbbv.bank_branch_name remit_to_branch_name, cbbv.branch_number remit_to_branch_number, cbbv.country remit_to_branch_country, ieba.masked_bank_account_num remit_to_account_num, xte.entity_code from xtb xtb, xla_transaction_entities xte, xla_entity_types_vl xetv, ap_invoices_all aia, ap_payment_schedules_all apsa, ap_suppliers asu, ap_supplier_sites_all assa, fnd_territories_vl ftv1, hz_parties hp, hz_party_sites hps, hz_locations hl, fnd_territories_vl ftv2, gl_ledgers gl, fnd_currencies_vl fcv, hr_all_organization_units_vl haouv, iby_ext_bank_accounts ieba, ce_bank_branches_v cbbv, ap_invoice_payments_all pay where xtb.entity_id=xte.entity_id and xtb.source_application_id=xte.application_id and xte.entity_code='AP_INVOICES' and xetv.entity_code=xte.entity_code and xetv.application_id=xte.application_id and aia.invoice_id=nvl(xte.source_id_int_1,-99) and apsa.invoice_id=nvl(xte.source_id_int_1,-99) and aia.vendor_id=asu.vendor_id(+) and aia.vendor_site_id=assa.vendor_site_id(+) and assa.country=ftv1.territory_code(+) and aia.party_id=hp.party_id and aia.party_site_id=hps.party_site_id(+) and ( (asu.employee_id is null and hps.party_site_id is not null) or ( asu.employee_id is not null) ) and hps.location_id=hl.location_id(+) and hl.country=ftv2.territory_code(+) and xtb.ledger_id=gl.ledger_id and gl.currency_code=fcv.currency_code and haouv.organization_id=aia.org_id and aia.org_id = NVL(:p_org_id , aia.org_id ) and apsa.external_bank_account_id = ieba.ext_bank_account_id(+) and ieba.branch_id = cbbv.branch_party_id(+) and ieba.bank_id = cbbv.bank_party_id(+) and aia.invoice_id = pay.invoice_id(+) and aia.org_id = pay.org_id(+) ) -- -- Main Query Starts Here -- select ap_inv.org_id, ap_inv.ledger_name, ap_inv.tb_code, ap_inv.tb_name trial_balance_name, ap_inv.ledger_currency, gcck.concatenated_segments account, ap_inv.third_party_name, ap_inv.third_party_number, ap_inv.third_party_site_name, ap_inv.third_party_site_country, ap_inv.vendor_number, ap_inv.vendor_name, ap_inv.vendor_site, ap_inv.vendor_site_country, ap_inv.operating_unit, ap_inv.source_trx_type transaction_type, ap_inv.source_transaction_number transaction_number, ap_inv.invoice_document_number, TO_CHAR(ap_inv.invoice_date, 'yyyy/mm/dd') invoice_date, ap_inv.invoice_gl_date, ap_inv.invoice_cancelled_date, ap_inv.invoice_source, ap_inv.invoice_type, ap_inv.invoice_description, ap_inv.invoice_status, ap_inv.invoice_payment_status, ap_inv.pay_group, ap_inv.payment_method, ap_inv.dispute_reason, ap_inv.payment_hold_reason, ap_inv.invoice_currency, ap_inv.TOTAL_TAX_AMOUNT, ap_inv.invoice_exchange_rate, ap_inv.invoice_exchange_rate_type, ap_inv.invoice_exchange_rate_date, ap_inv.closing_exchange_rate, ap_inv.party_id, ap_inv.vendor_id, ap_inv.invoice_amount invoice_amount, ap_inv.invoice_base_amount invoice_base_amount, NVL (ap_inv.invoice_base_amount, ap_inv.invoice_amount) transaction_original_amount, ap_inv.acctd_rounded_rem_amount trans_remaining_amount, ap_inv.payment_num, ap_inv.as_of_date, Case When ap_inv.invoice_exchange_rate > 0 then ap_inv.AMOUNT_REMAINING else null end transaction_remaining_amount, (ap_inv.invoice_amount * ap_inv.invoice_exchange_rate) AMOUNT_IN_SOURCE_CUR, Case When ap_inv.invoice_exchange_rate > 0 then (NVL (ap_inv.invoice_base_amount, ap_inv.invoice_amount) ) /ap_inv.invoice_exchange_rate else null end as Remaining_amount_source, CASE WHEN ap_inv.TOTAL_TAX_AMOUNT <> 0 THEN (CASE WHEN TRUNC(invoice_date) <= TO_DATE ('31-MAR-2018', 'dd-mon-yyyy') THEN ap_inv.acctd_rounded_rem_amount * (14 / 114) ELSE ap_inv.acctd_rounded_rem_amount * (15 / 115) END) END AS VAT_amt_incl_remaining_amt, TO_CHAR(ap_inv.due_date, 'yyyy/mm/dd') due_date, ap_inv.days_due, case when ceil(ap_inv.as_of_date-ap_inv.due_date) between -9999 and 30 and ap_inv.ps_amount_remaining != 0 then ap_inv.ps_amount_remaining end cur, case when ceil(ap_inv.as_of_date-ap_inv.due_date) between 31 and 60 and ap_inv.ps_amount_remaining != 0 then ap_inv.ps_amount_remaining end "Days_30", case when ceil(ap_inv.as_of_date-ap_inv.due_date) between 61 and 90 and ap_inv.ps_amount_remaining != 0 then ap_inv.ps_amount_remaining end "Days_60", case when ceil(ap_inv.as_of_date-ap_inv.due_date) between 91 and 120 and ap_inv.ps_amount_remaining != 0 then ap_inv.ps_amount_remaining end "Days_120", case when ceil(ap_inv.as_of_date-ap_inv.due_date) between 121 and 180 and ap_inv.ps_amount_remaining != 0 then ap_inv.ps_amount_remaining end "Days_180", case when ceil(ap_inv.as_of_date-ap_inv.due_date) between 181 and 270 and ap_inv.ps_amount_remaining != 0 then ap_inv.ps_amount_remaining end "Days_270", case when ceil(ap_inv.as_of_date-ap_inv.due_date) between 271 and 365 and ap_inv.ps_amount_remaining != 0 then ap_inv.ps_amount_remaining end "Days_365", case when ceil(ap_inv.as_of_date-ap_inv.due_date) between 366 and 99999 and ap_inv.ps_amount_remaining != 0 then ap_inv.ps_amount_remaining end "Plus_365", ap_inv.balancing_segment_value balancing_segment, gl_flexfields_pkg.get_description(gcck.chart_of_accounts_id,'GL_BALANCING',ap_inv.balancing_segment_value) balancing_segment_desc, ap_inv.natural_account_segment_value account_segment, gl_flexfields_pkg.get_description(gcck.chart_of_accounts_id,'GL_ACCOUNT',ap_inv.natural_account_segment_value) account_segment_desc, ap_inv.cost_center_segment_value cost_center_segment, gl_flexfields_pkg.get_description(gcck.chart_of_accounts_id,'FA_COST_CTR',ap_inv.cost_center_segment_value) cost_center_segment_desc, gcck.segment1 Business_Unit, gcck.segment2 Site, gcck.segment3 Cost_Center, gcck.segment4 Main_Code, gcck.segment5 Account1, gcck.segment6 Product_Group, ap_inv.remit_to_bank_name, ap_inv.remit_to_bank_number, ap_inv.remit_to_branch_name, ap_inv.remit_to_branch_number, ap_inv.remit_to_branch_country, ap_inv.remit_to_account_num, -- ap_inv.invoice_id, ap_inv.entity_code, TO_CHAR(ap_inv.payment_date, 'yyyy/mm/dd') payment_date from ap_inv ap_inv, gl_code_combinations_kfv gcck where ap_inv.tb_code =:P_DEFINITION_CODE and ap_inv.org_id= nvl(:P_SECURITY_ID_INT_1,ap_inv.org_id) and 1=1 and gcck.code_combination_id (+) = ap_inv.code_combination_id and (ap_inv.vendor_id= nvl(SUBSTR(:P_THIRD_PARTY_ID,1,INSTR(:P_THIRD_PARTY_ID, '#') - 1) , ap_inv.vendor_id) or ap_inv.vendor_id= nvl(SUBSTR(:P_THIRD_PARTY_ID,1,INSTR(:P_THIRD_PARTY_ID, '#') - 1), ap_inv.vendor_id )) AND nvl(ap_inv.ps_amount_remaining,0) != 0 --and source_transaction_number ='29090999' order by ap_inv.ledger_name, ap_inv.tb_name, gcck.concatenated_segments, ap_inv.third_party_name, ap_inv.third_party_number, ap_inv.invoice_gl_date, ap_inv.invoice_id, ap_inv.payment_num Y XXTBCR XXTBXLAAP1 US TB Accounts Payables Trial Balance - FSSC Imported from BI Publisher Application: TB Custom Reports Source: TB Accounts payables trial balance-NEW Short Name: XXTBXLAAP1 DB package: BI Publisher 1=1 :p_as_of_date :p_definition_code :p_org_id :p_relative_period :p_security_id_int_1 :p_third_party_id 1 -70 :p_application_id LOV Oracle XLA_SRS_SUBLEDGERS Y select application_id id, application_name value, null description from (select application_name,application_id from xla_subledgers_fvl union select application_name,application_id from fnd_application_vl where application_id=101) order by value,description SELECT APPLICATION_NAME FROM FND_APPLICATION_VL WHERE APPLICATION_ID= nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.RESP_APPL_ID) US XLA_SRS_SUBLEDGERS Application Identifier 2 -60 :p_start_date Date 1950/01/01 00:00:00 Y US Start Date Start Date 3 -50 :p_coa_id Number SELECT gl.chart_of_accounts_id FROM gl_ledgers gl ,xla_tb_definitions_b td WHERE gl.ledger_id = td.ledger_id AND td.definition_code = :$flex$.report_definition Y US Chart of Accounts Chart of Accounts 4 -40 :p_acct_balance LOV Oracle XLA_SRS_TB_ACCT_BALANCE Y select lookup_code id, meaning value, description description from xla_lookups where lookup_type='XLA_TB_ACCT_BALANCE' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_TB_ACCT_BALANCE' AND lookup_code = 'YEAR_TO_DATE' Y US Account Balance Account Balance 5 -30 :p_security_flag LOV Oracle XLA_SRS_TB_SECURITY_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' and decode(:$flex$.xla_srs_tb_je_sources:null ,null ,'N' ,decode((select count(1) from xla_subledgers where je_source_name= :$flex$.xla_srs_tb_je_sources:null and security_function_name is not null) ,0 ,'N' ,lookup_code)) =lookup_code order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_YES_NO' AND DECODE(:$flex$.journal_source:NULL ,NULL ,'N' ,DECODE((SELECT COUNT(1) FROM xla_subledgers WHERE je_source_name = :$flex$.journal_source:NULL AND security_function_name IS NOT NULL) , 0 ,'N' ,'Y')) = lookup_code US Security Security 6 -20 :p_inc_sla_manuals_unposted Char SELECT :$flex$.include_sla_manuals_other_sources.VALUE FROM DUAL US P_INC_SLA_MANUALS_UNPOSTED Include SLA Manuals/Other Sources Value 7 -10 :p_report_style Char SELECT :$flex$.report_mode.VALUE FROM DUAL US P_REPORT_STYLE Report Mode Meaning 8 10 :p_security_id_int_1 LOV Oracle FND_MO_OU Y select organization_id id, organization_name value, null description from mo_glob_org_access_tmp order by value,description US Operating Unit Operating Unit 9 20 :p_definition_code LOV Oracle XLA_SRS_TB_DEFINITIONS_ALL Y select definition_code id, name value, description description from xla_tb_definitions_vl where enabled_flag='Y' and ( definition_code in ( select xtd.definition_code from xla_tb_defn_je_sources xtd ,xla_subledgers xs where xtd.je_source_name=xs.je_source_name and xs.application_id=:$flex$.xla_srs_subledgers ) or decode(:$flex$.xla_srs_subledgers,101,'GL','OTHERS')='GL' ) and ( (nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='N') or ( nvl(fnd_profile.value('XLA_USE_LEDGER_SECURITY'),'N')='Y' and exists ( select 1 from gl_access_sets gas, gl_access_set_assignments asa where gas.access_set_id=asa.access_set_id and asa.ledger_id=xla_tb_definitions_vl.ledger_id and (gas.access_set_id= nvl(fnd_profile.value('GL_ACCESS_SET_ID'),'-1') or gas.access_set_id= nvl(fnd_profile.value('XLA_GL_SECONDARY_ACCESS_SET_ID'), '-1'))))) order by value,description Y US Report Definition Report Definition 10 30 :p_journal_source LOV Oracle XLA_SRS_TB_JE_SOURCES Y select je_source_name id, user_je_source_name value, null description from gl_je_sources a where exists (select 1 from xla_tb_defn_je_sources djs ,xla_subledgers xls where djs.je_source_name=xls.je_source_name and djs.je_source_name=a.je_source_name and djs.definition_code=:$flex$.xla_srs_tb_definitions_all and xls.application_id= decode(nvl(fnd_profile.value('XLA_JE_SOURCE_ALLOW_OVERRIDE'),'N') ,'Y' ,xls.application_id ,:$flex$.xla_srs_subledgers ) ) order by user_je_source_name SELECT gjs.user_je_source_name FROM gl_je_sources gjs WHERE gjs.je_source_name IN (SELECT xls.je_source_name FROM xla_tb_defn_je_sources xjs ,xla_subledgers xls WHERE xjs.je_source_name = xls.je_source_name AND xjs.definition_code = :$flex$.report_definition AND xls.application_id = nvl(fnd_profile.value('XLA_APPL_ID'),fnd_global.RESP_APPL_ID)) US Journal Source Journal Source 11 40 :p_as_of_date Date sysdate Y US As of Date As of Date 12 50 :p_third_party_id LOV Oracle XLA_SRS_TB_THIRD_PARTY Y select tp.pt_id || '#$' || tp.pt_cd id, tp.pt_nm value, lk.meaning description from ((select vendor_id pt_id,vendor_name pt_nm,'S' pt_cd from ap_suppliers) union all (select hca.cust_account_id pt_id,hp.party_name pt_nm,'C' pt_cd from hz_cust_accounts hca,hz_parties hp where hca.party_id=hp.party_id)) tp,xla_lookups lk where tp.pt_cd=lk.lookup_code and lk.lookup_type='XLA_PARTY_TYPE' order by tp.pt_nm US Third Party Name Third Party Name 13 60 :p_show_trx_detail_flag LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_YES_NO' AND lookup_code = 'N' Y US Show Transaction Detail Show Transaction Detail 14 70 :p_incl_write_off_flag LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type = 'XLA_YES_NO' AND lookup_code = 'N' Y US Include Write Offs Include Write Offs 15 80 :p_account_from Char US Account From Account From 16 90 :p_account_to Char US Account To Account To 17 100 :p_relative_period Number 0 US P_RELATIVE_PERIOD Period 18 110 :p_include_sla_manuals_unposted LOV Oracle XLA_SRS_YES_NO Y select lookup_code id, meaning value, null description from xla_lookups where lookup_type='XLA_YES_NO' order by value,description SELECT meaning FROM xla_lookups WHERE lookup_type ='XLA_YES_NO' and lookup_code ='N' US Include SLA Manuals/Other Sources Include SLA Manuals/Other Sources Flag 19 120 :p_report LOV Oracle XLA_SRS_TB_REPORT_MODE Y select xlk.lookup_code id, xlk.meaning value, null description from xla_lookups xlk where xlk.lookup_code<>'N' and xlk.lookup_type='XLA_REPORT_LEVEL' order by value,description select xlk.meaning from xla_lookups xlk where xlk.lookup_code = 'S' and xlk.lookup_type = 'XLA_REPORT_LEVEL' Y US Report Mode Report Mode :$flex$.include_sla_manuals_other_sources.VALUE Include SLA Manuals/Other Sources P_INC_SLA_MANUALS_UNPOSTED value :$flex$.report_definition Report Definition Chart of Accounts :$flex$.report_definition Report Definition Journal Source :$flex$.report_mode.VALUE Report Mode P_REPORT_STYLE value :$flex$.xla_srs_subledgers XLA_SRS_SUBLEDGERS Journal Source :$flex$.xla_srs_subledgers XLA_SRS_SUBLEDGERS Report Definition :$flex$.xla_srs_tb_definitions_all Report Definition Journal Source