ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0C03869E053B46B63588994Y SELECT b.*, (b.opening_balance_qty + b.bal_qty) balance_qty FROM (SELECT a.*, decode(a.trx_flag, 'I', -1, 'R', 1, 1) * a.qty_received qty, SUM(decode(a.trx_flag, 'I', -1, 'R', 1, 1) * a.qty_received) OVER(PARTITION BY a.item_name ORDER BY a.trx_date, rownum) bal_qty FROM (SELECT c.rep_context_entity_name operating_unit, c.rep_organization_id organization_id, c.rep_organization_name organization_name, c.rep_location_id location_id, c.rep_location_name location_name, d.trx_date trx_date, d.PRODUCT_CODE item_name, d.document_type document_type, d.entity_code entity_code, d.trx_number document_number, d.trx_line_quantity qty_received, d.party_name party_name, NULL ecc_code, d.PRODUCT_CODE item_folio_no, /*Modified by Junjian for bug#19456854 begin*/ /*CASE WHEN d.applied_to_entity_code = 'BILL_OF_ENTRY' THEN d.APPLIED_TO_TRX_ID || ' ' || d.APPLIED_TO_TRX_DATE*/ /*Modified by Junjian for bug#19456854 end*/ /*END par_boe_info,*/ /*Modified by Hongjun for bug#20362697 begin*/ CASE WHEN d.applied_to_entity_code = 'BILL_OF_ENTRY' THEN d.tax_invoice_number || ' ' || d.tax_invoice_date || d.applied_to_trx_id || ' ' || d.applied_to_trx_date ELSE d.tax_invoice_number || ' ' || d.tax_invoice_date END par_boe_info, /*Modified by Hongjun for bug#20362697 end*/ d.party_name || ' ' || d.party_address party_info, --NULL input_rec_info, -- commented out by zhiwei.xin for bug#19456668 e.ATTRIBUTE3 || e.ATTRIBUTE4 INPUT_REC_INFO, -- added by zhiwei.xin for bug#19456668 d.intended_use_desc usage, NULL other_reference, e.numeric1 opening_balance_qty, decode(d.entity_code, 'SALES_ORDER_ISSUE', 'I', 'OE_ORDER_HEADERS', 'I', 'ISSUE', 'I', 'RECEIPT', 'R', 'RCV_TRANSACTION', --'R', -- commented out by zhiwei.xin for bug#19456182 decode(d.TRX_TYPE, 'RETURN TO RECEIVING', 'I', 'R'), -- added by zhiwei.xin for bug#19456182 'R') trx_flag FROM jai_rep_context_t c, jai_rep_trx_detail_t d, jai_rep_trx_jx_ext_t e WHERE c.rep_context_id = d.rep_context_id AND c.request_id = d.request_id AND c.extract_summary_code = 'H' AND d.trx_line_quantity <> 0 AND d.detail_tax_line_id = e.detail_tax_line_id AND c.request_id = :p_conc_request_id GROUP BY c.rep_context_entity_name, c.rep_organization_id, c.rep_organization_name, c.rep_location_id, c.rep_location_name, d.trx_date, d.PRODUCT_CODE, d.document_type, d.entity_code, d.trx_type, -- added by zhiwei.xin for bug#19456182 d.trx_number, d.trx_line_quantity, d.trx_line_id, d.intended_use_desc, d.party_name, d.party_address, -- added by zhiwei.xin for bug#19456668 begin e.ATTRIBUTE3, e.ATTRIBUTE4, -- added by zhiwei.xin for bug#19456668 end. d.party_site_name, /*Modified by Junjian for bug#19456854 begin*/ d.applied_to_entity_code, d.applied_to_trx_id, d.applied_to_trx_date, /*Modified by Junjian for bug#19456854 end*/ /*Modified by Hongjun for bug#20362697 begin*/ d.tax_invoice_number, d.tax_invoice_date, /*Modified by Hongjun for bug#20362697 end*/ e.numeric1) a ) b ORDER BY b.organization_id, b.location_id, b.item_name, b.trx_date JA JAINIOSR_XML US JA India - Inward Stock Register Report(XML Publisher) Application: Asia/Pacific Localizations Source: India - Inward Stock Register Report(XML Publisher) Short Name: JAINIOSR_XML DB package: JAI_EXTRACT_PKG ZHS JA 印度 - 流入库存登记报表 (XML Publisher) Application: 亚太地区本地化 Source: 印度 - 流入库存登记报表 (XML Publisher) Short Name: JAINIOSR_XML DB package: JAI_EXTRACT_PKG BI Publisher :p_accounting_status :p_all_item_stock :p_ar_exemption_status :p_balancing_segment_high :p_balancing_segment_low :p_conc_request_id :p_currency_code_high :p_currency_code_low :p_document_type :p_exemption_flag :p_exemption_number :p_exemption_type :p_form_tracking_flag :p_form_type :p_gl_date_high :p_gl_date_low :p_gl_period_name_high :p_gl_period_name_low :p_inter_state_transaction :p_item_class :p_item_id :p_item_only_flag :p_ledger_id :p_legal_entity_id :p_location_id :p_match_status :p_mtl_tran_check_flag :p_org_id :p_organization_id :p_par_registration_status :p_party_id :p_party_name :p_party_site_id :p_party_type :p_posting_status :p_product :p_proof_received_status :p_reg_reporting_context :p_register_type :p_report_name :p_reporting_context :p_reporting_level :p_repository_flag :p_rept_level :p_statistics_beginning_flag :p_statistics_so_flag :p_summary_block_type :p_summary_level :p_suppl_invoice_type_code :p_suppl_process_date_from :p_suppl_process_date_to :p_suppl_show_unraised_flag :p_suppl_trx_date_from :p_suppl_trx_date_to :p_suppl_trx_number :p_tax_account_high :p_tax_account_low :p_tax_category_id :p_tax_invoice_date_high :p_tax_invoice_date_low :p_tax_rate_code_high :p_tax_rate_code_low :p_tax_rate_id :p_tax_reg_num :p_tax_regime_code :p_tax_regime_id :p_tax_status_code :p_tax_type_code_high :p_tax_type_code_low :p_tax_type_id :p_third_party_rep_level :p_trading_flag :p_trx_date_from :p_trx_date_period_name_high :p_trx_date_period_name_low :p_trx_date_to :p_trx_id :p_trx_number_high :p_trx_number_low :p_use_parallel_hint 1 10 :p_org_id LOV Oracle JAI_MOAC_ORGANIZATIONS Y select organization_id id, name value, null description from hr_operating_units where mo_global.check_access(organization_id)='Y' order by name Y US Operating Unit ZHS 业务实体 2 20 :p_organization_id LOV Oracle JAI_INVENTORY_ORGANIZATIONS Y select organization_id id, organization_name value, null description from org_organization_definitions where operating_unit=:$flex$.jai_moac_organizations and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by value,description US Inventory Orgnization ZHS 库存组织 3 30 :p_location_id LOV Oracle JAI_LOCATIONS Y select location_id id, description value, null description from hr_locations where inventory_organization_id=:$flex$.jai_inventory_organizations order by value,description US Location ZHS 地点 4 40 :p_trx_date_from Date US Date From ZHS 日期自 5 50 :p_trx_date_to Date US Date To ZHS 日期至 6 60 :p_item_class LOV Oracle JAI_ITEM_CLASS Y select lookup_code id, lookup_code value, meaning description from ja_lookups where lookup_type='JAI_ITEM_CLASS_CD' order by meaning Y US Item Class ZHS 项目分类