ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4708551A9E05362FB09050512 select distinct hp.PARTY_NAME , hp.PARTY_NUMBER from ra_cust_trx_line_gl_dist_all d, ra_customer_trx_lines_all l, ra_customer_trx_all t, hz_parties hp, hz_cust_accounts_all hca, ra_cust_trx_types_all rtt, zx_party_tax_profile ptp, zx_rates_b tax where (d.gl_posted_date is not null OR rtt.post_to_gl = 'N') and upper(rtt.type) in ('INV','CM','DM') and hca.party_id = hp.party_id and t.complete_flag = 'Y' and d.customer_trx_line_id = l.customer_trx_line_id and l.customer_trx_id = t.customer_trx_id and t.bill_to_customer_id = hca.cust_account_id and rtt.cust_trx_type_id = t.cust_trx_type_id and nvl(upper(substr(tax.tax_rate_code,1,2)),'EX') not in ('ND','EX') and l.vat_tax_id = tax.tax_rate_id (+) and ptp.PARTY_TAX_PROFILE_ID = tax.content_owner_id and ptp.party_type_code = 'OU' and ptp.party_id = t.org_id and t.legal_entity_id = :P_LEGAL_ENTITY_ID and t.set_of_books_id = nvl(:P_SET_OF_BOOKS_ID,t.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 = d.code_combination_id AND chart_of_accounts_id = :P_CHART_OF_ACCT AND &P_BAL_SEG_NAME))) and not exists (select 'X' from ra_customer_trx_lines tl, zx_party_tax_profile ptp, zx_rates_b tax1 where tl.vat_tax_id = tax1.tax_rate_id (+) and ptp.PARTY_TAX_PROFILE_ID = tax1.content_owner_id and ptp.party_type_code = 'OU' and ptp.party_id = tl.org_id and tl.line_type = 'TAX' and nvl(upper(substr(tax1.tax_rate_code,1,2)),'EX') in ('ND','EX') and l.customer_trx_line_id = tl.link_to_cust_trx_line_id and tl.customer_trx_id = l.customer_trx_id and not exists (select 'X' from ra_customer_trx_lines tl1, zx_party_tax_profile ptp, zx_rates_b tax2 where tl1.vat_tax_id = tax2.tax_rate_id (+) and ptp.PARTY_TAX_PROFILE_ID = tax2.content_owner_id and ptp.party_type_code = 'OU' and ptp.party_id = tl1.org_id and tl1.line_type = 'TAX' and nvl(upper(substr(tax2.tax_rate_code,1,2)) ,'EX') not in ('ND','EX') and l.customer_trx_line_id = tl1.link_to_cust_trx_line_id and tl1.customer_trx_id = l.customer_trx_id)) and hp.jgzz_fiscal_code is null group by hp.party_name, hp.party_number order by hp.party_name, hp.party_number Y JE JEPTARER_XML US JE Portuguese Receivables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Receivables Taxpayer ID Exception Report Application: European Localizations Source: Portuguese Receivables Taxpayer ID Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: JEPTARER_XML DB package: JE_JEPTARER_XMLP_PKG BI Publisher &p_bal_seg_name :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