ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4704251A9E05362FB09050512 SELECT a.reference_num, a.excise_invoice_no, a.excise_invoice_date, a.vendor_id, pov.vendor_name, a.vendor_site_id, povs.vendor_site_code, jpovs.ec_code, rt.quantity, rt.unit_of_measure, rsh.receipt_num, NVL(b.cenvat_amount, 0) Duty_Payable, NVL(b.other_cenvat_amt,0) Cess_Payable, b.cenvat_claimed_ptg, NVL(a.cr_basic_ed, 0) + NVL(a.cr_additional_ed, 0) + NVL(a.cr_other_ed, 0) cenvat_credit_taken, NVL(a.cr_additional_cvd,0) additional_cvd, a.transaction_date, TO_NUMBER(a.receipt_ref) receipt_id, NVL(cenvat_amount, 0) - NVL(cenvat_claimed_amt, 0) balance_credit, NVL(b.other_cenvat_amt,0) - NVL(b.other_cenvat_claimed_amt,0) Balance_Cess, a.organization_id, a.location_id, mtl_sys.description, a.slno, org.organization_name, loc.location_code, a.register_id, b.transaction_id transaction_id, JA_JAINCVAT_XMLP_PKG.cf_cenvat_credit_takenformula(a.register_id, a.excise_invoice_no, NVL ( a.cr_basic_ed , 0 ) + NVL ( a.cr_additional_ed , 0 ) + NVL ( a.cr_other_ed , 0 ), NVL ( a.cr_additional_cvd , 0 ), NVL ( cenvat_amount , 0 ) - NVL ( cenvat_claimed_amt , 0 )) CF_CENVAT_CREDIT_TAKEN, JA_JAINCVAT_XMLP_PKG.cf_percentformula(NVL ( a.cr_basic_ed , 0 ) + NVL ( a.cr_additional_ed , 0 ) + NVL ( a.cr_other_ed , 0 ), NVL ( b.cenvat_amount , 0 )) CF_percent, JA_JAINCVAT_XMLP_PKG.cf_cessformula(a.register_id, a.excise_invoice_no, NVL ( b.other_cenvat_amt , 0 ) - NVL ( b.other_cenvat_claimed_amt , 0 )) CF_Cess_Credit_Taken, JA_JAINCVAT_XMLP_PKG.cf_sh_cess_credit_takenformula(a.register_id, a.excise_invoice_no) CF_sh_cess_credit_taken, JA_JAINCVAT_XMLP_PKG.cf_quantityformula(b.transaction_id, rt.quantity, a.reference_num, NVL ( b.cenvat_amount , 0 ), :CF_CENVAT_CREDIT_TAKEN, JA_JAINCVAT_XMLP_PKG.cf_cessformula(a.register_id, a.excise_invoice_no, NVL ( b.other_cenvat_amt , 0 ) - NVL ( b.other_cenvat_claimed_amt , 0 )), JA_JAINCVAT_XMLP_PKG.cf_sh_cess_credit_takenformula(a.register_id, a.excise_invoice_no)) CF_QUANTITY, JA_JAINCVAT_XMLP_PKG.cp_cenvat_credit_taken_p cp_cenvat_credit_taken, JA_JAINCVAT_XMLP_PKG.cp_duty_payable_p cp_duty_payable, JA_JAINCVAT_XMLP_PKG.CP_Balance_Cess_p CP_Balance_Cess, JA_JAINCVAT_XMLP_PKG.CP_Balance_Credit_p CP_Balance_Credit, JA_JAINCVAT_XMLP_PKG.CP_balance_sh_cess_p CP_balance_sh_cess, JA_JAINCVAT_XMLP_PKG.CP_additional_cvd_p CP_additional_cvd, JA_JAINCVAT_XMLP_PKG.cp_cess_payable_p cp_cess_payable, JA_JAINCVAT_XMLP_PKG.CP_sh_cess_payable_p CP_sh_cess_payable, JA_JAINCVAT_XMLP_PKG.cp_cess_credit_taken_p cp_cess_credit_taken, JA_JAINCVAT_XMLP_PKG.CP_sh_cess_credit_taken_p CP_sh_cess_credit_taken FROM JAI_CMN_RG_23AC_II_TRXS a, JAI_RCV_CENVAT_CLAIMS b, rcv_transactions rt, rcv_shipment_headers rsh, JAI_INV_ITM_SETUPS c, po_vendors pov, po_vendor_sites_all povs, JAI_CMN_VENDOR_SITES jpovs, mtl_system_items mtl_sys, org_organization_definitions org, hr_locations loc WHERE TO_NUMBER(a.receipt_ref) = b.transaction_id AND b.transaction_id = rt.transaction_id AND rt.shipment_header_id = rsh.shipment_header_id AND a.organization_id = c.organization_id AND a.inventory_item_id = c.inventory_item_id AND a.vendor_id = pov.vendor_id AND a.vendor_site_id = povs.vendor_site_id AND (povs.org_id = :p_org_id OR povs.org_id IS NULL) AND jpovs.vendor_id = pov.vendor_id AND jpovs.vendor_site_id = povs.vendor_site_id AND mtl_sys.inventory_item_id = a.inventory_item_id AND mtl_sys.organization_id = a.organization_id AND org.organization_id = a.organization_id AND loc.location_id = a.location_id AND a.organization_id = NVL(:p_organization_id, a.organization_id) AND a.location_id = NVL(:p_location_id, a.location_id) AND b.cenvat_claimed_ptg < 100 AND c.modvat_flag = 'Y' AND TRUNC(a.transaction_date) <= (NVL(TRUNC(:p_post_thru_date), TRUNC(a.transaction_date))) ORDER BY rsh.receipt_num, a.slno Y JA JAINCVAT_XML US JA India - Cenvat Recovery(On Capital Goods) Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Cenvat Report - India Local Application: Asia/Pacific Localizations Source: India - Cenvat Recovery(On Capital Goods) Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINCVAT_XML DB package: JA_JAINCVAT_XMLP_PKG ZHS JA 印度 - CENVAT 退税（资本货物）报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: CENVAT 报表 - 印度本地化 Application: 亚太地区本地化 Source: 印度 - CENVAT 退税（资本货物）报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINCVAT_XML DB package: JA_JAINCVAT_XMLP_PKG BI Publisher :cf_cenvat_credit_taken :cp_additional_cvd :cp_balance_cess :cp_balance_credit :cp_balance_sh_cess :cp_cenvat_credit_taken :cp_cess_credit_taken :cp_cess_payable :cp_duty_payable :cp_sh_cess_credit_taken :cp_sh_cess_payable :operating_unit :p_conc_request_id :p_from_date :p_location_id :p_org_id :p_organization_id :p_post_thru_date :p_to_date 1 -20 :p_org_id Number select mo_global.get_current_org_id from dual US Org ID Operating Unit ZHS 组织标识 业务实体 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_organization_id LOV Oracle ORGANIZATION_23A2 Y select a.organization_id id, a.organization_name value, null description from org_organization_definitions a where exists (select 'X' from jai_cmn_rg_23ac_ii_trxs b where b.organization_id=a.organization_id) order by a.organization_name US Organization Name Inventory Organization ZHS 组织名 库存组织 4 20 :p_location_id LOV Oracle LOCATION_23A2 Y select a.location_id id, a.description value, null description from hr_locations a where exists (select 'X' from jai_cmn_rg_23ac_ii_trxs b where b.organization_id=:$flex$.organization_23a2 and b.location_id=a.location_id) order by a.description US Location ZHS 地点 5 30 :p_post_thru_date Date US As Of Date ZHS 截止日期