ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F26C78167A214EFBE0530100007F336B GL Balancing Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US 2F8C88B2268A0824E06362FB09056154Y select trx.ledger ledger, trx.operating_unit operating_unit, trx.account accounting_flexfield, trx.vendor_name trading_partner, trx.vendor_number supplier_number, trx.txn_number invoice_number, trx.txn_type_lookup_code type, trx.internal_inv_number internal_invoice_number, trx.txn_date "Date", trx.due_date "Due Date", trx.entered_amount invoice_amount, trx.open_entered_amount amount_due, trx.txn_currency_code currency, trx.exchange_rate exchange_rate, trx.open_accounted_amount open_functional_amount, trx.revaluation_rate revaluation_rate, trx.revalued_amount open_revalued_amount, NVL(trx.open_accounted_amount,0) - nvl(trx.revalued_amount,0) "Profit/Loss", nvl2(trx.revaluation_rate,null,'*') no_revaluation_rate from (select (select sob.name from gl_ledgers sob where sob.ledger_id = :g_ledger_id) ledger, (select haou.name from hr_all_organization_units haou where haou.organization_id = :p_org_id) operating_unit, opit.balancing_segment balancing_segment, opit.account_segment account_segment, opit.code_combination_id, opit.account account, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_description', 'SQLGL', 'GL#', :p_coa_id, null, opit.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') account_description, opit.party_id party_id, opit.party_site_id party_site_id, opit.vendor_id vendor_id, opit.party_name vendor_name, opit.vendor_number vendor_number, opit.vendor_site_id vendor_site_id, opit.vendor_site_code vendor_site_code, opit.txn_id txn_id, opit.txn_number txn_number, (select nvl(aia.doc_sequence_value,aia.voucher_num) from ap_invoices_all aia where aia.invoice_id = opit.txn_id ) internal_inv_number, opit.txn_type_lookup_code txn_type_lookup_code, opit.txn_date txn_date, opit.txn_currency_code txn_currency_code, opit.payment_currency_code pmt_currency_code, round(opit.txn_base_exchange_rate, 5) exchange_rate, opit.payment_cross_rate payment_cross_rate, decode(opit.revaluation_rate, null, 'No Rate', round(opit.revaluation_rate, 5) ) revaluation_rate, opit.payment_status_flag payment_status_flag, opit.entered_amount entered_amount, opit.accounted_amount accounted_amount, opit.open_entered_amount open_entered_amount, opit.open_accounted_amount open_accounted_amount, nvl(to_char(round(opit.open_entered_amount * opit.revaluation_rate, :g_base_precision)), '*') revalued_amount_dsp, round(opit.open_entered_amount * opit.revaluation_rate, :g_base_precision) revalued_amount, case when opit.revaluation_rate is null or opit.open_accounted_amount > round(opit.open_entered_amount * opit.revaluation_rate, :g_base_precision) then opit.open_accounted_amount else round(opit.open_entered_amount * opit.revaluation_rate, :g_base_precision) end open_revalued_amount, ap_open_items_reval_pkg.get_due_date(opit.txn_id, opit.txn_type_lookup_code) due_date from (select b.balancing_segment, b.account_segment, b.code_combination_id, b.account, b.party_id, b.party_site_id, b.party_name, b.vendor_id, b.vendor_number, b.vendor_site_id, b.vendor_site_code, b.txn_id, b.txn_number, b.txn_type_lookup_code, b.txn_date, b.txn_currency_code, b.payment_currency_code, b.txn_base_exchange_rate, b.payment_cross_rate, ap_open_items_reval_pkg.get_revaluation_rate(b.txn_currency_code, b.payment_cross_rate_type) revaluation_rate, b.payment_status_flag, b.entered_amount, b.accounted_amount, nvl(round((pay_cur_inv_entered_amt - payment_entered_amount)/b.payment_cross_rate, 2), b.entered_amount) open_entered_amount, nvl(round(round((pay_cur_inv_entered_amt - payment_entered_amount)/b.payment_cross_rate, 2) * b.txn_base_exchange_rate, :g_base_precision), b.accounted_amount) open_accounted_amount from (select /*+ leading (aoi aip) parallel(aoi)*/ distinct aoi.code_combination_id, aoi.party_id, aoi.party_site_id, aoi.vendor_id, aoi.vendor_number, aoi.vendor_site_id, aoi.txn_id invoice_id, aoi.txn_currency_code, aoi.payment_currency_code, aoi.txn_base_exchange_rate, aoi.payment_cross_rate, aoi.txn_type_lookup_code, --bug13613111 round(aoi.entered_amount * aoi.payment_cross_rate, 2) pay_cur_inv_entered_amt, sum((nvl(aip.amount, 0) + nvl(aip.discount_taken, 0))) payment_entered_amount from ap_open_items_reval_gt aoi, ap_invoice_payments_all aip, ap_checks_all ac where aip.invoice_id = aoi.txn_id and aip.set_of_books_id = :g_ledger_id and aip.org_id = :p_org_id and ac.check_id = aip.check_id and aip.accounting_date <= :g_revaluation_date and aoi.txn_type_lookup_code <> 'Payment' &lp_cleared_items_clause1 group by aoi.code_combination_id, aoi.party_id, aoi.party_site_id, aoi.vendor_id, aoi.vendor_number, aoi.vendor_site_id, aoi.txn_id , aoi.txn_currency_code, aoi.payment_currency_code, aoi.txn_base_exchange_rate, aoi.payment_cross_rate, aoi.entered_amount, aoi.txn_type_lookup_code ) a, ap_open_items_reval_gt b where b.txn_id = a.invoice_id(+) and b.txn_type_lookup_code = a.txn_type_lookup_code(+) and b.code_combination_id = a.code_combination_id(+) and nvl((a.pay_cur_inv_entered_amt - a.payment_entered_amount), b.entered_amount) <> 0 and decode(nvl(sign(abs(a.pay_cur_inv_entered_amt - a.payment_entered_amount)-1), 1),-1, decode(nvl(b.payment_status_flag, 'N'),'Y', 0, 1), 1) <> 0 and :p_transfer_to_gl_only = 'N' union select /*+ parallal b */distinct b.balancing_segment, b.account_segment, b.code_combination_id, b.account, b.party_id, b.party_site_id, b.party_name, b.vendor_id, b.vendor_number, b.vendor_site_id, b.vendor_site_code, b.txn_id, b.txn_number, b.txn_type_lookup_code, b.txn_date, b.txn_currency_code, b.payment_currency_code, b.txn_base_exchange_rate, b.payment_cross_rate, ap_open_items_reval_pkg.get_revaluation_rate(b.txn_currency_code, b.payment_cross_rate_type) revaluation_rate, b.payment_status_flag, b.entered_amount, b.accounted_amount, b.entered_amount - sum(nvl(a.entered_amount, 0)) open_entered_amount, b.accounted_amount - sum(nvl(a.accounted_amount, 0)) open_accounted_amount from (select /*+ parallel(aoi) leading(aoi)*/ distinct 200 application_id, null ref_ae_header_id, null temp_line_num, xah.ae_header_id, xal.ae_line_num, aoi.code_combination_id, aoi.account, aoi.txn_id invoice_id, aoi.txn_base_exchange_rate, aoi.txn_type_lookup_code, txn_amount invoice_amount, txn_base_amount invoice_base_amount, nvl(xal.entered_dr, 0) - nvl(xal.entered_cr, 0) entered_amount, nvl(xal.accounted_dr, 0) - nvl(xal.accounted_cr, 0) accounted_amount from ap_open_items_reval_gt aoi, ap_checks_all ac, xla_transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal where ac.check_id in (select bk.check_id from ap_invoice_payments_all bk where bk.invoice_id = aoi.txn_id ) and nvl(xte.source_id_int_1, -99) = ac.check_id and nvl(xte.security_id_int_1, -99) = :p_org_id and xte.ledger_id = :g_ledger_id and xte.entity_code = 'AP_PAYMENTS' and xte.application_id = 200 and xah.entity_id = xte.entity_id and xah.ledger_id = :g_ledger_id and xah.gl_transfer_status_code = 'Y' and xah.event_type_code <> 'MANUAL' and xah.application_id = 200 and xah.accounting_date <= :g_revaluation_date and xah.upg_batch_id is not null and xal.ae_header_id = xah.ae_header_id and xal.code_combination_id = aoi.code_combination_id and xal.accounting_class_code= 'LIABILITY' and xal.application_id = 200 and ( ( xal.source_table = 'AP_INVOICE_PAYMENTS' and exists (select 1 from ap_invoice_payments_all aip where aip.invoice_id = aoi.txn_id and aip.invoice_payment_id = xal.source_id) ) or ( xal.source_table = 'AP_INVOICES' and xal.source_id = aoi.txn_id ) or ( xal.source_table = 'AP_INVOICE_DISTRIBUTIONS' and exists (select 1 from ap_invoice_distributions_all aid where aid.invoice_id = aoi.txn_id and aid.invoice_distribution_id = xal.source_id) ) ) and aoi.txn_type_lookup_code <> 'Payment' and :p_transfer_to_gl_only = 'Y' &lp_cleared_items_clause1 union select /*+ leading (aoi aip xte xah xal xdl) parallel(aoi)*/ distinct xdl.application_id, xdl.ref_ae_header_id, xdl.temp_line_num, xdl.ae_header_id, null ae_line_num, aoi.code_combination_id, aoi.account, aip.invoice_id, aoi.txn_base_exchange_rate, aoi.txn_type_lookup_code, txn_amount invoice_amount, txn_base_amount invoice_base_amount, nvl(xdl.unrounded_entered_dr, 0) - nvl(xdl.unrounded_entered_cr, 0) entered_amount, nvl(xdl.unrounded_accounted_dr, 0) - nvl(xdl.unrounded_accounted_cr, 0) accounted_amount from ap_open_items_reval_gt aoi, ap_invoice_payments_all aip, ap_checks_all ac, xla_transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal, xla_distribution_links xdl where aip.invoice_id = aoi.txn_id and nvl(xte.source_id_int_1, -99) = aip.check_id and nvl(xte.security_id_int_1, -99) = :p_org_id and aip.set_of_books_id = :g_ledger_id and aip.org_id = :p_org_id and xte.ledger_id = :g_ledger_id and ac.check_id = aip.check_id and xah.entity_id = xte.entity_id and xah.ledger_id = :g_ledger_id and xah.gl_transfer_status_code = 'Y' and xah.event_type_code <> 'MANUAL' and xah.application_id = 200 and xte.application_id = 200 and xte.entity_code = 'AP_PAYMENTS' and xah.accounting_date <= :g_revaluation_date and xah.upg_batch_id is null and xal.ae_header_id = xah.ae_header_id and xdl.ae_header_id = xah.ae_header_id and xdl.ae_line_num = xal.ae_line_num and xal.code_combination_id = aoi.code_combination_id and xdl.applied_to_source_id_num_1 = aip.invoice_id and xal.accounting_class_code = 'LIABILITY' and xdl.applied_to_entity_code = 'AP_INVOICES' and xdl.application_id = 200 and aoi.txn_type_lookup_code <> 'Payment' &lp_cleared_items_clause1 ) a, ap_open_items_reval_gt b where b.txn_id = a.invoice_id(+) and b.txn_type_lookup_code = a.txn_type_lookup_code(+) and b.code_combination_id = a.code_combination_id(+) and :p_transfer_to_gl_only = 'Y' group by b.balancing_segment, b.account_segment, b.code_combination_id, b.account, b.party_id, b.party_site_id, b.party_name, b.vendor_id, b.vendor_number, b.vendor_site_id, b.vendor_site_code, b.txn_id, b.txn_number, b.txn_type_lookup_code, b.txn_date, b.txn_currency_code, b.payment_currency_code, b.txn_base_exchange_rate, b.payment_cross_rate, b.payment_cross_rate_type, b.payment_status_flag, b.entered_amount, b.accounted_amount having b.entered_amount <> sum(nvl(a.entered_amount, 0)) or b.accounted_amount <> sum(nvl(a.accounted_amount, 0)) ) opit order by balancing_segment, account_segment, account, party_name, vendor_number, vendor_site_code, txn_number, txn_type_lookup_code, txn_date ) trx where 1=1 SQLAP APOPITRN #,##0.00;(#,##0.00) B28805F4F09E1687E0530100007FC83D (:Rate_Type = 'DAILY' and (:Daily_Rate_Type is not null and :Daily_Rate_Date is not null)) or (:Rate_Type = 'PERIOD') US COPY OF: AP Open Balances Revaluation Description: AP Open Balances Revaluation Report This report is in the same format as the AP Open Balances Revaluation Report which is no longer supported and should no loinger be used. The data source for this report is the same as the AP Open Items Revaluation report. Application: Payables Source: Open Items Revaluation Report (XML) Short Name: APOPITRN DB package: AP_OPEN_ITEMS_REVAL_PKG Please Enter a Daily Rate Type and Daily Rate Date when using a Rate Type of Daily BI Publisher &lp_cleared_items_clause1 1=1 :g_base_currency_code :g_base_currency_desc :g_base_min_acct_unit :g_base_precision :g_cleared_only_dsp :g_coa_id :g_daily_rate_error :g_daily_rate_information :g_daily_rate_type_dsp :g_eur_code :g_gl_name_dsp :g_ledger_id :g_operating_unit_dsp :g_rate_type_dsp :g_revaluation_date :g_sql_statement :g_trans_to_gl_only_dsp :p_cleared_only :p_coa_id :p_daily_rate_date :p_daily_rate_type :p_debug_switch :p_due_date :p_from_balancing_segment :p_org_id :p_rate_type_lookup_code :p_revaluation_period :p_to_balacing_segment :p_trace_switch :p_transfer_to_gl_only 1 -100 :p_coa_id Char select sb.chart_of_accounts_id from gl_sets_of_books sb, ap_system_parameters sp where sb.set_of_books_id = sp.set_of_books_id US Chart of Accounts Id 2 10 :p_org_id 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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y US Operating Unit Operating Unit 3 20 :p_revaluation_period LOV Oracle AP_SRS_REV_PERIOD_NAMES_OIR Y select gps.period_name id, gps.period_name value, gsob.name description from gl_period_statuses gps,gl_sets_of_books gsob where gps.set_of_books_id in (select distinct set_of_books_id from ap_system_parameters where org_id=nvl(:$flex$.fnd_mo_ou:null,org_id)) and gps.set_of_books_id=gsob.set_of_books_id and gps.application_id=200 order by gps.period_year desc,gps.period_num desc Y US Revaluation Period Revaluation Period 4 30 :p_due_date Date US Include Up to Due Date Include Up To Due Date 5 40 :p_rate_type_lookup_code LOV Oracle AP_SRS_APXINREV_RATE_TYPE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where lookup_type='APXINREV_RATE_TYPE' order by value,description PERIOD Y US Rate Type Rate Type 6 50 :p_daily_rate_type LOV Oracle AP_SRS_APXINREV_DAILY_RATE_TYPE Y select conversion_type id, user_conversion_type value, null description from gl_daily_conversion_types where conversion_type<>'User' order by upper (user_conversion_type) US Daily Rate Type Daily Rate Type 7 60 :p_daily_rate_date Date US Daily Rate Date Daily Rate Date 8 70 :p_from_balancing_segment LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US Balancing Segment Low Balancing Segment Low 9 80 :p_to_balacing_segment LOV GL Balancing F26C78167A214EFBE0530100007F336B Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value :$flex$.Balancing_Segment_Low US Balancing Segment High Balancing Segment High 10 90 :p_transfer_to_gl_only LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Transferred to GL only Apply Payments and acknowledge open items only if transferred to GL 11 100 :p_cleared_only LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Cleared only Apply payments and acknowledge open items only if they are cleared 12 &lp_cleared_items_clause1 select null from dual N US Cleared only 13 &lp_cleared_items_clause1 and ac.status_lookup_code IN ('CLEARED','RECONCILED','CLEARED BUT UNACCOUNTED','RECONCILED UNACCOUNTED') Y US Cleared only 14 110 1=1 trx.txn_currency_code != (select gl.currency_code from gl_ledgers gl where gl.ledger_id = ap_open_items_reval_pkg.g_ledger_id) LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y Y US Include Domestic Invoice Include Domestic Invoice 15 120 1=1 trx.txn_currency_code = :p_txn_currency_code LOV Oracle AP_SRS_CURRENCY Y select currency_code id, currency_code value, description description from fnd_currencies_vl where currency_flag='Y' and enabled_flag in ('Y','N') order by currency_code US Transaction Currency Transaction Currency to Revalue 16 130 1=1 trx.vendor_id = :p_vendor_id LOV Oracle AP_SRS_VENDOR_NAME Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description US Supplier Supplier