ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFCD3869E053B46B63588994Y SELECT lk.meaning as line_type_dsp, item.item_number, -- fnd_date.displaydt_to_date(pnd.transaction_date) transaction_date, -- Bug 16814297 Uskumari to_char(pnd.transaction_date, 'dd-mm-yyyy hh24:mi:ss') transaction_date, -- Bug 16814297 Uskumari pnd.primary_quantity as transaction_quantity, item.primary_uom_code as transaction_uom, mp.organization_code, pnd.transaction_id, to_number(decode(pnd.source_line_id, -99, NULL, pnd.source_line_id)) reverse_id, ol.layer_id, CASE to_number(lk.lookup_code) WHEN -1 THEN 0 WHEN 0 THEN 1 WHEN 2 THEN 2 WHEN 1 THEN 3 END line_type FROM mtl_material_transactions pnd, mtl_item_flexfields item, gem_lookups lk, gmf_outgoing_material_layers ol, mtl_parameters mp WHERE pnd.transaction_source_type_id = 5 AND pnd.transaction_action_id in (1, 27) AND item.inventory_item_id = pnd.inventory_item_id AND item.organization_id = pnd.organization_id AND pnd.transaction_source_id = :P_BATCH_ID AND lk.lookup_type = 'GMD_FORMULA_ITEM_TYPE' AND lk.lookup_code = -1 AND ol.mmt_transaction_id = pnd.transaction_id AND ol.mmt_organization_id = pnd.organization_id AND mp.organization_id = pnd.organization_id UNION ALL SELECT lk.meaning as line_type_dsp, item.item_number, -- fnd_date.displaydt_to_date(pnd.transaction_date) transaction_date, -- Bug 16814297 Uskumari to_char(pnd.transaction_date, 'dd-mm-yyyy hh24:mi:ss') transaction_date, -- Bug 16814297 Uskumari pnd.primary_quantity as transaction_quantity, item.primary_uom_code as transaction_uom, mp.organization_code, pnd.transaction_id, to_number(decode(pnd.source_line_id, -99, NULL, pnd.source_line_id)) reverse_id, il.layer_id, CASE to_number(lk.lookup_code) WHEN -1 THEN 0 WHEN 0 THEN 1 WHEN 2 THEN 2 WHEN 1 THEN 3 END line_type FROM mtl_material_transactions pnd, mtl_item_flexfields item, gem_lookups lk, gmf_incoming_material_layers il, mtl_parameters mp WHERE pnd.transaction_source_type_id = 5 AND pnd.transaction_action_id in (31, 32) AND item.inventory_item_id = pnd.inventory_item_id AND item.organization_id = pnd.organization_id AND pnd.transaction_source_id = :P_BATCH_ID AND lk.lookup_type = 'GMD_FORMULA_ITEM_TYPE' AND lk.lookup_code = 1 AND il.mmt_transaction_id = pnd.transaction_id AND il.mmt_organization_id = pnd.organization_id AND mp.organization_id = pnd.organization_id --begin Bug 25364925 UNION ALL SELECT lk.meaning as line_type_dsp, item.item_number, -- fnd_date.displaydt_to_date(pnd.transaction_date) transaction_date, -- Bug 16814297 Uskumari to_char(pnd.transaction_date, 'dd-mm-yyyy hh24:mi:ss') transaction_date, -- Bug 16814297 Uskumari pnd.primary_quantity as transaction_quantity, item.primary_uom_code as transaction_uom, mp.organization_code, pnd.transaction_id, to_number(decode(pnd.source_line_id, -99, NULL, pnd.source_line_id)) reverse_id, ol.layer_id, CASE to_number(lk.lookup_code) WHEN -1 THEN 0 WHEN 0 THEN 1 WHEN 2 THEN 2 WHEN 1 THEN 3 END line_type FROM mtl_material_transactions pnd, mtl_item_flexfields item, gem_lookups lk, gmf_outgoing_material_layers ol, mtl_parameters mp WHERE pnd.transaction_source_type_id = 5 AND pnd.transaction_action_id in (31, 32) AND item.inventory_item_id = pnd.inventory_item_id AND item.organization_id = pnd.organization_id AND pnd.transaction_source_id = :P_BATCH_ID AND lk.lookup_type = 'GMD_FORMULA_ITEM_TYPE' AND lk.lookup_code = 2 AND ol.mmt_transaction_id = pnd.transaction_id AND ol.mmt_organization_id = pnd.organization_id AND mp.organization_id = pnd.organization_id --end Bug 25364925 UNION ALL SELECT 'Resource' as line_type_dsp, rt.resources, -- fnd_date.displaydt_to_date(rt.trans_date) as transaction_date, -- Bug 16814297 Uskumari to_char(rt.trans_date, 'dd-mm-yyyy hh24:mi:ss') transaction_date, -- Bug 16814297 Uskumari rt.resource_usage as trans_qty, rt.trans_qty_um, mp.organization_code, rt.poc_trans_id as transaction_id, rt.reverse_id, rl.layer_id, CASE rt.line_type WHEN -1 THEN 0 WHEN 0 THEN 1 WHEN 2 THEN 2 WHEN 1 THEN 3 END line_type FROM gme_resource_txns rt, gmf_resource_layers rl, mtl_parameters mp WHERE rt.doc_type = 'PROD' and rt.completed_ind = 1 AND rt.doc_id = :P_BATCH_ID AND rl.poc_trans_id = rt.poc_trans_id AND mp.organization_id = rt.organization_id ORDER BY transaction_date, line_type, transaction_id GMF GMFBCDR AR GMF تقرير تفاصيل تكلفة التشغيلة في GMF Application: ماليات التصنيع التشغيلي Source: تقرير تفاصيل تكلفة التشغيلة في GMF (XML) Short Name: GMFBCDR DB package: D GMF Kostendetails Produktionsauftrag Application: Process Manufacturing Financials Source: GMF Kostendetails Produktionsauftrag (XML) Short Name: GMFBCDR DB package: F GMF - Etat détaillé des coûts de batch Application: Process Manufacturing Financials Source: GMF - Etat détaillé des coûts de batch (XML) Short Name: GMFBCDR DB package: US GMF Batch Cost Details Application: Process Manufacturing Financials Source: GMF Batch Cost Details Report (XML) Short Name: GMFBCDR DB package: ZHS GMF 批成本详细信息报表 Application: OPM 财务管理系统 Source: GMF 批成本详细信息报表 (XML) Short Name: GMFBCDR DB package: BI Publisher :p_batch_id 1 10 :p_legal_entity_id LOV Oracle GMF_LEGAL_ENTITY_VS Y select gfp.legal_entity_id id, xfi.name value, null description from gmf_fiscal_policies gfp,xle_firstparty_information_v xfi where gfp.legal_entity_id=xfi.legal_entity_id order by xfi.name Y AR الكيان القانوني D Mandant F Entité juridique US Legal Entity ZHS 法人主体 2 20 :p_organization_id LOV Oracle GMF_ORGANIZATIONS Y select m.organization_id id, m.organization_code value, o.name description from mtl_parameters m,hr_all_organization_units o where m.organization_id=o.organization_id and upper(m.process_enabled_flag)='Y' and sysdate between nvl(date_from,sysdate) and nvl(date_to,sysdate) order by m.organization_code Y AR التنظيم D Organisation F Organisation US Organization ZHS 组织 3 30 :p_batch_id LOV Oracle GMF_BATCH_NO_R12 Y select bh.batch_id id, bh.batch_no value, null description from gme_batch_header bh,gem_lookups lk where bh.organization_id=:$flex$.gmf_organizations and bh.batch_type=0 and bh.batch_status<>-1 and bh.delete_mark=0 and lk.lookup_code=bh.batch_status and lk.lookup_type='GME_BATCH_STATUS' order by batch_no Y AR رقم التشغيلة D Produktionsauftrags-Nr. F Numéro de batch US Batch No ZHS 批号 4 40 :p_cost_type_id LOV Oracle GMF_COST_TYPE_SLA Y select cost_type_id id, cost_mthd_code value, cost_mthd_desc description from cm_mthd_mst where delete_mark=0 order by cost_mthd_code Y AR نوع التكلفة D Kostenrechnungsart F Type de coût US Cost Type ZHS 成本类型 :$flex$.gmf_organizations Organization Batch No