ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0C73869E053B46B63588994 select rg23.organization_id, rg23.location_id, rg23.slno, vsite.document_type, rg23.excise_invoice_no, rg23.excise_invoice_date, pov.vendor_name, vsite.vendor_type, vsite.ec_code, rg23.transaction_date, rg23.cr_basic_ed, rg23.cr_other_ed, 'AED(TTA)', 'AED(GSI)', rg23.cr_additional_ed, 'OTHER',msi.description, ja_msi.item_tariff, rg23.receipt_ref receipt_id, rg23.register_id, hrl.description DESCRIPTION1, hrl.address_line_1, hrl.address_line_2, hrl.address_line_3, JA_JAINMCEN_EXC_XMLP_PKG.cf_assesablevalueformula(rg23.receipt_ref) CF_Assesablevalue, JA_JAINMCEN_EXC_XMLP_PKG.cf_qtyformulaformula(rg23.receipt_ref, rg23.register_id) CF_QTYFORMULA from JAI_CMN_RG_23AC_II_TRXS rg23, po_vendors pov, JAI_CMN_VENDOR_SITES vsite, mtl_system_items msi, JAI_INV_ITM_SETUPS ja_msi, hr_locations hrl where rg23.register_type='A' and rg23.opening_balance < rg23.closing_balance and rg23.organization_id=:P_ORGANIZATION_ID and rg23.location_id=:P_LOCATION_ID and rg23.vendor_id=pov.vendor_id and rg23.vendor_id=vsite.vendor_id and rg23.vendor_site_id = vsite.vendor_site_id and rg23.organization_id=msi.organization_id and rg23.inventory_item_id=msi.inventory_item_id and rg23.organization_id=ja_msi.organization_id and rg23.inventory_item_id=ja_msi.inventory_item_id and hrl.location_id=:P_LOCATION_ID and trunc(rg23.transaction_date) >= nvl((trunc(:P_TRN_FROM_DATE)), trunc(rg23.transaction_date)) and trunc(rg23.transaction_date) <= nvl((trunc(:P_TRN_TO_DATE)),trunc(sysdate)) order by rg23.slno asc Y JA JAINMCEN_EXC_XML US JA India - Cenvat Monthly Return Inputs-Textile - draft Application: Asia/Pacific Localizations Source: India - Cenvat Monthly Return Inputs-Textile (XML) - Not Supported: Reserved For Future Use Short Name: JAINMCEN_EXC_XML DB package: JA_JAINMCEN_EXC_XMLP_PKG ZHS JA 印度 - CENVAT 进项月报税单 - 纺织品- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - CENVAT 进项月报税单 - 纺织品 (XML) - 不支持：已保留供将来使用 Short Name: JAINMCEN_EXC_XML DB package: JA_JAINMCEN_EXC_XMLP_PKG BI Publisher :p_location_id :p_organization_id :p_trn_from_date :p_trn_to_date 1 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 ZHS 组织名 2 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 Name ZHS 地点名称 3 30 :p_trn_from_date LOV Oracle TRN_DATE_23A2 Y select transaction_date id, transaction_date value, null description from jai_cmn_rg_23ac_ii_trxs where rowid in (select min(rowid) from jai_cmn_rg_23ac_ii_trxs where organization_id=:$flex$.organization_23a2 and location_id=:$flex$.location_23a2 and register_type='A' group by trunc(transaction_date)) order by transaction_date desc US Start Date ZHS 起始日期 4 40 :p_trn_to_date LOV Oracle TRN_DATE_23A2 Y select transaction_date id, transaction_date value, null description from jai_cmn_rg_23ac_ii_trxs where rowid in (select min(rowid) from jai_cmn_rg_23ac_ii_trxs where organization_id=:$flex$.organization_23a2 and location_id=:$flex$.location_23a2 and register_type='A' group by trunc(transaction_date)) order by transaction_date desc US End Date ZHS 终止日期