ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 31BF84BD8D9C0AE9E06362FB09053934 Select J.Organization_code, J.receipt_num, J.transaction_type, J.Transaction_id, J.acct_type, decode(J.acct_nature,'MODVAT','CENVAT','CENVAT','CENVAT Adjustment',acct_nature) acct_nature, nvl(J.Entered_cr,0) Entered_cr, nvl(J.Entered_dr,0) Entered_dr, J.Period_name, J.Creation_date, J.Currency_code, nvl(J.Currency_Conversion_rate,1) Currency_Conversion_rate, S.line_num, S.Item_Description, G.Concatenated_Segments, T.Unit_of_measure UOM, T.Quantity FROM JAI_RCV_JOURNAL_ENTRIES J, RCV_TRANSACTIONS T, RCV_SHIPMENT_LINES S, GL_CODE_COMBINATIONS_KFV G, rcv_parameters rp where J.Organization_code = nvl(:p_Organization_code, J.Organization_Code) and J.receipt_num = nvl(:p_receipt_num, J.receipt_num) and S.Line_num = nvl(:p_Line_num, S.Line_num) and ( J.Acct_nature = nvl(:p_Acct_nature, J.Acct_nature) or J.Acct_nature = nvl(:P_cenvat, :P_Acct_nature) or J.Acct_nature = nvl(:P_expense, :P_Acct_nature) ) and J.Transaction_type = nvl(:p_Transaction_type, J.Transaction_type) and Trunc(J.Transaction_date) >= nvl(:p_Transaction_date_from, J.Transaction_date) and Trunc(J.Transaction_date) <= nvl(:p_Transaction_date_to, J.Transaction_date) and J.Shipment_line_id = S.Shipment_line_id and J.Code_Combination_id = G.Code_Combination_id and J.Transaction_id = T.Transaction_id and rp.organization_id = T.organization_id and J.Acct_nature not like 'Deliver%' and J.Acct_nature not like 'Average%' order by j.organization_code, decode(rp.manual_receipt_num_type, 'NUMERIC', J.receipt_num, j.receipt_num), line_num, decode(j.transaction_type, 'RECEIVE', 1, 'DELIVER', 2, 'RETURN TO RECEIVING', 3, 'RETURN TO VENDOR', 4), j.transaction_date, J.acct_type Y JA JAINRACT_XML US JA India - Receiving Accounts Imported from BI Publisher Description: India Receiving Accounts Application: Asia/Pacific Localizations Source: India - Receiving Accounts (XML) - Not Supported: Reserved For Future Use Short Name: JAINRACT_XML DB package: JA_JAINRACT_XMLP_PKG ZHS JA 印度 - 接收账户- 不支持：已保留供将来使用 (1) Imported from BI Publisher Description: 印度 - 接收账户 Application: 亚太地区本地化 Source: 印度 - 接收账户 (XML) - 不支持：已保留供将来使用 Short Name: JAINRACT_XML DB package: JA_JAINRACT_XMLP_PKG India Localization 1=1 :p_acct_nature :p_cenvat :p_conc_request_id :p_expense :p_line_num :p_organization_code :p_receipt_num :p_transaction_date_from :p_transaction_date_to :p_transaction_type 1 -10 :debugflag Char N US DebugFlag Debug Flag ZHS 调试标志 调试标志 2 10 :p_organization_code LOV Oracle JA_IN_ORGANIZATION_CODE Y select organization_code id, organization_code value, null description from org_organization_definitions order by value,description US Organization Code ORGANIZATION CODE ZHS 组织机构代码 ORGANIZATION CODE 3 20 :p_receipt_num Char US JA_IN_RECEIPT_NUM Receipt Number ZHS JA_IN_RECEIPT_NUM 接收编号 4 30 :p_line_num LOV Oracle JA_IN_LINE_NUM Y select line_num id, line_num value, null description from rcv_shipment_lines rsl,rcv_shipment_headers rsh,org_organization_definitions org where rsl.shipment_header_id=rsh.shipment_header_id and rsl.to_organization_id=org.organization_id and rsh.receipt_num=:$flex$.ja_in_receipt_num and org.organization_code=:$flex$.ja_in_organization_code order by value,description US Line Number Line Number ZHS 行号 行号 5 40 :p_acct_nature LOV Oracle JA_IN_ACCT_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=1021168 order by ffvv.flex_value US Account Type Account Type ZHS 科目类型 科目类型 6 50 :p_transaction_type LOV Oracle JA_IN_TRANSACTION_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=1021179 order by ffvv.flex_value US Transaction Type Transaction Type ZHS 事务处理类型 事务处理类型 7 60 :p_transaction_date_from Date US From Date From Date ZHS 自日期 自日期 8 70 :p_transaction_date_to Date US To Date To Date ZHS 至日期 至日期