ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 AF56F12C0F19302DE0530100007FCC69 select distinct item, (select mp.organization_code from mtl_parameters mp where x.organization_id=mp.organization_id) organization_code, item_cost, formula_no, formula_version, --plan_qty, actual_qty, std_qty, actual_qty-std_qty diff_qty, item_cost *(actual_qty-std_qty) variance_value, batch_no, xxen_util.meaning(x.line_type,'LINE_TYPE',555), --wip_plan_qty, dtl_um, --material_requirement_date, subinventory, locator_id, contribute_yield_ind, scale_type, scrap_factor, --line_type, contribute_step_qty_ind, batch_no, batch_status, actual_start_date, actual_completion_date, batch_close_date, plan_start_date, plan_cmplt_date, transaction_date, mmt_transaction_type from ( select distinct (select segment1 from mtl_system_items_b msib where msib.inventory_item_id=gmd.inventory_item_id and rownum<2) item, a.item_cost, ffm.formula_id, gbh.batch_id, ffm.formula_no formula_no, ffm.formula_vers formula_version, gmd.plan_qty plan_qty, gmd.actual_qty actual_qty, round(nvl((select (select gmd.actual_qty/fmd.qty from fm_matl_dtl fmd, gme_material_details gmd where fmd.formulaline_id=gmd.formulaline_id and fmd.formula_id=ffm.formula_id and fmd.line_type=1 and gmd.batch_id=gbh.batch_id) * qty std_qty from fm_matl_dtl where formula_id=ffm.formula_id and formulaline_id=gmd.formulaline_id),0),4) + round(nvl((select (select gmd.actual_qty/fmd.qty from fm_matl_dtl fmd, gme_material_details gmd where fmd.formulaline_id=gmd.formulaline_id and fmd.formula_id=ffm.formula_id and fmd.line_type=1 and gmd.batch_id=gbh.batch_id) * qty std_qty from fm_matl_dtl where formula_id=ffm.formula_id and formulaline_id=gmd.formulaline_id),0),4) *(gmd.scrap_factor) std_qty, gmd.wip_plan_qty wip_plan_qty, gmd.dtl_um dtl_um, gmd.material_requirement_date material_requirement_date, gmd.subinventory subinventory, gmd.locator_id locator_id, gmd.contribute_yield_ind contribute_yield_ind, gmd.scale_type scale_type, gmd.scrap_factor scrap_factor, gmd.line_type, gmd.contribute_step_qty_ind contribute_step_qty_ind, gbh.batch_no batch_no, gbh.batch_status batch_status, gbh.actual_start_date actual_start_date, gbh.actual_cmplt_date actual_completion_date, gbh.batch_close_date, gbh.plan_start_date plan_start_date, gbh.plan_cmplt_date plan_cmplt_date, to_char(mmt.transaction_date,'MON-YYYY') transaction_date, (select transaction_type_name from mtl_transaction_types where transaction_type_id=mmt.transaction_type_id) mmt_transaction_type, gmd.organization_id from gme_batch_header gbh, gme_material_details gmd, fm_form_mst ffm, mtl_material_transactions mmt, (select sum(cmpnt_cost) item_cost,cmpnt.inventory_item_id,cmpnt.organization_id from cm_cmpt_dtl cmpnt where 1=1 group by cmpnt.inventory_item_id,cmpnt.organization_id ) a where 2=2 and gbh.batch_id=gmd.batch_id and gmd.inventory_item_id=a.inventory_item_id and a.organization_id = nvl((select cost_organization_id from cm_whse_asc cws where cws.organization_id=gmd.organization_id and trunc(sysdate) between trunc(nvl(eff_start_date,sysdate-1)) and trunc(nvl(eff_end_date,sysdate-1)) ),gmd.organization_id) and gbh.organization_id=gmd.organization_id and gbh.formula_id=ffm.formula_id and mmt.transaction_source_id (+)= gbh.batch_id and mmt.trx_source_line_id (+)= gmd.material_detail_id and mmt.transaction_type_id not in (43) and mmt.inventory_item_id=a.inventory_item_id union select distinct (select segment1 from mtl_system_items_b msib where msib.inventory_item_id=fmd.inventory_item_id and rownum<2) item, a.item_cost item_cost, ffm.formula_id, gbh.batch_id, ffm.formula_no formula_no, ffm.formula_vers formula_version, fmd.qty plan_qty, 0 actual_qty, round(nvl((select gmd1.actual_qty*(fmd.qty/fmd_prod.qty) from gme_material_details gmd1 where gmd1.batch_id=gbh.batch_id and gmd1.inventory_item_id=fmd_prod.inventory_item_id and gmd1.line_type=1),0),4) +round(nvl((select gmd1.actual_qty*(fmd.qty/fmd_prod.qty) from gme_material_details gmd1 where gmd1.batch_id=gbh.batch_id and gmd1.inventory_item_id=fmd_prod.inventory_item_id and gmd1.line_type=1),0),4) *fmd.scrap_factor ,0 wip_plan_qty, null dtl_um, null material_requirement_date, null subinventory, null locator_id, fmd.contribute_yield_ind contribute_yield_ind, fmd.scale_type scale_type, fmd.scrap_factor scrap_factor, fmd.line_type line_type, fmd.contribute_step_qty_ind contribute_step_qty_ind, gbh.batch_no batch_no, gbh.batch_status batch_status, gbh.actual_start_date actual_start_date, gbh.actual_cmplt_date actual_completion_date, gbh.batch_close_date, gbh.plan_start_date plan_start_date, gbh.plan_cmplt_date plan_cmplt_date, null transaction_date, null mmt_transaction_type, fmd.organization_id from gme_batch_header gbh, fm_form_mst ffm, fm_matl_dtl fmd, fm_matl_dtl fmd_prod, (select sum(cmpnt_cost) item_cost,cmpnt.inventory_item_id,cmpnt.organization_id from cm_cmpt_dtl cmpnt where 1=1 group by cmpnt.inventory_item_id,cmpnt.organization_id ) a where a.organization_id = nvl((select cost_organization_id from cm_whse_asc cws where cws.organization_id=fmd.organization_id and trunc(sysdate) between trunc(nvl(eff_start_date,sysdate-1)) and trunc(nvl(eff_end_date,sysdate-1)) ),fmd.organization_id) and gbh.batch_id in (select distinct gbh.batch_id from gme_batch_header gbh, gme_material_details gmd, fm_form_mst ffm, mtl_material_transactions mmt, (select sum(cmpnt_cost) item_cost,cmpnt.inventory_item_id,cmpnt.organization_id from cm_cmpt_dtl cmpnt where 1=1 group by cmpnt.inventory_item_id,cmpnt.organization_id ) a where 2=2 and gbh.batch_id=gmd.batch_id and gbh.organization_id=gmd.organization_id and gbh.formula_id=ffm.formula_id and mmt.transaction_source_id (+)=gbh.batch_id and mmt.trx_source_line_id (+)=gmd.material_detail_id and mmt.inventory_item_id(+)=a.inventory_item_id) and ffm.formula_id= fmd.formula_id and ffm.formula_id=gbh.formula_id and a.inventory_item_id=fmd.inventory_item_id and fmd_prod.formula_id=ffm.formula_id and fmd_prod.line_type=1 and fmd.line_type =- 1 and not exists( select 1 from gme_material_details gmd where gmd.inventory_item_id=fmd.inventory_item_id and gmd.batch_id=gbh.batch_id ) union select distinct (select segment1 from mtl_system_items_b msib where msib.inventory_item_id=gmd.inventory_item_id and rownum<2) item, a.item_cost, ffm.formula_id, gbh.batch_id, ffm.formula_no formula_no, ffm.formula_vers formula_version, gmd.plan_qty plan_qty, gmd.actual_qty actual_qty, round(nvl((select (select gmd.actual_qty/fmd.qty from fm_matl_dtl fmd, gme_material_details gmd where fmd.formulaline_id=gmd.formulaline_id and fmd.formula_id=ffm.formula_id and fmd.line_type=1 and gmd.batch_id=gbh.batch_id) * qty std_qty from fm_matl_dtl where formula_id=ffm.formula_id and formulaline_id=gmd.formulaline_id),0),4) + round(nvl((select (select gmd.actual_qty/fmd.qty from fm_matl_dtl fmd, gme_material_details gmd where fmd.formulaline_id=gmd.formulaline_id and fmd.formula_id=ffm.formula_id and fmd.line_type=1 and gmd.batch_id=gbh.batch_id) * qty std_qty from fm_matl_dtl where formula_id=ffm.formula_id and formulaline_id=gmd.formulaline_id),0),4) *(gmd.scrap_factor) std_qty, gmd.wip_plan_qty wip_plan_qty, gmd.dtl_um dtl_um, gmd.material_requirement_date material_requirement_date, gmd.subinventory subinventory, gmd.locator_id locator_id, gmd.contribute_yield_ind contribute_yield_ind, gmd.scale_type scale_type, gmd.scrap_factor scrap_factor, gmd.line_type line_type, gmd.contribute_step_qty_ind contribute_step_qty_ind, gbh.batch_no batch_no, gbh.batch_status batch_status, gbh.actual_start_date actual_start_date, gbh.actual_cmplt_date actual_completion_date, gbh.batch_close_date, gbh.plan_start_date plan_start_date, gbh.plan_cmplt_date plan_cmplt_date, null transaction_date, null mmt_transaction_type, gmd.organization_id from gme_batch_header gbh, gme_material_details gmd, fm_form_mst ffm, (select sum(cmpnt_cost) item_cost,cmpnt.inventory_item_id,cmpnt.organization_id from cm_cmpt_dtl cmpnt where 1=1 group by cmpnt.inventory_item_id,cmpnt.organization_id ) a where gbh.batch_id =gmd.batch_id and gmd.inventory_item_id=a.inventory_item_id and gmd.organization_id=a.organization_id and gbh.organization_id=gmd.organization_id and gbh.formula_id =ffm.formula_id and gbh.batch_id in (select distinct gbh.batch_id from gme_batch_header gbh, gme_material_details gmd, fm_form_mst ffm, mtl_material_transactions mmt, (select sum(cmpnt_cost) item_cost,cmpnt.inventory_item_id,cmpnt.organization_id from cm_cmpt_dtl cmpnt where 1=1 group by cmpnt.inventory_item_id,cmpnt.organization_id ) a where 2=2 and gbh.batch_id=gmd.batch_id and gbh.organization_id=gmd.organization_id and gbh.formula_id=ffm.formula_id and mmt.transaction_source_id (+)=gbh.batch_id and mmt.trx_source_line_id (+)=gmd.material_detail_id and mmt.inventory_item_id=a.inventory_item_id) and not exists( select 1 from mtl_material_transactions mmt where mmt.inventory_item_id=gmd.inventory_item_id and mmt.organization_id=gmd.organization_id and mmt.transaction_source_id= gbh.batch_id and mmt.trx_source_line_id= gmd.material_detail_id ) ) x order by x.batch_no asc Y US GMD MUV Detail Draft 1=1 2=2 1 -20 2=2 mmt.transaction_date<=:period_end and gbh.batch_close_date<=:period_end DateTime select gps.end_date from gmf_period_statuses gps where gps.period_code=:$flex$.period and gps.legal_entity_id=(select ood.legal_entity from hr_all_organization_units_vl haouv, org_organization_definitions ood where haouv.name=:$flex$.operating_unit and haouv.organization_id=ood.operating_unit and rownum=1) and gps.cost_type_id=1001 and gps.calendar_code='NUF_CAL' Y US Period End 2 -10 2=2 mmt.transaction_date>=add_months(:period_start,-3) and gbh.batch_close_date>=:period_start DateTime select gps.start_date from gmf_period_statuses gps where gps.period_code=:$flex$.period and gps.legal_entity_id=(select ood.legal_entity from hr_all_organization_units_vl haouv, org_organization_definitions ood where haouv.name=:$flex$.operating_unit and haouv.organization_id=ood.operating_unit and rownum=1) and gps.cost_type_id=1001 and gps.calendar_code='NUF_CAL' Y US Period Start 3 10 2=2 mmt.organization_id in ( select ood.organization_id from hr_all_organization_units_vl haouv, org_organization_definitions ood where haouv.name=:operating_unit and haouv.organization_id=ood.operating_unit ) LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Y US Operating Unit 4 30 1=1 (cmpnt.cost_type_id,cmpnt.period_id) in ( select gps.cost_type_id, gps.period_id from gmf_period_statuses gps where gps.period_code=:period and gps.legal_entity_id=(select ood.legal_entity from hr_all_organization_units_vl haouv, org_organization_definitions ood where haouv.name=:operating_unit and haouv.organization_id=ood.operating_unit and rownum=1) and gps.cost_type_id=1001 and gps.calendar_code='NUF_CAL' ) LOV custom Y select gps.period_code value, gps.start_date||' - '||gps.end_date description from gmf_period_statuses gps where gps.legal_entity_id=(select ood.legal_entity from hr_all_organization_units_vl haouv, org_organization_definitions ood where haouv.name=:$flex$.operating_unit and haouv.organization_id=ood.operating_unit and rownum=1) and gps.cost_type_id=1001 and gps.calendar_code='NUF_CAL' order by gps.start_date desc Y US Period :$flex$.operating_unit Operating Unit Period :$flex$.operating_unit Operating Unit Period End :$flex$.operating_unit Operating Unit Period Start :$flex$.period Period Period End :$flex$.period Period Period Start