ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704951A9E05362FB09050512 SELECT pll.ship_to_organization_id unreg_non_cg_organization_id, pll.ship_to_location_id unreg_non_cg_location_id, jitx.tax_type unreg_non_cg_tax_type, jitx.tax_rate unreg_non_cg_tax_rate, sum(jiatd.tax_amount*nvl(jiatd.exchange_rate,1)) unreg_non_cg_tax_amount, sum( decode( jitx.tax_rate ,0 , jiatd.base_amount*nvl(jiatd.exchange_rate,1) ,(jiatd.tax_amount*nvl(jiatd.exchange_rate,1) *100 )/jitx.tax_rate) ) unreg_non_cg_base_amount FROM ap_invoices_all INV, JAI_AP_MATCH_INV_TAXES JIATD, po_line_locations_all PLL, po_lines_all PL, JAI_CMN_VENDOR_SITES JIPOV, JAI_CMN_TAXES_ALL JITX WHERE jiatd.invoice_id = inv.invoice_id AND jiatd.line_location_id = pll.line_location_id AND pll.po_line_id = pl.po_line_id AND inv.vendor_id = jipov.vendor_id AND inv.vendor_site_id = jipov.vendor_site_id AND jiatd.tax_id = jitx.tax_id AND NOT EXISTS ( SELECT 1 FROM jai_rgm_item_attrib_v JRIAV WHERE jriav.inventory_item_id = pl.item_id AND jriav.organization_id = pll.ship_to_organization_id AND jriav.regime_code = 'VAT' AND jriav.attribute_code = 'ITEM CLASS' AND jriav.attribute_value = 'CG' ) AND inv.cancelled_date IS NULL AND inv.invoice_date BETWEEN :p_from_date AND :p_to_date AND jipov.vat_reg_no IS NULL &p_regime_taxes and pll.ship_to_organization_id=:organization_id and pll.ship_to_location_id=:location_id GROUP BY pll.ship_to_organization_id, pll.ship_to_location_id, jitx.tax_type, jitx.tax_rate Y JA JAINVATR_XML US JA India - VAT Returns Report(1)- Not Supported: Reserved For Future Use Imported from BI Publisher Application: Asia/Pacific Localizations Source: India - VAT Returns Report(1) (XML) - Not Supported: Reserved For Future Use Short Name: JAINVATR_XML DB package: JA_JAINVATR_XMLP_PKG ZHS JA 印度 - 增值税报税单报表 (1)- 不支持：已保留供将来使用 Imported from BI Publisher Application: 亚太地区本地化 Source: 印度 - 增值税报税单报表 (1) (XML) - 不支持：已保留供将来使用 Short Name: JAINVATR_XML DB package: JA_JAINVATR_XMLP_PKG BI Publisher &p_regime_taxes :location_id :organization_id :p_can_date_from :p_can_date_to :p_conc_request_id :p_from_date :p_locn_id :p_orgn_id :p_regime :p_regime_taxes :p_regn_no :p_to_date 1 -20 :p_regime LOV Oracle JAI_REGIMES_VAT Y select regime_id id, regime_code value, null description from jai_rgm_definitions where regime_code='VAT' order by value,description 10003 US JAI_REGIMES_VAT Regime ZHS JAI_REGIMES_VAT 制度 2 10 :p_regn_no LOV Oracle JAI_VAT_REGISTRATION_NO Y select attribute_value id, attribute_value value, null description from jai_rgm_org_regns_v where regime_id=:$flex$.jai_regimes_vat and registration_type='OTHERS' and attribute_type_code='PRIMARY' and (regime_org_id,attribute_value) in (select min(bb.regime_org_id),bb.attribute_value from jai_rgm_org_regns_v bb where regime_id=:$flex$.jai_regimes_vat and registration_type='OTHERS' and attribute_type_code='PRIMARY' group by bb.attribute_value ) order by value,description Y US Registration Number Registration Number given by authorities ZHS 登记编号 税务机关指定的登记编号 3 20 :p_orgn_id LOV Oracle JAI_VAT_ORGANIZATIONS Y select organization_id id, name value, null description from jai_rgm_vat_organizations_v where regime_id=:$flex$.jai_regimes_vat and attribute_value=:$flex$.jai_vat_registration_no order by value,description US Organization Name Organization ZHS 组织名 组织 4 30 :p_locn_id LOV Oracle JAI_VAT_LOCATIONS Y select a.location_id id, b.description value, null description from jai_rgm_organizations_v a,hr_locations b where a.location_id=b.location_id and a.organization_id=:$flex$.jai_vat_organizations and a.regime_id=:$flex$.jai_regimes_vat order by value,description US Location Name Location ZHS 地点名称 地点 5 40 :p_can_date_from Date Y US Date From From Date ZHS 日期自 自日期 6 50 :p_can_date_to Date Y US Date To To Date ZHS 日期至 至日期