ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1023869E053B46B63588994 SELECT substr(p.party_name,1,80) C_VENDOR_NAME, UPPER(substr(p.party_name,1,80)) C_UPPER_NAME, p.organization_name_phonetic C_VENDOR_NAME_ALT, UPPER(p.organization_name_phonetic) C_UPPER_NAME_ALT, decode(upper(:P_SORT_OPTION), 'VENDOR NAME',decode(:C_VENDOR_NAME_SELECT, '%',upper(substr(p.party_name,1,80)), substr(p.party_name,1,80)), i.invoice_type_lookup_code) C_PRIMARY_BRK, decode(upper(:P_SORT_OPTION), 'VENDOR NAME',decode(:C_VENDOR_NAME_SELECT, '%', decode(:SORT_BY_ALTERNATE, 'Y', upper(p.organization_name_phonetic), upper(substr(p.party_name,1,80))), decode(:SORT_BY_ALTERNATE, 'Y', p.organization_name_phonetic, substr(p.party_name,1,80))), i.invoice_type_lookup_code) C_PRIMARY_BRK_REAL, substr(p.party_name,1,80) C_SHORT_VENDOR_NAME, v.vendor_id C_VENDOR_ID, i.vendor_site_id C_CONTACT_SITE_ID, vs.vendor_site_code C_VENDOR_SITE_CODE, vs.vendor_site_code_alt C_VENDOR_SITE_CODE_ALT, decode(:SORT_BY_ALTERNATE, 'Y', vs.vendor_site_code_alt, vs.vendor_site_code) C_VENDOR_SITE_CODE_BRK, nvl(vs.state,' ') C_VENDOR_STATE, nvl(substr(vs.city,1,15),' ') C_VENDOR_CITY, ps.payment_num C_REFERENCE_NUMBER, i.vendor_site_id C_ADDRESS_ID, nvl(substr(i.invoice_type_lookup_code,1,20), ' ') C_INVOICE_TYPE, i.invoice_id C_PAYMENT_SCHED_ID, nvl(to_char(ps.due_date,'DD-MON-RR'),' ') C_DUE_DATE, decode(:C_BASE_MIN_ACCT_UNIT, 0,round((nvl(ps.amount_remaining, 0) * nvl(i.exchange_rate,1)),:C_BASE_PRECISION), round((nvl(ps.amount_remaining, 0) * nvl(i.exchange_rate,1))/:C_BASE_MIN_ACCT_UNIT) * :C_BASE_MIN_ACCT_UNIT) C_AMT_DUE_REMAINING, decode(:C_BASE_MIN_ACCT_UNIT, 0,round((nvl(ps.gross_amount, 0) * nvl(i.exchange_rate,1)),:C_BASE_PRECISION), round((nvl(ps.gross_amount, 0) * nvl(i.exchange_rate,1))/:C_BASE_MIN_ACCT_UNIT) * :C_BASE_MIN_ACCT_UNIT) C_AMT_DUE_ORIGINAL, i.accts_pay_code_combination_id C_VENDOR_TRX_ID, i.invoice_num C_INVOICE_NUMBER, i.invoice_num C_INVOICE_NUM_SHORT, null C_CHECK_NUMBER, to_char(i.invoice_date,'DD-MON-RR') C_INVOICE_DATE, ceil(trunc(SYSDATE) - ps.due_date) C_DAYS_PAST_DUE, decode(i.invoice_currency_code, :C_BASE_CURRENCY_CODE, ' ', decode(i.exchange_rate, NULL,'*', ' ')) C_DATA_CONVERTED, nvl(i.exchange_rate, 1) C_EXCHANGE_RATE, decode(:C_VENDOR_NAME_SELECT, '%',decode(:SORT_BY_ALTERNATE, 'Y', upper(p.organization_name_phonetic), upper(substr(p.party_name,1,80))), decode(:SORT_BY_ALTERNATE, 'Y', p.organization_name_phonetic, substr(p.party_name,1,80))) C_VENDOR_NAME_BRK, 'Invoice' C_PART_OF_SELECT, JE_JEHUIAGE_XMLP_PKG.c_per_inv_due_amt_1formula(:C_SUM_INV_DUE_AMT_1, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_1, JE_JEHUIAGE_XMLP_PKG.c_pgbrk_data_convertedformula(:C_SUM_DATA_CONVERTED) C_PGBRK_DATA_CONVERTED, JE_JEHUIAGE_XMLP_PKG.c_per_inv_due_amt_2formula(:C_SUM_INV_DUE_AMT_2, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_2, JE_JEHUIAGE_XMLP_PKG.c_per_inv_due_amt_3formula(:C_SUM_INV_DUE_AMT_3, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_3, JE_JEHUIAGE_XMLP_PKG.c_per_inv_due_amt_4formula(:C_SUM_INV_DUE_AMT_4, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_4, JE_JEHUIAGE_XMLP_PKG.c_per_v_inv_amt_1formula(:C_SUM_V_INV_AMT_1, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_1, JE_JEHUIAGE_XMLP_PKG.c_per_v_inv_amt_2formula(:C_SUM_V_INV_AMT_2, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_2, JE_JEHUIAGE_XMLP_PKG.c_per_v_inv_amt_3formula(:C_SUM_V_INV_AMT_3, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_3, JE_JEHUIAGE_XMLP_PKG.c_per_v_inv_amt_4formula(:C_SUM_V_INV_AMT_4, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_4, JE_JEHUIAGE_XMLP_PKG.c_v_data_convertedformula(:C_SUM_V_DATA_CONVERTED) C_V_DATA_CONVERTED, JE_JEHUIAGE_XMLP_PKG.c_contact_lineformula(i.vendor_site_id) C_CONTACT_LINE, JE_JEHUIAGE_XMLP_PKG.c_percent_remainingformula(decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.gross_amount , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.gross_amount , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_PERCENT_REMAINING, JE_JEHUIAGE_XMLP_PKG.c_check_data_convertedformula(decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , ' ' , decode ( i.exchange_rate , NULL , '*' , ' ' ) )) C_CHECK_DATA_CONVERTED, JE_JEHUIAGE_XMLP_PKG.cf_due_dateformula(nvl ( to_char ( ps.due_date , 'DD-MON-RR' ) , ' ' )) CF_DUE_DATE, JE_JEHUIAGE_XMLP_PKG.c_inv_due_amt_1formula(ceil ( trunc ( SYSDATE ) - ps.due_date ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_INV_DUE_AMT_1, JE_JEHUIAGE_XMLP_PKG.c_inv_due_amt_2formula(ceil ( trunc ( SYSDATE ) - ps.due_date ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_INV_DUE_AMT_2, JE_JEHUIAGE_XMLP_PKG.c_inv_due_amt_3formula(ceil ( trunc ( SYSDATE ) - ps.due_date ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_INV_DUE_AMT_3, JE_JEHUIAGE_XMLP_PKG.c_inv_due_amt_4formula(ceil ( trunc ( SYSDATE ) - ps.due_date ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_INV_DUE_AMT_4 FROM ap_payment_schedules ps, ap_invoices i, ap_suppliers v, ap_supplier_sites vs, hz_parties p WHERE i.invoice_id = ps.invoice_id AND p.party_id = v.party_id AND i.set_of_books_id = :P_LEDGER_ID AND i.legal_entity_id = NVL(:P_LEGAL_ENTITY_ID, i.legal_entity_id) AND i.vendor_id = v.vendor_id AND i.vendor_site_id = vs.vendor_site_id &P_VENDOR_PREDICATE AND ((trunc(SYSDATE) - ps.due_date) BETWEEN :C_MINDAYS AND :C_MAXDAYS) AND i.invoice_type_lookup_code like :C_INVOICE_TYPE_SELECT AND i.cancelled_date IS NULL AND (nvl(ps.amount_remaining, 0) * nvl(i.exchange_rate,1)) != 0 &P_AMOUNT_PREDICATE AND i.payment_status_flag in ('N','P') UNION ALL SELECT substr(p.party_name,1,80) C_VENDOR_NAME, UPPER(substr(p.party_name,1,80)) C_UPPER_NAME, p.organization_name_phonetic C_VENDOR_NAME_ALT, UPPER(p.organization_name_phonetic) C_UPPER_NAME_ALT, decode(upper(:P_SORT_OPTION), 'VENDOR NAME',decode(:C_VENDOR_NAME_SELECT, '%',upper(substr(p.party_name,1,80)), substr(p.party_name,1,80)), i.invoice_type_lookup_code) C_PRIMARY_BRK, decode(upper(:P_SORT_OPTION), 'VENDOR NAME',decode(:C_VENDOR_NAME_SELECT, '%', decode(:SORT_BY_ALTERNATE, 'Y', upper(p.organization_name_phonetic), upper(substr(p.party_name,1,80))), decode(:SORT_BY_ALTERNATE, 'Y', p.organization_name_phonetic, substr(p.party_name,1,80))), i.invoice_type_lookup_code) C_PRIMARY_BRK_REAL, substr(p.party_name,1,80) C_SHORT_VENDOR_NAME, v.vendor_id C_VENDOR_ID, i.vendor_site_id C_CONTACT_SITE_ID, vs.vendor_site_code C_VENDOR_SITE_CODE, vs.vendor_site_code_alt C_VENDOR_SITE_CODE_ALT, decode(:SORT_BY_ALTERNATE, 'Y', vs.vendor_site_code_alt, vs.vendor_site_code) C_VENDOR_SITE_CODE_BRK, nvl(vs.state,' ') C_VENDOR_STATE, nvl(substr(vs.city,1,15),' ') C_VENDOR_CITY, ps.payment_num C_REFERENCE_NUMBER, i.vendor_site_id C_ADDRESS_ID, nvl(substr(i.invoice_type_lookup_code,1,20), ' ') C_INVOICE_TYPE, i.invoice_id C_PAYMENT_SCHED_ID, nvl(to_char(ps.due_date,'DD-MON-RR'),' ') C_DUE_DATE, nvl(ip.payment_base_amount, ip.amount) C_AMT_DUE_REMAINING, decode(:C_BASE_MIN_ACCT_UNIT, 0,round((nvl(ps.gross_amount, 0) * nvl(i.exchange_rate,1)),:C_BASE_PRECISION), round((nvl(ps.gross_amount, 0) * nvl(i.exchange_rate,1))/:C_BASE_MIN_ACCT_UNIT) * :C_BASE_MIN_ACCT_UNIT) C_AMT_DUE_ORIGINAL, i.accts_pay_code_combination_id C_VENDOR_TRX_ID, i.invoice_num C_INVOICE_NUMBER, i.invoice_num C_INVOICE_NUM_SHORT, &P_SELECT_CHECK_NUMBER C_CHECK_NUMBER, to_char(i.invoice_date,'DD-MON-RR') C_INVOICE_DATE, ceil(trunc(SYSDATE) - ps.due_date) C_DAYS_PAST_DUE, decode(i.invoice_currency_code, :C_BASE_CURRENCY_CODE, ' ', decode(i.exchange_rate, NULL,'*', ' ')) C_DATA_CONVERTED, nvl(i.exchange_rate, 1) C_EXCHANGE_RATE, decode(:C_VENDOR_NAME_SELECT, '%',decode(:SORT_BY_ALTERNATE, 'Y', upper(p.organization_name_phonetic), upper(substr(p.party_name,1,80))), decode(:SORT_BY_ALTERNATE, 'Y', p.organization_name_phonetic, substr(p.party_name,1,80))) C_VENDOR_NAME_BRK, 'Payment' C_PART_OF_SELECT, JE_JEHUIAGE_XMLP_PKG.c_per_inv_due_amt_1formula(:C_SUM_INV_DUE_AMT_1, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_1, JE_JEHUIAGE_XMLP_PKG.c_pgbrk_data_convertedformula(:C_SUM_DATA_CONVERTED) C_PGBRK_DATA_CONVERTED, JE_JEHUIAGE_XMLP_PKG.c_per_inv_due_amt_2formula(:C_SUM_INV_DUE_AMT_2, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_2, JE_JEHUIAGE_XMLP_PKG.c_per_inv_due_amt_3formula(:C_SUM_INV_DUE_AMT_3, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_3, JE_JEHUIAGE_XMLP_PKG.c_per_inv_due_amt_4formula(:C_SUM_INV_DUE_AMT_4, :C_SUM_AMT_REMAINING) C_PER_INV_DUE_AMT_4, JE_JEHUIAGE_XMLP_PKG.c_per_v_inv_amt_1formula(:C_SUM_V_INV_AMT_1, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_1, JE_JEHUIAGE_XMLP_PKG.c_per_v_inv_amt_2formula(:C_SUM_V_INV_AMT_2, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_2, JE_JEHUIAGE_XMLP_PKG.c_per_v_inv_amt_3formula(:C_SUM_V_INV_AMT_3, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_3, JE_JEHUIAGE_XMLP_PKG.c_per_v_inv_amt_4formula(:C_SUM_V_INV_AMT_4, :C_SUM_V_DUE_REMAINING) C_PER_V_INV_AMT_4, JE_JEHUIAGE_XMLP_PKG.c_v_data_convertedformula(:C_SUM_V_DATA_CONVERTED) C_V_DATA_CONVERTED, JE_JEHUIAGE_XMLP_PKG.c_contact_lineformula(i.vendor_site_id) C_CONTACT_LINE, JE_JEHUIAGE_XMLP_PKG.c_percent_remainingformula(decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.gross_amount , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.gross_amount , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_PERCENT_REMAINING, JE_JEHUIAGE_XMLP_PKG.c_check_data_convertedformula(decode ( i.invoice_currency_code , :C_BASE_CURRENCY_CODE , ' ' , decode ( i.exchange_rate , NULL , '*' , ' ' ) )) C_CHECK_DATA_CONVERTED, JE_JEHUIAGE_XMLP_PKG.cf_due_dateformula(nvl ( to_char ( ps.due_date , 'DD-MON-RR' ) , ' ' )) CF_DUE_DATE, JE_JEHUIAGE_XMLP_PKG.c_inv_due_amt_1formula(ceil ( trunc ( SYSDATE ) - ps.due_date ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_INV_DUE_AMT_1, JE_JEHUIAGE_XMLP_PKG.c_inv_due_amt_2formula(ceil ( trunc ( SYSDATE ) - ps.due_date ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_INV_DUE_AMT_2, JE_JEHUIAGE_XMLP_PKG.c_inv_due_amt_3formula(ceil ( trunc ( SYSDATE ) - ps.due_date ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_INV_DUE_AMT_3, JE_JEHUIAGE_XMLP_PKG.c_inv_due_amt_4formula(ceil ( trunc ( SYSDATE ) - ps.due_date ), decode ( :C_BASE_MIN_ACCT_UNIT , 0 , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) , :C_BASE_PRECISION ) , round ( ( nvl ( ps.amount_remaining , 0 ) * nvl ( i.exchange_rate , 1 ) ) / :C_BASE_MIN_ACCT_UNIT ) * :C_BASE_MIN_ACCT_UNIT )) C_INV_DUE_AMT_4 FROM ap_suppliers v, ap_supplier_sites vs, ap_invoices i, ap_checks c, ap_payment_schedules ps, ap_invoice_payments ip, hz_parties p WHERE v.vendor_id = i.vendor_id AND p.party_id = v.party_id AND i.set_of_books_id = :P_LEDGER_ID AND i.legal_entity_id = NVL(:P_LEGAL_ENTITY_ID, i.legal_entity_id) &P_VENDOR_PREDICATE AND vs.vendor_site_id = i.vendor_site_id AND i.invoice_type_lookup_code like :C_INVOICE_TYPE_SELECT AND i.cancelled_date IS NULL AND i.invoice_id = ip.invoice_id AND c.status_lookup_code = 'NEGOTIABLE' AND c.check_id = ip.check_id AND ((trunc(SYSDATE) - ps.due_date) BETWEEN :C_MINDAYS AND :C_MAXDAYS) AND ps.payment_num = ip.payment_num AND ps.invoice_id = ip.invoice_id AND nvl(ip.payment_base_amount,ip.amount) != 0 &P_CHECK_AMOUNT_PREDICATE &P_ORDER_BY Y JE JEHUIAGE_XML US JE Hungarian Payables Invoice Aging - draft Application: European Localizations Source: Hungarian Payables Invoice Aging Report (XML) - Not Supported: Reserved For Future Use Short Name: JEHUIAGE_XML DB package: JE_JEHUIAGE_XMLP_PKG BI Publisher &p_amount_predicate &p_check_amount_predicate &p_order_by &p_select_check_number &p_vendor_predicate :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_head_format_option :c_head_invoice_type :c_head_ledger_name :c_head_legal_entity_name :c_head_sort_option :c_head_summary_option :c_head_vendor_name :c_inv_due_1_head_1 :c_inv_due_1_head_2 :c_inv_due_1_range_fr :c_inv_due_1_range_to :c_inv_due_2_head_1 :c_inv_due_2_head_2 :c_inv_due_2_range_fr :c_inv_due_2_range_to :c_inv_due_3_head_1 :c_inv_due_3_head_2 :c_inv_due_3_range_fr :c_inv_due_3_range_to :c_inv_due_4_head_1 :c_inv_due_4_head_2 :c_inv_due_4_range_fr :c_inv_due_4_range_to :c_invoice_type_select :c_maxdays :c_mindays :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_rep_data_converted :c_report_run_time :c_report_start_date :c_sum_amt_remaining :c_sum_data_converted :c_sum_inv_due_amt_1 :c_sum_inv_due_amt_2 :c_sum_inv_due_amt_3 :c_sum_inv_due_amt_4 :c_sum_v_data_converted :c_sum_v_due_remaining :c_sum_v_inv_amt_1 :c_sum_v_inv_amt_2 :c_sum_v_inv_amt_3 :c_sum_v_inv_amt_4 :c_vendor_name_select :p_amount_due_high :p_amount_due_low :p_amount_predicate :p_amt_due_high :p_amt_due_low :p_check_amount_predicate :p_conc_request_id :p_debug_switch :p_flexdata :p_format_option :p_invoice_type :p_ledger_id :p_ledger_name :p_legal_entity_id :p_legal_entity_name :p_min_precision :p_order_by :p_period_type :p_report_type :p_select_check_number :p_sort_option :p_summary_option :p_trace_switch :p_vendor_id :p_vendor_predicate :sort_by_alternate 1 10 :p_ledger_id LOV Oracle JGZZ_SRS_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers_public_v l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by name Y US Ledger 2 20 :p_legal_entity_id LOV Oracle JGZZ_LEGAL_ENTITY Y select legal_entity_id id, legal_entity_name value, null description from gl_ledger_le_v where ledger_id=:$flex$.jgzz_srs_ledger_name order by value,description US Legal Entity 3 30 :p_sort_option LOV Oracle AP_SRS_AGING_ORDER Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='AGING_SORT_OPTION' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'AGING_SORT_OPTION' and lookup_code = 'Invoice Type' Y US Sort Invoices By 4 40 :p_summary_option LOV Oracle AP_SRS_AGING_SUMMARY_OPTION Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='AGING_SUMMARY_OPTION' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'AGING_SUMMARY_OPTION' and lookup_code = 'Invoice' Y US Summary Type 5 50 :p_format_option LOV Oracle AP_SRS_AGING_FORMAT_OPTION Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='AGING_FORMAT_OPTION' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'AGING_FORMAT_OPTION' and lookup_code = 'Detailed' Y US Report Format 6 60 :p_amount_due_low Number US Minimum Amount Due 7 70 :p_amount_due_high Number US Maximum Amount Due 8 80 :p_invoice_type LOV Oracle AP_SRS_INVOICE_TYPE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='INVOICE TYPE' and lookup_code not in ('QUICKMATCH','QUICKDEFAULT') order by value,description US Invoice Type (skip for All) 9 90 :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 Trading Partner (skip for All) 10 100 :p_period_type LOV Oracle AP_SRS_AGING_PERIOD_TYPE Y select period_name id, period_name value, description description from ap_aging_periods where status='A' order by upper(period_name) Y US Aging Period Type 11 110 :p_report_type LOV Oracle JEHU_REPORT_TYPE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JEHU_REPORT_TYPE' order by value,description Y US Report Type