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）限制的操作单元。 C6E085D4703E51A9E05362FB09050512 SELECT jihou.excise_duty_region region, jihou.excise_duty_reg_no registration_no, jihou.excise_duty_range range, jihou.excise_duty_comm commissionerate, jihou.excise_duty_division division, sum(jispl.quantity) quantity, jispl.organization_id organization_id, jispl.location_id location_id, jispl.delivery_id delivery_id, ract.trx_number trx_number, nvl(ract.ship_to_site_use_id, BILL_TO_SITE_USE_ID) ship_to_site_use_id, deliveries.customer_trx_id customer_trx_id, wdd.source_header_id order_header_id, wdd.source_line_id order_line_id, wdd.requested_quantity_uom requested_quantity_uom, sum(wdd.gross_weight) gross_weight, sum(wdd.net_weight) net_weight, wdd.item_description item_description, wdd.inventory_item_id inventory_item_id, reg_h.register_id register_id, JA_JAINARE1_XMLP_PKG.cf_cityformula() CF_CITY, JA_JAINARE1_XMLP_PKG.cf_legal_entityformula() CF_LEGAL_ENTITY, JA_JAINARE1_XMLP_PKG.cf_destination_countryformula(nvl ( ract.ship_to_site_use_id , BILL_TO_SITE_USE_ID )) CF_DESTINATION_COUNTRY, JA_JAINARE1_XMLP_PKG.cf_balancesformula(wdd.source_header_id, reg_h.register_id, wdd.source_line_id, deliveries.customer_trx_id, jispl.delivery_id, ract.trx_number) CF_BALANCES, JA_JAINARE1_XMLP_PKG.CP_CLOSING_BAL_p CP_CLOSING_BAL, JA_JAINARE1_XMLP_PKG.CP_DEBIT_AMOUNT_p CP_DEBIT_AMOUNT, JA_JAINARE1_XMLP_PKG.CP_OPENING_BAL_p CP_OPENING_BAL, JA_JAINARE1_XMLP_PKG.cf_qty_of_goodsformula(sum ( jispl.quantity ), wdd.requested_quantity_uom) CF_QTY_OF_GOODS, JA_JAINARE1_XMLP_PKG.cf_tax_rateformula(jispl.delivery_id, wdd.inventory_item_id) CF_TAX_RATE, JA_JAINARE1_XMLP_PKG.cf_valueformula(jispl.delivery_id, wdd.source_header_id, wdd.source_line_id, sum ( jispl.quantity ), :CF_SET_OF_BOOKS_ID, :CF_FUN_CURR) CF_VALUE, JA_JAINARE1_XMLP_PKG.cf_func_tax_amountformula(jispl.delivery_id, wdd.inventory_item_id) CF_FUNC_TAX_AMOUNT, JA_JAINARE1_XMLP_PKG.CP_NULL_p CP_NULL, JA_JAINARE1_XMLP_PKG.CP_EXCISE_CESS_AMOUNT_p CP_EXCISE_CESS_AMOUNT, JA_JAINARE1_XMLP_PKG.CP_EXCISE_SH_CESS_AMOUNT_p CP_EXCISE_SH_CESS_AMOUNT FROM JAI_CMN_INVENTORY_ORGS jihou, wsh_delivery_details wdd, ra_customer_trx_all ract, JAI_AR_TRXS jract, JAI_OM_WSH_LINES_ALL jispl, wsh_new_deliveries wnd , (select distinct customer_trx_id, interface_line_attribute3 delivery_name from ra_customer_trx_lines_all where customer_trx_id BETWEEN :p_customer_trx_id AND :p_customer_trx_id1 and interface_line_context = 'ORDER ENTRY' and line_type = 'LINE') deliveries, JAI_OM_OE_BOND_REG_HDRS reg_h, JAI_OM_OE_BOND_TRXS reg_d WHERE wdd.delivery_detail_id = jispl.delivery_detail_id AND wdd.organization_id = jispl.organization_id AND wnd.name = deliveries.delivery_name AND to_char( jispl.delivery_id ) = wnd.delivery_id AND reg_h.register_code = 'BOND_REG' AND reg_h.register_id = reg_d.register_id AND reg_d.order_header_id = jispl.order_header_id AND reg_d.order_flag = 'Y' AND reg_h.organization_id = jispl.organization_id AND reg_h.location_id = jispl.location_id AND jract.customer_trx_id = ract.customer_trx_id AND jihou.organization_id = jract.organization_id AND jihou.location_id = jract.location_id AND ract.customer_trx_id = deliveries.customer_trx_id AND ract.customer_trx_id BETWEEN :p_customer_trx_id AND :p_customer_trx_id1 AND ract.org_id = :p_org_id AND ract.interface_header_context = 'ORDER ENTRY' GROUP BY jihou.excise_duty_region , jihou.excise_duty_reg_no , jihou.excise_duty_range , jihou.excise_duty_comm , jihou.excise_duty_division , jispl.organization_id , jispl.location_id , jispl.delivery_id , ract.trx_number , nvl(ract.ship_to_site_use_id, BILL_TO_SITE_USE_ID) , deliveries.customer_trx_id , wdd.source_header_id , wdd.source_line_id , wdd.requested_quantity_uom , wdd.item_description , wdd.inventory_item_id , reg_h.register_id ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,8 ASC,7 ASC,12 ASC,10 ASC Y JA JAINARE1_XML US JA India - ARE1 Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Report Generation for Bond Register related Invoices Application: Asia/Pacific Localizations Source: India - ARE1 Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINARE1_XML DB package: JA_JAINARE1_XMLP_PKG ZHS JA 印度 - ARE1 报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 生成保税登记表相关发票的报表 Application: 亚太地区本地化 Source: 印度 - ARE1 报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINARE1_XML DB package: JA_JAINARE1_XMLP_PKG BI Publisher :cf_fun_curr :cf_set_of_books_id :cp_closing_bal :cp_debit_amount :cp_excise_cess_amount :cp_excise_sh_cess_amount :cp_null :cp_opening_bal :operating_unit :p_bond_date :p_bond_no :p_conc_request_id :p_customer_trx_id :p_customer_trx_id1 :p_ex_auth_address :p_ex_postal_address :p_location_id :p_org_id :p_organization_id :p_sup_ex_address 1 -20 :p_org_id Number select mo_global.get_current_org_id from dual US P_ORG_ID Operating Unit ZHS P_ORG_ID 业务实体 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 JA_IN_ORGANIZATION_NAME Y select hr.organization_id id, hr.organization_name value, null description from org_organization_definitions hr where exists (select 'X' from jai_cmn_inventory_orgs ja where hr.organization_id=ja.organization_id) order by value,description Y US Organization Organization Id from where shipment is made ZHS 组织 发运时使用的组织标识 4 20 :p_customer_trx_id LOV Oracle JAINARE1_CUSTOMER_TRX_ID Y select ra.customer_trx_id id, ra.trx_number value, ra.customer_trx_id description from ra_customer_trx_all ra where rowid in (select ract.rowid from ra_customer_trx_all ract, jai_om_wsh_lines_all jispl, wsh_new_deliveries wnd, (select distinct customer_trx_id, interface_line_attribute3 delivery_name from ra_customer_trx_lines_all where interface_line_context='ORDER ENTRY' and line_type='LINE' and interface_line_attribute10=:$flex$.ja_in_organization_name ) deliveries, jai_om_oe_bond_reg_hdrs reg_h, jai_om_oe_bond_reg_dtls reg_d where ract.customer_trx_id=deliveries.customer_trx_id and reg_h.register_id=reg_d.register_id and reg_h.organization_id=jispl.organization_id and reg_h.location_id=jispl.location_id and reg_d.order_type_id=jispl.order_type_id and to_char(jispl.delivery_id)=wnd.delivery_id and deliveries.delivery_name=wnd.name and ract.interface_header_context='ORDER ENTRY' and reg_h.register_code='BOND_REG' and reg_d.order_flag='Y' ) order by trx_number Y US Invoice From Transaction id corresponding to Transaction number ZHS 发票自 与事务处理编号对应的事务处理标识 5 30 :p_customer_trx_id1 LOV Oracle JAINARE1_CUSTOMER_TRX_ID Y select ra.customer_trx_id id, ra.trx_number value, ra.customer_trx_id description from ra_customer_trx_all ra where rowid in (select ract.rowid from ra_customer_trx_all ract, jai_om_wsh_lines_all jispl, wsh_new_deliveries wnd, (select distinct customer_trx_id, interface_line_attribute3 delivery_name from ra_customer_trx_lines_all where interface_line_context='ORDER ENTRY' and line_type='LINE' and interface_line_attribute10=:$flex$.ja_in_organization_name ) deliveries, jai_om_oe_bond_reg_hdrs reg_h, jai_om_oe_bond_reg_dtls reg_d where ract.customer_trx_id=deliveries.customer_trx_id and reg_h.register_id=reg_d.register_id and reg_h.organization_id=jispl.organization_id and reg_h.location_id=jispl.location_id and reg_d.order_type_id=jispl.order_type_id and to_char(jispl.delivery_id)=wnd.delivery_id and deliveries.delivery_name=wnd.name and ract.interface_header_context='ORDER ENTRY' and reg_h.register_code='BOND_REG' and reg_d.order_flag='Y' ) order by trx_number Y US Invoice To to Invoice number ZHS 发票至 至发票编号 6 40 :p_ex_auth_address Char US Excise Office Address Address that will be used for excise office ZHS 税务局地址 税务局的地址 7 50 :p_sup_ex_address Char US Superintendant Address Superintendant of central excise address ZHS 监管员地址 中央税务局监管员的地址 8 60 :p_ex_postal_address Char US Excise postal address Postal address of central excise ZHS 税务局邮政地址 中央税务局的邮政地址 9 70 :p_bond_no Char US Bond/Undertaking No. Bond or the Undertaking no ZHS 保税单/申报单编号 保税单或申报单编号 10 80 :p_bond_date Date US Bond Date Bond Date ZHS 保税单日期 保税单日期