ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE9A3869E053B46B63588994 SELECT intb.org_id org_id, intb.interest_batch_id interest_batch_id, intb.batch_name batch_name, ou.name ou_name, -- start for bug 26500596 by sunagesh --intb.calculate_interest_to_date charge_as_of_date, FND_DATE.DATE_TO_CHARDATE(intb.calculate_interest_to_date) charge_as_of_date, -- end for bug 26500596 by sunagesh pty.party_id party_id, pty.party_name party_name, ac.account_number account_number, inth.customer_id account_id, inth.customer_site_use_id bill_to_id, loc.address1 address1, loc.address2 address2, decode(acs.cust_acct_site_id, NULL, NULL, arh_addr_pkg.format_last_address_line(loc.address_style, loc.address3, loc.address4, loc.city, loc.county, loc.state, loc.province, terr.territory_short_name, loc.postal_code)) address3, inth.currency_code currency_code, inth.interest_header_id interest_header_id, inth.header_type header_type, trx.trx_number invoice_number, FND_DATE.DATE_TO_CHARDATE(trx.trx_date) invoice_date, -inth.interest_header_id interest_line_id FROM ar_interest_batches intb, ar_interest_headers inth, hz_parties pty, hz_cust_accounts ac, hz_cust_acct_sites acs, hz_cust_site_uses_all su, hz_locations loc, hz_party_sites ps, fnd_territories_vl terr, ra_customer_trx trx, hr_all_organization_units_tl ou WHERE intb.interest_batch_id = inth.interest_batch_id AND pty.party_id = ac.party_id AND inth.customer_id = ac.cust_account_id AND inth.customer_site_use_id = su.site_use_id AND su.cust_acct_site_id = acs.cust_acct_site_id AND acs.party_site_id = ps.party_site_id AND ps.location_id = loc.location_id AND loc.country = terr.territory_code(+) AND ou.organization_id = intb.org_id AND ou.LANGUAGE = userenv('LANG') AND inth.display_flag = 'Y' ANd intb.batch_status in ( 'F','D') ANd intb.transferred_status = decode(intb.batch_status ,'F','S',intb.transferred_status) ANd trx.interest_header_id(+) = inth.interest_header_id AND inth.interest_header_id = :int_header_id AND inth.header_type IN ( 'INV','DM') &P_QUERY_WHERE UNION ALL SELECT intb.org_id org_id, intb.interest_batch_id interest_batch_id, intb.batch_name batch_name, ou.name ou_name, -- start for bug 26500596 by sunagesh --intb.calculate_interest_to_date charge_as_of_date, FND_DATE.DATE_TO_CHARDATE(intb.calculate_interest_to_date) charge_as_of_date, -- end for bug 26500596 by sunagesh pty.party_id party_id, pty.party_name party_name, ac.account_number account_number, inth.customer_id account_id, inth.customer_site_use_id bill_to_id, loc.address1 address1, loc.address2 address2, decode(acs.cust_acct_site_id, NULL, NULL, arh_addr_pkg.format_last_address_line(loc.address_style, loc.address3, loc.address4, loc.city, loc.county, loc.state, loc.province, terr.territory_short_name, loc.postal_code)) address3, inth.currency_code currency_code, inth.interest_header_id interest_header_id, inth.header_type header_type, adj.adjustment_number invoice_number, FND_DATE.DATE_TO_CHARDATE(adj.apply_date) invoice_date, intl.interest_line_id interest_line_id FROM ar_interest_batches intb, ar_interest_lines intl, ar_interest_headers inth, hz_parties pty, hz_cust_accounts ac, hz_cust_acct_sites acs, hz_cust_site_uses_all su, hz_locations loc, hz_party_sites ps, fnd_territories_vl terr, ar_adjustments adj, hr_all_organization_units_tl ou WHERE intb.interest_batch_id = inth.interest_batch_id AND pty.party_id = ac.party_id AND inth.customer_id = ac.cust_account_id AND inth.customer_site_use_id = su.site_use_id AND su.cust_acct_site_id = acs.cust_acct_site_id AND acs.party_site_id = ps.party_site_id AND ps.location_id = loc.location_id AND loc.country = terr.territory_code(+) AND ou.organization_id = intb.org_id AND ou.LANGUAGE = userenv('LANG') AND inth.display_flag = 'Y' ANd intb.batch_status in ('F','D') AND inth.interest_header_id=intl.interest_header_id ANd intb.transferred_status = decode(intb.batch_status ,'F','S',intb.transferred_status) ANd adj.interest_line_id(+) = intl.interest_line_id AND inth.interest_header_id = :int_header_id AND inth.header_type IN ( 'ADJ') &P_QUERY_WHERE Y AR ARLCRPT AR AR تقرير المصروفات المتأخرة Application: المقبوضات Source: تقرير المصروفات المتأخرة Short Name: ARLCRPT DB package: AR_LATE_CHARGES_REPORT_PVT D AR Verzugsgebühren Application: Debitoren Source: Verzugsgebühren Short Name: ARLCRPT DB package: AR_LATE_CHARGES_REPORT_PVT F AR Etat des pénalités de retard Application: Receivables Source: Etat des pénalités de retard Short Name: ARLCRPT DB package: AR_LATE_CHARGES_REPORT_PVT US AR Late Charges Application: Receivables Source: Late Charges Report Short Name: ARLCRPT DB package: AR_LATE_CHARGES_REPORT_PVT ZHS AR 滞纳费用报表 Application: 应收帐款 Source: 滞纳费用报表 Short Name: ARLCRPT DB package: AR_LATE_CHARGES_REPORT_PVT BI Publisher &p_query_where :int_header_id :p_batch_name_dsp :p_interest_batch_id :p_query_where :p_request_id 1 10 :p_interest_batch_id LOV Oracle AR_INTEREST_BATCH_ID Y select intb.interest_batch_id id, intb.batch_name value, null description from ar_interest_batches intb,hr_operating_units ou,ar_lookups lkp where intb.org_id=ou.organization_id and mo_global.check_access(organization_id)='Y' and intb.batch_status=lkp.lookup_code and lkp.lookup_type='AR_RUN_TYPE' order by intb.batch_name Y AR اسم المجموعة D Stapelbezeichnung F Nom du lot US Batch Name ZHS 批名