ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4708351A9E05362FB09050512 select substr(p.VENDOR_NAME,1,80) VENDOR_NAME, p.SEGMENT1 VENDOR_NUMBER from po_vendor_sites ps, po_vendors p, ap_invoice_distributions id, ap_invoices i, zx_rates_b tc, zx_party_tax_profile ptp where upper(tc.tax_rate_code) != 'EXEMPT' and upper(tc.tax_rate_code) not like 'ND%' and id.posted_flag = 'Y' and upper(id.line_type_lookup_code) != 'AWT' and ( upper(p.vendor_type_lookup_code) != 'EMPLOYEE' or p.vendor_type_lookup_code is NULL ) and p.num_1099 is NULL and p.vendor_id = i.vendor_id and id.invoice_id = i.invoice_id and ps.vendor_id = p.vendor_id and id.tax_code_id = tc.tax_rate_id (+) and ptp.party_id = i.org_id and ptp.PARTY_TAX_PROFILE_ID = tc.content_owner_id and ptp.party_type_code = 'OU' and i.legal_entity_id = :P_LEGAL_ENTITY_ID and i.set_of_books_id = nvl(:P_SET_OF_BOOKS_ID,i.set_of_books_id) and (:P_BALANCING_SEGMENT IS NULL OR (:P_BALANCING_SEGMENT IS NOT NULL AND EXISTS (SELECT 1 FROM GL_CODE_COMBINATIONS WHERE code_combination_id = id.dist_code_combination_id AND chart_of_accounts_id = :P_CHART_OF_ACCT AND &P_BAL_SEG_NAME))) group by p.SEGMENT1, p.VENDOR_NAME order by p.VENDOR_NAME, p.SEGMENT1 Y JE JEPTAPER_XML US JE Portuguese Payables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Portuguese Payables Taxpayer ID Exception Report Application: European Localizations Source: Portuguese Payables Taxpayer ID Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: JEPTAPER_XML DB package: JE_JEPTAPER_XMLP_PKG BI Publisher &p_bal_seg_name :c_vat_country_code :p_bal_seg_name :p_balancing_segment :p_chart_of_acct :p_conc_request_id :p_legal_entity_id :p_set_of_books_id :place_coa_id :place_funct_curr :place_rep_title :place_sob_name 1 -30 :p_chart_of_acct LOV Oracle JG_ZZ_VAT_COA_ID Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_sets_of_books where set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description select chart_of_accounts_id from GL_LEDGERS WHERE LEDGER_ID =:$flex$.ledger US Chart of Account Chart of Account ID 2 -20 :p_value_set Number SELECT s.FLEX_VALUE_SET_ID FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav, fnd_segment_attribute_types sat WHERE s.application_id = 101 AND s.id_flex_code = 'GL#' AND s.id_flex_num = :$flex$.chart_of_account AND s.enabled_flag = 'Y' AND s.application_column_name = sav.application_column_name AND sav.application_id = 101 AND sav.id_flex_code = 'GL#' AND sav.id_flex_num = :$flex$.chart_of_account AND sav.attribute_value = 'Y' AND sav.segment_attribute_type = sat.segment_attribute_type AND sat.application_id = 101 AND sat.id_flex_code = 'GL#' AND sat.unique_flag = 'Y' AND sat.segment_attribute_type = 'GL_BALANCING' US FND_NUMBER Dummy 3 10 :p_legal_entity_id LOV Oracle XLE_FIRSTPARTY Y select legal_entity_id id, name value, legal_entity_identifier description from xle_entity_profiles where transacting_entity_flag='Y' order by value,description Y US Legal Entity Legal Entity ID 4 20 :p_set_of_books_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 US Ledger Ledger ID 5 30 :p_balancing_segment LOV Oracle JE_ZZ_VAT_BALANCING_SEGMENT Y select flex_value id, flex_value value, null description from fnd_flex_values_vl where flex_value_set_id=:$flex$.fnd_number and nvl(enabled_flag,'N')='Y' and nvl(summary_flag,'N')='N' and trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate)) order by flex_value US Balancing Segment Balancing Segment Value