ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0C93869E053B46B63588994 SELECT a.invoice_id invoice_id1, a.invoice_num,a.INVOICE_CURRENCY_CODE, a.invoice_amount, a.vendor_id vendor_id1, a.vendor_site_id vendor_site_id1, b.invoice_id parent_invoice_id, a.description, JA_JAINOTDS_XMLP_PKG.cf_vendor_name1formula(a.vendor_id, :VENDOR_ID, :CF_Vendor_Name) CF_vendor_name1, JA_JAINOTDS_XMLP_PKG.cf_vendor_site_1formula(a.vendor_site_id, :VENDOR_SITE_ID, :CF_Vendor_site) CF_Vendor_site_1, JA_JAINOTDS_XMLP_PKG.cf_tds_sectionformula(a.vendor_id, :VENDOR_ID, :INVOICE_ID, a.invoice_num) CF_TDS_SECTION, JA_JAINOTDS_XMLP_PKG.cf_tds_tax_rateformula(a.vendor_id, :VENDOR_ID, :INVOICE_ID, a.invoice_num) CF_TDS_TAX_RATE, JA_JAINOTDS_XMLP_PKG.cf_tax_nameformula(a.vendor_id, :VENDOR_ID, :INVOICE_ID, a.invoice_num) CF_TAX_NAME FROM ap_invoices_all A,jai_ap_tds_thhold_trxs B WHERE (a.invoice_id = b.invoice_to_vendor_id OR a.invoice_id = b.invoice_to_tds_authority_id ) and b.invoice_id=:invoice_id Y JA JAINOTDS_XML US JA India - TDS Related Invoices - draft Application: Asia/Pacific Localizations Source: India - TDS Related Invoices (XML) - Not Supported: Reserved For Future Use Short Name: JAINOTDS_XML DB package: JA_JAINOTDS_XMLP_PKG ZHS JA 印度 - TDS 相关发票- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - TDS 相关发票 (XML) - 不支持：已保留供将来使用 Short Name: JAINOTDS_XML DB package: JA_JAINOTDS_XMLP_PKG BI Publisher :cf_vendor_name :cf_vendor_site :invoice_id :p_conc_request_id :p_from_date :p_from_date_1 :p_org_id :p_to_date :p_to_date_1 :vendor_id :vendor_site_id 1 10 :p_org_id LOV Oracle JA_IN_ORGANIZATION_TDS Y select organization_id id, name value, null description from hr_operating_units where mo_global.check_access(organization_id)='Y' order by value,description Y US Operating Unit ZHS 业务实体 2 20 :p_from_date Date Y US From Date ZHS 自日期 3 30 :p_to_date Date Y US To Date ZHS 至日期