ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0B13869E053B46B63588994 select a.organization_id, a.location_id, e.organization_name, f.description, f.address_line_1, f.address_line_2, f.address_line_3, f.country, a.customer_id, a.customer_site_id, b.party_name customer_name, decode(order_flag,'Y','ORDER','N','INVOICE') trx_type, a.trx_number, a.trx_date, a.delivery_id delivery_detail_id, a.delivery_date, a.excise_exempt_type, a.excise_exempt_refno, a.excise_exempt_date, a.ar3_form_no, a.ar3_form_date, a.received_date, JA_JAINAR3R_XMLP_PKG.cf_1formula0031(a.customer_site_id) location, JA_JAINAR3R_XMLP_PKG.cf_1formula(a.trx_number, decode ( order_flag , 'Y' , 'ORDER' , 'N' , 'INVOICE' )) trx_number1, JA_JAINAR3R_XMLP_PKG.cf_delivery_idformula(a.delivery_id) CF_DELIVERY_ID, JA_JAINAR3R_XMLP_PKG.delivery_nameformula(a.delivery_id) delivery_name FROM JAI_CMN_OM_AR_AR3_FORMS a, hz_parties b, hz_cust_accounts hzca, org_organization_definitions e, hr_locations f Where a.organization_id = NVL(:p_organization_id,a.organization_id) AND a.location_id = NVL(:p_location_id,a.location_id) AND a.customer_id = NVL(:p_customer_id,a.customer_id) AND NVL(a.customer_site_id,0) = NVL(:p_customer_site_id,NVL(a.customer_site_id,0)) AND a.excise_exempt_type = NVL(:p_excise_exempt_type,a.excise_exempt_type) AND a.order_flag = decode(:p_transaction_type, 'ORDER','Y', 'INVOICE','N',a.order_flag) AND a.trx_number = NVL(:p_trx_id,NVL(:P_TRX_ID2,a.trx_number)) AND a.customer_id = hzca.cust_account_id AND b.party_id = hzca.cust_account_id AND e.organization_id = a.organization_id AND f.location_id = a.location_id &p_w_clause --Order By --a.Organization_id, a.location_id, decode(a.order_flag,'Y',1,'N',2), --a.customer_id, a.customer_site_id ORDER BY 3 ASC,4 ASC,5 ASC,6 ASC,7 ASC,8 ASC,1 ASC,2 ASC,9 ASC,11 ASC,10 ASC,12 ASC , a.Organization_id , a.location_id , decode ( a.order_flag , 'Y' , 1 , 'N' , 2 ) , a.customer_id , a.customer_site_id JA JAINAR3R_XML US JA India - AR3A Status - draft Application: Asia/Pacific Localizations Source: India - AR3A Status Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINAR3R_XML DB package: JA_JAINAR3R_XMLP_PKG ZHS JA 印度 - AR3A 状态报表- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - AR3A 状态报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINAR3R_XML DB package: JA_JAINAR3R_XMLP_PKG BI Publisher &p_w_clause :p_conc_request_id :p_customer_id :p_customer_site_id :p_excise_exempt_type :p_location_id :p_organization_id :p_status :p_transaction_type :p_trx_id :p_trx_id2 :p_w_clause 1 10 :p_organization_id LOV Oracle JA_IN_AR3_ORG Y select organization_id id, organization_name value, null description from org_organization_definitions a where exists (select 'X' from jai_cmn_om_ar_ar3_forms b where b.organization_id=a.organization_id) order by a.organization_name US Organization Name ZHS 组织名 2 20 :p_location_id LOV Oracle JA_IN_AR3_LOC Y select location_id id, description value, null description from hr_locations a where exists (select 'X' from jai_cmn_om_ar_ar3_forms b where b.organization_id=:$flex$.ja_in_ar3_org and b.location_id=a.location_id) order by a.description US Location ZHS 地点 3 30 :p_customer_id LOV Oracle JA_IN_AR3_CUSTOMER_NAME Y select hzca.cust_account_id id, hzp.party_name value, null description from hz_parties hzp,hz_cust_accounts hzca where hzp.party_id=hzca.party_id and exists (select 'X' from jai_cmn_om_ar_ar3_forms b where b.customer_id=hzca.cust_account_id) order by hzp.party_name US Customer Name ZHS 客户名称 4 40 :p_customer_site_id LOV Oracle JA_IN_AR3_CUSTOMER_SITE Y select site_use_id id, location value, null description from hz_cust_site_uses_all a where exists (select 'X' from jai_cmn_om_ar_ar3_forms b where b.customer_id=:$flex$.ja_in_ar3_customer_name and b.customer_site_id=a.site_use_id) order by a.location US Customer Site ZHS 客户地点 5 50 :p_trnasaction_type LOV Oracle JA_IN_AR3_TRX_TYPE Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021169 order by ffvv.flex_value US Transaction Type ZHS 事务处理类型 6 60 :p_trx_id LOV Oracle JAINAR3_INVOICE_NUMBER Y select customer_trx_id id, trx_number value, null description from ra_customer_trx_all a where a.customer_trx_id in (select distinct trx_number from jai_cmn_om_ar_ar3_forms b where nvl(b.order_flag,'N')='N') and :$flex$.ja_in_ar3_trx_type in ('INVOICE','BOTH') order by value,description US Invoice Number ZHS 发票编号 7 70 :p_excise_exempt_type LOV Oracle JAINAR3_EXC_EXEMPT_TYPE Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021162 order by ffvv.flex_value US Excise Exempt Type ZHS 免征消费税类型 8 80 :p_status LOV Oracle JAINAR3_STATUS Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021163 order by ffvv.flex_value US Status ZHS 状态 9 90 :p_trx_id2 LOV Oracle JAINAR3_ORDER_NUMBER Y select header_id id, order_number value, null description from oe_order_headers_all a where a.header_id in (select distinct trx_number from jai_cmn_om_ar_ar3_forms b where nvl(b.order_flag,'N')='Y') and :$flex$.ja_in_ar3_trx_type in ('ORDER','BOTH') order by value,description US Order Number ZHS 订单编号 :$flex$.ja_in_ar3_customer_name Customer Name Customer Site :$flex$.ja_in_ar3_org Organization Name Location :$flex$.ja_in_ar3_trx_type Transaction Type Invoice Number :$flex$.ja_in_ar3_trx_type Transaction Type Order Number