ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
B9847D20A0E4742FE0538931640A6379
AP Supplier
Y
Y
select
aps.vendor_name value,
aps.segment1 description
from
ap_suppliers aps
where
(:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and
(:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id))
order by
aps.vendor_name,
aps.vendor_id
US
8E2FF36EDEF179D2E0530100007F1FF2
INV Item
Y
Y
select
msiv.concatenated_segments value,
msiv.description||' ('||mp.organization_code||')' description
from
mtl_system_items_vl msiv,
mtl_parameters mp
where
(
:$flex$.organization_code is null and (
fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or
msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')
) or
xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y'
) and
msiv.organization_id=mp.organization_id
order by
mp.organization_code,
msiv.concatenated_segments
US
Inventory items, restricted to the accessible inventory organizations
8E2FF36EDEB279D2E0530100007F1FF2
INV Organization Code
Y
select
ood.organization_code value,
ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description
from
org_organization_definitions ood,
mtl_parameters mp,
mtl_parameters mp0,
hr_all_organization_units haou,
hr_locations_all hla,
fnd_territories_vl ftv
where
ood.organization_id=mp.organization_id and
mp.organization_id<>mp.master_organization_id and
(
ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or
not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
ood.operating_unit 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)
) and
(:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and
(:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and
nvl(ood.disable_date,sysdate)>=sysdate and
mp.master_organization_id=mp0.organization_id and
ood.organization_id=haou.organization_id(+) and
haou.location_id=hla.location_id(+) and
hla.country=ftv.territory_code(+)
order by
ood.organization_code
AR
جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي
D
Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers
E
Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual
F
Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel
I
Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente
JA
すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。
KO
현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드
PTB
Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual
RU
Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре.
S
Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy
TR
Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır
US
All active inventory organization codes excluding master organizations, restricted to the current user's org access view
ZHS
所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。
8E2FF36EDEFB79D2E0530100007F1FF2
INV Pegging
Y
select
flvv.meaning value,
null description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type='ASSEMBLY_PEGGING_CODE' and
flvv.view_application_id=0 and
flvv.security_group_id=0
order by
decode(flvv.lookup_code,'A',1,'Y',2,'B',3,'I',4,'X',5,'N',6)
US
A5D770D0ECB301D5E0530100007F19A3
INV Planner Code (all)
Y
select
mp.planner_code value,
mp.description
from
mtl_planners mp
where
nvl(mp.disable_date,sysdate+1)>=sysdate and
(:$flex$.organization_code is null or mp.organization_id in (select mp0.organization_id from mtl_parameters mp0 where xxen_util.contains(:$flex$.organization_code,mp0.organization_code)='Y'))
order by
mp.planner_code
US
B0B5FC7B97ED64BCE0530100007F8BA8
MFG Make or Buy
Y
select
flvv.meaning value,
null description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type='MTL_PLANNING_MAKE_BUY' and
flvv.view_application_id=700 and
flvv.security_group_id=0
order by
flvv.meaning
US
B58640C5F231626AE0530100007F518E
MRP Plan
Y
select
mpsv.compile_designator value,
mp.organization_code||' ('||xxen_util.meaning(nvl(mpsv.curr_plan_type,mpsv.plan_type),'MRP_PLAN_TYPE',700)||')' description
from
mrp_plans_sc_v mpsv,
mtl_parameters mp
where
mpsv.planned_organization in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
mpsv.planned_organization=mp.organization_id and
mpsv.plan_completion_date is not null and
(:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and
nvl(mpsv.disable_date,sysdate)>=sysdate
order by
decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2),
nvl(mpsv.curr_plan_type,mpsv.plan_type),
mpsv.compile_designator
US
8E2FF36EDF2F79D2E0530100007F1FF2
PO Buyer
Y
Y
select
ppx.full_name value,
ppx.employee_number description
from
per_people_x ppx
where
ppx.current_employee_flag='Y' and
ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and
ppx.person_id in
(
select
paaf.person_id
from
per_all_assignments_f paaf
where
trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and
(:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y')
)
)
order by
ppx.full_name
Corrected restriction to show buyers of the inventory orgs business group
US
8E2FF36EDEA679D2E0530100007F1FF2
Yes
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
US
69D164C61E5C1E6AE0530100007FEF04
select
z.organization_code,
z.origination_type,
z.demand_number,
z.order_line,
z.ship_set,
z.line_status,
z.demand_description,
z.created_by,
z.project,
z.task,
z.level_,
z.item,
z.item_description,
z.item_type,
z.pegging,
z.planner_code,
z.planner,
z.buyer,
z.end_demand_pegged_qty,
z.demand_quantity,
z.pegged_quantity,
z.uom,
z.plan_demand_date,
z.plan_start_date,
z.plan_supply_date,
z.plan_delay,
z.make_or_buy,
z.supply_quantity,
z.supply_type,
z.supply_number,
z.supply_line,
z.demand_date,
z.supply_date,
z.demand_date-z.supply_date delay,
xxen_util.client_time(z.need_by_date) need_by_date,
xxen_util.client_time(z.promised_date) promised_date,
xxen_util.client_time(z.receipt_date) receipt_date,
z.po_type,
z.po_status,
z.po_contract,
z.department_code,
z.operation_sequence,
z.operation_code,
z.operation_description,
z.resource_code,
z.resource_description,
xxen_util.client_time(z.date_last_moved) date_last_moved,
z.in_queue,
z.running,
z.to_move,
z.rejected,
z.scrapped,
z.completed,
z.action,
z.reschedule_date,
z.exception,
z.supplier_name,
z.frozen_cost,
z.pending_cost,
z.on_hand,
z.safety_stock,
z.min_minmax_quantity,
z.forecast,
z.preprocessing_lead_time,
z.cum_manufacturing_lead_time,
z.cumulative_total_lead_time,
z.postprocessing_lead_time,
xxen_util.client_time(z.schedule_ship_date) schedule_ship_date,
z.item_,
z.supply_type_,
z.item_path,
z.item_description_path,
nvl(z.demand_date,z.plan_demand_date) nvl_demand_date,
nvl(z.supply_date,z.plan_supply_date) nvl_supply_date,
z.plan,
z.end_pegging_id,
z.pegging_id,
z.prev_pegging_id,
z.inventory_item_id,
z.order_line_id,
z.vendor_id,
z.supply_line_id
from
(
select
y.organization_code,
max(nvl2(y.prev_pegging_id,null,y.origination_type)) over (partition by y.end_pegging_id) origination_type,
max(nvl2(y.prev_pegging_id,null,y.demand_number)) over (partition by y.end_pegging_id) demand_number,
max(nvl2(y.prev_pegging_id,null,y.order_line)) over (partition by y.end_pegging_id) order_line,
max(nvl2(y.prev_pegging_id,null,y.ship_set)) over (partition by y.end_pegging_id) ship_set,
max(nvl2(y.prev_pegging_id,null,y.line_status)) over (partition by y.end_pegging_id) line_status,
max(nvl2(y.prev_pegging_id,null,y.demand_description)) over (partition by y.end_pegging_id) demand_description,
max(nvl2(y.prev_pegging_id,null,y.created_by)) over (partition by y.end_pegging_id) created_by,
max(nvl2(y.prev_pegging_id,null,y.project)) over (partition by y.end_pegging_id) project,
max(nvl2(y.prev_pegging_id,null,y.task)) over (partition by y.end_pegging_id) task,
y.level_,
y.item,
y.item_description,
y.item_type,
y.pegging,
y.planner_code,
y.planner,
y.buyer,
y.end_demand_pegged_qty,
y.demand_quantity,
y.pegged_quantity,
y.uom,
y.plan_demand_date,
y.plan_start_date,
y.plan_supply_date,
y.plan_delay,
y.make_or_buy,
y.supply_quantity,
y.supply_type,
y.supply_number,
nvl(pla.line_num,prla.line_num) supply_line,
trunc(xxen_util.client_time(y.demand_date)) demand_date,
(
select
bcd1.calendar_date
from
bom_calendar_dates bcd,
bom_calendar_dates bcd1
where
trunc(xxen_util.client_time(coalesce(y.scheduled_completion_date,plla.promised_date,plla.need_by_date,prla.need_by_date)))=bcd.calendar_date and
bcd.next_seq_num+nvl(y.postprocessing_lead_time,0)=bcd1.seq_num and
y.calendar_code=bcd.calendar_code and
y.calendar_code=bcd1.calendar_code and
bcd.exception_set_id=-1 and
bcd1.exception_set_id=-1
) supply_date,
nvl(plla.need_by_date,prla.need_by_date) need_by_date,
plla.promised_date,
(select max(rt.transaction_date) from rcv_transactions rt where plla.line_location_id=rt.po_line_location_id and rt.transaction_type='RECEIVE') receipt_date,
y.po_type,
y.po_status,
y.po_contract,
y.department_code,
y.operation_sequence,
y.operation_code,
y.operation_description,
y.resource_code,
y.resource_description,
y.date_last_moved,
y.in_queue,
y.running,
y.to_move,
y.rejected,
y.scrapped,
y.completed,
xxen_util.meaning(y.action_id,'MRP_ACTIONS',700) action,
y.reschedule_date,
y.exception,
aps.vendor_name supplier_name,
y.frozen_cost,
y.pending_cost,
y.on_hand,
y.safety_stock,
y.min_minmax_quantity,
y.forecast,
y.preprocessing_lead_time,
y.cum_manufacturing_lead_time,
y.cumulative_total_lead_time,
y.postprocessing_lead_time,
y.schedule_ship_date,
y.item_,
y.supply_type_,
y.item_path,
y.item_description_path,
y.plan,
y.end_pegging_id,
y.pegging_id,
y.prev_pegging_id,
y.inventory_item_id,
y.order_line_id,
y.vendor_id,
y.supply_line_id
from
(
select
nvl2(x.prev_pegging_id,null,xxen_util.meaning(
case when x.demand_id<0 then x.demand_id else mgr.origination_type end,
case when x.demand_id<0 then 'MRP_FLP_SUPPLY_DEMAND_TYPE' else 'MRP_DEMAND_ORIGINATION' end,700)||
nvl2(flv.meaning,'/'||flv.meaning,null)) origination_type,
coalesce(we0.wip_entity_name,mipo0.po_number,to_char(ooha.order_number)) demand_number,
rtrim(oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number,'.') order_line,
(select os.set_name from oe_sets os where oola.ship_set_id=os.set_id) ship_set,
xxen_util.meaning(oola.flow_status_code,'LINE_FLOW_STATUS',660) line_status,
nvl(ottt.name,msiv0.concatenated_segments||' '||msiv0.description) demand_description,
xxen_util.user_name(nvl(we0.created_by,ooha.created_by)) created_by,
nvl2(x.prev_pegging_id,null,case when x.demand_id in (-1,-3) then mrp_get_project.project(x.project_id) else mrp_get_project.project(mgr.project_id) end) project,
nvl2(x.prev_pegging_id,null,case when x.demand_id in (-1,-3) then mrp_get_project.task(x.task_id) else mrp_get_project.task(mgr.task_id) end) task,
lpad(' ',2*(x.level__-1))||(x.level__-1) level_,
lpad(' ',2*(x.level__-1))||x.item item,
x.item_description,
xxen_util.meaning(x.item_type,'ITEM_TYPE',3) item_type,
xxen_util.meaning(x.end_assembly_pegging_flag,'ASSEMBLY_PEGGING_CODE',0) pegging,
x.planner_code,
mpl.description planner,
(select ppx.full_name from per_people_x ppx where x.buyer_id=ppx.person_id and rownum=1) buyer,
round(nvl(x.allocated_quantity/xxen_util.zero_to_null(x.end_item_usage),0),4) end_demand_pegged_qty,
round(x.demand_quantity,4) demand_quantity,
round(x.allocated_quantity,4) pegged_quantity,
muot.unit_of_measure_tl uom,
x.demand_date plan_demand_date,
mr.new_wip_start_date plan_start_date,
x.supply_date plan_supply_date,
x.demand_date-x.supply_date plan_delay,
xxen_util.meaning(x.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_or_buy,
round(x.supply_quantity,4) supply_quantity,
lpad(' ',2*(x.level__-1))||xxen_util.meaning(x.supply_type,'MRP_ORDER_TYPE',700) supply_type,
nvl(we.wip_entity_name,mipo.po_number) supply_number,
case when mipo.order_type in (1,8)
then
(select
pdtav.type_name
from
po_headers_all pha,
po_document_types_all_vl pdtav
where
pha.po_header_id=mipo.purchase_order_id and
pha.type_lookup_code=pdtav.document_subtype and
pha.org_id=pdtav.org_id and
pdtav.document_type_code in ('PO','PA')
)
else null
end po_type,
case when mipo.order_type in (1,8)
then po_headers_sv3.get_po_status(mipo.purchase_order_id)
else null
end po_status,
case when mipo.order_type in (1,8)
then (select pha.segment1 from po_headers_all pha,po_lines_all pla where pla.po_line_id = mipo.line_id and pha.po_header_id = pla.contract_id)
else null
end po_contract,
wdj0.scheduled_start_date demand_date,
wdj.scheduled_completion_date,
bd.department_code,
wo.operation_seq_num operation_sequence,
bso.operation_code,
wo.description operation_description,
br.resource_code,
br.description resource_description,
wo.date_last_moved,
wo.in_queue,
wo.running,
wo.to_move,
wo.rejected,
wo.scrapped,
wo.completed,
case
when
x.bom_item_type in (1,2,3,5) or x.base_item_id is not null and mwdo.orders_release_configs='N' or
x.wip_supply_type=6 and mwdo.orders_release_phantoms='N' or
mr.order_type in (14,15,16,17,18,19) or
mr.rescheduled_flag=1 and nvl(mr.release_status,2)=2
then null --None
when mr.disposition_status_type=2 then 1 --Cancel
when mr.new_schedule_date>mr.old_schedule_date then 3 --Reschedule Out
when mr.new_schedule_date<mr.old_schedule_date then 2 --Reschedule In
when mr.order_type=5 then --Planned order
case when nvl(mr.implemented_quantity,0)+nvl(mr.quantity_in_process,0)>=nvl(mr.firm_quantity,mr.new_order_quantity) and nvl(mr.release_status,2)=2 then null --None, planned order has been released
else 4 --Release
end
else
null --None
end action_id,
case when mr.new_schedule_date<>mr.old_schedule_date then decode(x.planning_make_buy_code,1,mr.new_wip_start_date,mr.new_dock_date) end reschedule_date,
(
select distinct
listagg(med.exception_type_meaning,', ') within group (order by med.exception_type_meaning) over ()
from
(
select distinct
med.number1,
med.inventory_item_id,
med.compile_designator,
med.organization_id,
xxen_util.meaning(med.exception_type,'MRP_EXCEPTION_CODE_TYPE',700) exception_type_meaning
from
mrp_exception_details med
where
med.exception_type in (1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29)
) med
where
x.transaction_id=med.number1 and
x.inventory_item_id=med.inventory_item_id and
x.compile_designator=med.compile_designator and
x.organization_id=med.organization_id
) exception,
cic1.item_cost frozen_cost,
cic3.item_cost pending_cost,
moqd.on_hand,
(select distinct max(mss.safety_stock_quantity) keep (dense_rank last order by mss.effectivity_date) over (partition by mss.organization_id,mss.inventory_item_id) safety_stock from mtl_safety_stocks mss where x.organization_id=mss.organization_id and x.inventory_item_id=mss.inventory_item_id and mss.effectivity_date<=sysdate) safety_stock,
x.min_minmax_quantity,
(
select
sum(mfd.current_forecast_quantity)
from
mrp_forecast_designators mfds,
mrp_forecast_dates mfd
where
x.organization_id=mfds.organization_id and
mfds.forecast_designator=mfd.forecast_designator and
x.organization_id=mfd.organization_id and
x.inventory_item_id=mfd.inventory_item_id
) forecast,
x.preprocessing_lead_time,
x.cum_manufacturing_lead_time,
x.cumulative_total_lead_time,
x.postprocessing_lead_time,
oola.schedule_ship_date,
x.item item_,
xxen_util.meaning(x.supply_type,'MRP_ORDER_TYPE',700) supply_type_,
x.item_path,
x.item_description_path,
x.compile_designator plan,
mp.organization_code,
mp.calendar_code,
x.end_pegging_id,
x.pegging_id,
x.prev_pegging_id,
x.inventory_item_id,
decode(mgr.origination_type,6,mgr.reservation_id) order_line_id,
x.supply_type supply_type_id,
nvl(mipo.vendor_id,msa.vendor_id) vendor_id,
case
when mr.order_type in (1,8) then ( --try to find matching po line_location_id as MRP unfortunately only tracks the line_id, but not line_location_id
select
plla.line_location_id
from
(select count(*) over (partition by plla.po_line_id) dupl_count, plla.* from po_line_locations_all plla) plla
where
mipo.line_id=plla.po_line_id and
(
plla.dupl_count=1 or
mipo.po_uom_delivery_balance=plla.quantity or
mipo.po_uom_delivery_balance=plla.quantity-nvl(plla.quantity_received,0)
) and
rownum=1
)
when mr.order_type in (2,11,12) then mipo.line_id
end supply_line_id
from
(
select
level level__,
msiv.planner_code,
msiv.planning_make_buy_code,
msiv.primary_uom_code,
msiv.item_type,
msiv.end_assembly_pegging_flag,
msiv.bom_item_type,
decode(msiv.min_minmax_quantity,0,to_number(null),msiv.min_minmax_quantity) min_minmax_quantity,
msiv.preprocessing_lead_time,
msiv.cum_manufacturing_lead_time,
msiv.cumulative_total_lead_time,
msiv.postprocessing_lead_time,
msiv.base_item_id,
msiv.wip_supply_type,
msiv.concatenated_segments item,
msiv.description item_description,
msiv.buyer_id,
substr(sys_connect_by_path(msiv.concatenated_segments,'-> '),4) item_path,
substr(sys_connect_by_path(replace(msiv.description,'-> ','->'),'-> '),4) item_description_path,
mfp.*
from
(
select
mfp.*
from
mrp_full_pegging mfp
where
1=1
) mfp,
mtl_system_items_vl msiv
where
mfp.organization_id=msiv.organization_id(+) and
mfp.inventory_item_id=msiv.inventory_item_id(+)
connect by
prior mfp.pegging_id=mfp.prev_pegging_id
start with
2=2 and
mfp.prev_pegging_id is null
) x,
(
select
sum(moqd.primary_transaction_quantity) on_hand,
moqd.organization_id,
moqd.inventory_item_id
from
mtl_onhand_quantities_detail moqd,
mtl_secondary_inventories msi
where
moqd.subinventory_code=msi.secondary_inventory_name and
moqd.organization_id=msi.organization_id and
msi.availability_type=1
group by
moqd.organization_id,
moqd.inventory_item_id
) moqd,
(
select
nvl(mwdo.orders_release_phantoms,'N') orders_release_phantoms,
nvl(mwdo.orders_release_configs,'N') orders_release_configs
from
(select fnd_global.user_id user_id from dual) x,
mrp_workbench_display_options mwdo
where
x.user_id=mwdo.user_id(+) and
rownum=1
) mwdo,
(
select
msa.inventory_item_id,
msa.organization_id,
min(msso.vendor_id) vendor_id
from
mrp_sr_assignments msa,
mrp_sr_receipt_org msro,
mrp_sr_source_org msso
where
msa.sourcing_rule_id=msro.sourcing_rule_id and
msa.organization_id=msro.receipt_organization_id and
sysdate between msro.effective_date and nvl(msro.disable_date,sysdate) and
msro.sr_receipt_id=msso.sr_receipt_id and
msso.rank=1
group by
msa.inventory_item_id,
msa.organization_id
) msa,
mtl_units_of_measure_tl muot,
mtl_planners mpl,
fnd_lookup_values flv,
mrp_recommendations mr,
mrp_item_purchase_orders mipo,
wip_entities we,
wip_discrete_jobs wdj,
mrp_gross_requirements mgr,
oe_order_lines_all oola,
oe_order_headers_all ooha,
oe_transaction_types_tl ottt,
wip_entities we0,
wip_discrete_jobs wdj0,
mtl_system_items_vl msiv0,
mrp_item_purchase_orders mipo0,
mtl_parameters mp,
cst_item_costs cic1,
cst_item_costs cic3,
(
select distinct
wo.wip_entity_id,
wo.organization_id,
wo.repetitive_schedule_id,
min(wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) operation_seq_num,
max(wo.department_id) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) department_id,
max(wo.standard_operation_id) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) standard_operation_id,
max(wo.description) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) description,
max(wo.date_last_moved) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) date_last_moved,
max(decode(wo.quantity_in_queue,0,null,wo.quantity_in_queue)) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) in_queue,
max(decode(wo.quantity_running,0,null,wo.quantity_running)) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) running,
max(decode(wo.quantity_waiting_to_move,0,null,wo.quantity_waiting_to_move)) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) to_move,
max(decode(wo.quantity_rejected,0,null,wo.quantity_rejected)) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) rejected,
max(decode(wo.quantity_scrapped,0,null,wo.quantity_scrapped)) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) scrapped,
max(decode(wo.quantity_completed,0,null,wo.quantity_completed)) keep (dense_rank first order by wo.operation_seq_num) over (partition by wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id) completed
from
wip_operations wo
where
wo.quantity_in_queue>0 or wo.quantity_running>0 or wo.quantity_waiting_to_move>0
) wo,
bom_departments bd,
(select bso.* from bom_standard_operations bso where nvl(bso.operation_type,1)=1 and bso.line_id is null) bso,
(
select distinct
wor.organization_id,
wor.wip_entity_id,
wor.operation_seq_num,
max(wor.resource_id) keep (dense_rank first order by wor.resource_seq_num) over (partition by wor.wip_entity_id, wor.organization_id, wor.operation_seq_num, wor.repetitive_schedule_id) resource_id
from
wip_operation_resources wor
) wor,
bom_resources br
where
x.organization_id=moqd.organization_id(+) and
x.inventory_item_id=moqd.inventory_item_id(+) and
case when x.planning_make_buy_code=2 and x.supply_type=5 then x.organization_id end=msa.organization_id(+) and
case when x.planning_make_buy_code=2 and x.supply_type=5 then x.inventory_item_id end=msa.inventory_item_id(+) and
x.primary_uom_code=muot.uom_code(+) and
muot.language(+)=userenv('lang') and
x.planner_code=mpl.planner_code(+) and
x.organization_id=mpl.organization_id(+) and
case when x.demand_id=-1 and x.prev_pegging_id is null then to_char(case when x.supply_type in (10,13) then 5 else x.supply_type end) end=flv.lookup_code(+) and
flv.lookup_type(+) in ('MRP_FLP_SUPPLY_DEMAND_TYPE','MRP_ORDER_TYPE') and
flv.language(+)=userenv('lang') and
flv.view_application_id(+)=700 and
flv.security_group_id(+)=0 and
not (flv.lookup_code(+)='18' and flv.lookup_type(+)='MRP_FLP_SUPPLY_DEMAND_TYPE') and
x.transaction_id=mr.transaction_id(+) and
case when mr.order_type in (1,2,8,11,12) then mr.disposition_id end=mipo.transaction_id(+) and
case when mr.order_type in (3,7,14,15,27,28) then mr.disposition_id end=we.wip_entity_id(+) and
we.wip_entity_id=wdj.wip_entity_id(+) and
we.organization_id=wdj.organization_id(+) and
x.demand_id=mgr.demand_id(+) and
decode(mgr.origination_type,6,mgr.reservation_id)=oola.line_id(+) and
oola.header_id=ooha.header_id(+) and
ooha.order_type_id=ottt.transaction_type_id(+) and
ottt.language(+)=userenv('lang') and
case when mgr.origination_type in (2,3,17,25,26) then mgr.disposition_id end=we0.wip_entity_id(+) and
we0.wip_entity_id=wdj0.wip_entity_id(+) and
we0.organization_id=wdj0.organization_id(+) and
we0.primary_item_id=msiv0.inventory_item_id(+) and
we0.organization_id=msiv0.organization_id(+) and
case when mgr.origination_type in (18,19,20,23,24) then mgr.disposition_id end=mipo0.transaction_id(+) and
x.organization_id=mp.organization_id(+) and
x.organization_id=cic1.organization_id(+) and
x.organization_id=cic3.organization_id(+) and
x.inventory_item_id=cic1.inventory_item_id(+) and
x.inventory_item_id=cic3.inventory_item_id(+) and
cic1.cost_type_id(+)=1 and
cic3.cost_type_id(+)=3 and
we.wip_entity_id=wo.wip_entity_id(+) and
we.organization_id=wo.organization_id(+) and
wo.department_id=bd.department_id(+) and
wo.standard_operation_id=bso.standard_operation_id(+) and
wo.wip_entity_id=wor.wip_entity_id(+) and
wo.organization_id=wor.organization_id(+) and
wo.operation_seq_num=wor.operation_seq_num(+) and
wor.resource_id=br.resource_id(+)
) y,
po_line_locations_all plla,
po_lines_all pla,
po_requisition_lines_all prla,
ap_suppliers aps
where
case when y.supply_type_id in (1,8) then y.supply_line_id end=plla.line_location_id(+) and
plla.po_line_id=pla.po_line_id(+) and
decode(y.supply_type_id,2,y.supply_line_id)=prla.requisition_line_id(+) and
y.vendor_id=aps.vendor_id(+)
) z
where
3=3
order by
plan,
origination_type,
demand_number,
end_pegging_id,
item_path,
organization_code
Y
#,##0;[Red]-#,##0
AR
MRP Pegging
تقرير تفصيلي لربط تخطيط MRP يوضح التسلسل الهرمي من الطلب ، بما في ذلك التنبؤ وأوامر المبيعات وأمر العمل حتى التوريد (وظائف العمل قيد التقدم وأوامر الشراء والمخزون الموجود)
D
MRP Pegging
MRP Bezugszuordnungs-Plandaten in hierarchischer Darstellung.
Unterschiedliche Bedarfstypen (z.B. Kundenaufträge, Forecast, Fertigungsaufträge, Sicherheitsbestand) werden mit ihrer Bezugszuordnung dargestellt
E
MRP Pegging
Informe detallado para el ajuste de la planificación MRP que muestra la jerarquía desde la demanda, incluyendo la previsión, los pedidos de venta, la orden de trabajo hasta el suministro (trabajos WIP, pedidos de compra y stock disponible)
F
MRP Pegging
Rapport détaillé pour l'ancrage de la planification MRP montrant la hiérarchie de la demande, y compris les prévisions, les commandes clients, les bons de travail à l'approvisionnement (emplois WIP, commandes d'achat et stock disponible)
I
MRP Pegging
Rapporto dettagliato per il pegging di pianificazione MRP che mostra la gerarchia dalla domanda, incluse le previsioni, gli ordini di vendita, gli ordini di lavoro alla fornitura (lavori WIP, ordini di acquisto e stock a disposizione)
JA
MRP Pegging
MRP計画の詳細レポートでは、需要から予測、販売オーダー、作業オーダーから供給（WIPジョブ、購買オーダー、手元在庫）までの階層を示している。
KO
MRP Pegging
예측, 판매 주문, 공급에 대한 작업 주문 (WIP 작업, 구매 주문 및 현재 고)을 포함하여 수요에서 계층을 보여주는 MRP 계획 페깅에 대한 상세 보고서
PTB
MRP Pegging
Relatório detalhado para a indexação do planejamento MRP mostrando a hierarquia da demanda, incluindo previsão, ordens de venda, ordem de trabalho para fornecer (trabalhos WIP, ordens de compra e estoque em caixa)
RU
MRP Pegging
Подробный отчет для привязки планирования MRP, показывающий иерархию от спроса, включая прогноз, заказы на продажу, заказы на поставку (WIP-заказы, заказы на поставку и наличные запасы).
S
MRP Pegging
Detaljrapport för MRP-planeringspegning som visar hierarkin från efterfrågan, inklusive prognos, försäljningsorder, arbetsorder att leverera (WIP-jobb, inköpsorder och lager)
TR
MRP Pegging
Tahmin, satış siparişleri, tedarikten tedarike kadar olan iş emri dahil olmak üzere talebe göre hiyerarşiyi gösteren MRP planlama pegging için detay raporu (WIP işleri, satın alma siparişleri ve eldeki stok)
US
MRP Pegging
Detail report for MRP planning pegging showing the hierarchy from demand, including forecast, sales orders, work order to supply (WIP jobs, purchase orders and on hand stock)
ZHS
MRP Pegging
用于MRP计划挂钩的详细报告，显示从需求，包括预测、销售订单、工单到供应（WIP作业、采购订单和在手库存）的层次结构。
Enginatics
1=1
2=2
3=3
1
-10
2=2
mfp.pegging_id in
(select
mfp0.end_pegging_id
from
mrp_full_pegging mfp0
where
(mfp0.compile_designator,mfp0.organization_id,mfp0.inventory_item_id) in
(select distinct
dbms_lob.substr(xrrpv.value,dbms_lob.instr(xrrpv.value,'|')-1) compile_designator,
dbms_lob.substr(xrrpv.value,dbms_lob.instr(xrrpv.value,'|',1,2) - dbms_lob.instr(xrrpv.value,'|',1,1) - 1,instr(xrrpv.value,'|')+1) organization_id,
dbms_lob.substr(xrrpv.value,20,dbms_lob.instr(xrrpv.value,'|',1,2)+1) inventory_item_id
from
xxen_report_parameters_v xrpv,
xxen_report_run_param_values xrrpv
where
nvl(:tmp,'?') = nvl(:tmp,'?') and
xrpv.parameter_name='compile_designator|organization_id|inventory_item_id' and
xrpv.parameter_id=xrrpv.parameter_id and
xrrpv.run_id=:run_id
)
)
Char
F
compiler_designator|organization_id|inventory_item_id
US
compile_designator|organization_id|inventory_item_id
2
3=3
z.inventory_item_id in
(select distinct
dbms_lob.substr(xrrpv.value,20,dbms_lob.instr(xrrpv.value,'|',1,2)+1) inventory_item_id
from
xxen_report_parameters_v xrpv,
xxen_report_run_param_values xrrpv
where
nvl(:tmp,'?') = nvl(:tmp,'?') and
xrpv.parameter_name='compile_designator|organization_id|inventory_item_id' and
xrpv.parameter_id=xrrpv.parameter_id and
xrrpv.run_id=:run_id
)
US
compile_designator|organization_id|inventory_item_id
3
10
1=1
mfp.organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:organization_code)
LOV
INV Organization Code
8E2FF36EDEB279D2E0530100007F1FF2
Y
select
ood.organization_code value,
ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description
from
org_organization_definitions ood,
mtl_parameters mp,
mtl_parameters mp0,
hr_all_organization_units haou,
hr_locations_all hla,
fnd_territories_vl ftv
where
ood.organization_id=mp.organization_id and
mp.organization_id<>mp.master_organization_id and
(
ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or
not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
ood.operating_unit 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)
) and
(:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and
(:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and
nvl(ood.disable_date,sysdate)>=sysdate and
mp.master_organization_id=mp0.organization_id and
ood.organization_id=haou.organization_id(+) and
haou.location_id=hla.location_id(+) and
hla.country=ftv.territory_code(+)
order by
ood.organization_code
select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')
D
Organisationscode
F
Code de l'organisation
US
Organization Code
4
20
1=1
mfp.compile_designator=:compile_designator
LOV
MRP Plan
B58640C5F231626AE0530100007F518E
Y
select
mpsv.compile_designator value,
mp.organization_code||' ('||xxen_util.meaning(nvl(mpsv.curr_plan_type,mpsv.plan_type),'MRP_PLAN_TYPE',700)||')' description
from
mrp_plans_sc_v mpsv,
mtl_parameters mp
where
mpsv.planned_organization in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and
mpsv.planned_organization=mp.organization_id and
mpsv.plan_completion_date is not null and
(:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and
nvl(mpsv.disable_date,sysdate)>=sysdate
order by
decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2),
nvl(mpsv.curr_plan_type,mpsv.plan_type),
mpsv.compile_designator
select distinct
min(mpsv.compile_designator) keep (dense_rank first order by decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2),mpsv.plan_completion_date desc) compile_designator
from
mrp_plans_sc_v mpsv,
mtl_parameters mp
where
mpsv.plan_completion_date is not null and
mpsv.planned_organization=mp.organization_id and
(:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and
nvl(mpsv.disable_date,sysdate)>=sysdate
Y
US
Plan
5
30
2=2
mfp.demand_id in (
select
mgr.demand_id
from
oe_order_headers_all ooha,
oe_order_lines_all oola,
mrp_gross_requirements mgr
where
ooha.order_number=:sales_order and
ooha.header_id=oola.header_id and
oola.line_id=mgr.reservation_id and
mgr.origination_type in (6,30,54) and
mgr.compile_designator=:compile_designator
)
LOV custom
Y
select
mso.order_number value,
ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(mso.flow_status_code,'FLOW_STATUS',660)||')' description
from
(
select distinct
msd.source_sales_order_id
from
mrp_gross_requirements mgr,
mrp_schedule_dates msd,
mtl_parameters mp
where
mgr.organization_id=mp.organization_id and
(:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and
(:$flex$.Plan is null or xxen_util.contains(:$flex$.Plan,mgr.compile_designator)='Y') and
mgr.origination_type in (6,30.54) and
mgr.disposition_id=msd.mps_transaction_id and
msd.schedule_level=2 and
msd.supply_demand_type=1
) x,
(
select
mso.segment1 order_number,
mso.sales_order_id,
ooha.header_id ooha_header_id,
ooha.sold_to_org_id,
ooha.flow_status_code,
ottt.transaction_type_id
from
mtl_sales_orders mso,
oe_transaction_types_tl ottt,
(select x.* from (select max(ooha.version_number) over (partition by ooha.order_number,ooha.order_type_id) max_version_number, ooha.* from oe_order_headers_all ooha) x where x.version_number=x.max_version_number) ooha
where
mso.segment3='ORDER ENTRY' and
mso.segment1=ooha.order_number and
mso.segment2=ottt.name and
ottt.language='US' and
ottt.transaction_type_id=ooha.order_type_id
) mso,
hz_cust_accounts hca,
oe_transaction_types_tl ottt
where
x.source_sales_order_id=mso.sales_order_id and
mso.sold_to_org_id=hca.cust_account_id and
mso.transaction_type_id=ottt.transaction_type_id and
ottt.language=userenv('lang')
order by
mso.ooha_header_id desc
D
Kundenauftrag
F
Commande de vente
US
Sales Order
6
40
2=2
mfp.demand_id in (
select
mgr.demand_id
from
oe_transaction_types_tl ottt,
oe_order_headers_all ooha,
oe_order_lines_all oola,
mrp_gross_requirements mgr
where
ottt.name=:order_type and
ooha.order_type_id=ottt.transaction_type_id and
ottt.language=userenv('lang') and
ooha.header_id=oola.header_id and
oola.line_id=mgr.reservation_id and
mgr.origination_type=6 and
mgr.compile_designator=:compile_designator
)
LOV custom
Y
select
ottt.name value,
xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description
from
oe_transaction_types_all otta,
oe_transaction_types_tl ottt
where
otta.org_id in
(select ood.operating_unit
from org_organization_definitions ood
where (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y')
) and
otta.transaction_type_code='ORDER' and
otta.transaction_type_id=ottt.transaction_type_id and
ottt.language=userenv('lang')
order by
decode(otta.order_category_code,'ORDER',1,'MIXED',2,3),
ottt.name
D
Auftragsart
F
Type de commande
US
Order Type
7
50
2=2
mfp.pegging_id in
(
select
mfp0.end_pegging_id
from
mtl_system_items_b_kfv msibk0,
mrp_full_pegging mfp0
where
msibk0.concatenated_segments=:item and
mfp0.compile_designator=:compile_designator and
msibk0.inventory_item_id=mfp0.inventory_item_id and
msibk0.organization_id=mfp0.organization_id
)
LOV
INV Item
8E2FF36EDEF179D2E0530100007F1FF2
Y
Y
select
msiv.concatenated_segments value,
msiv.description||' ('||mp.organization_code||')' description
from
mtl_system_items_vl msiv,
mtl_parameters mp
where
(
:$flex$.organization_code is null and (
fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or
msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')
) or
xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y'
) and
msiv.organization_id=mp.organization_id
order by
mp.organization_code,
msiv.concatenated_segments
D
Artikel
F
Article
US
Item
8
3=3
trim(z.item)=:item
F
Article
US
Item
9
60
3=3
z.supplier_name=:vendor_name
LOV
AP Supplier
B9847D20A0E4742FE0538931640A6379
Y
Y
select
aps.vendor_name value,
aps.segment1 description
from
ap_suppliers aps
where
(:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and
(:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id))
order by
aps.vendor_name,
aps.vendor_id
D
Lieferant
F
Fournisseur
US
Supplier
10
70
2=2
mfp.pegging_id in
(
select
mfp0.end_pegging_id
from
mtl_system_items_b_kfv msibk0,
mrp_full_pegging mfp0
where
msibk0.planner_code=:planner_code and
mfp0.organization_id=msibk0.organization_id and
mfp0.inventory_item_id=msibk0.inventory_item_id and
mfp0.compile_designator=:compile_designator
)
LOV
INV Planner Code (all)
A5D770D0ECB301D5E0530100007F19A3
Y
select
mp.planner_code value,
mp.description
from
mtl_planners mp
where
nvl(mp.disable_date,sysdate+1)>=sysdate and
(:$flex$.organization_code is null or mp.organization_id in (select mp0.organization_id from mtl_parameters mp0 where xxen_util.contains(:$flex$.organization_code,mp0.organization_code)='Y'))
order by
mp.planner_code
select
mp.planner_code
from
fnd_user fu,
per_people_x ppx,
mtl_planners mp
where
1=2 and
fu.user_id=fnd_global.user_id and
fu.employee_id=mp.employee_id and
nvl(mp.disable_date,sysdate+1)>=sysdate and
mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')
D
Planer
F
Planificateur
US
Planner
11
3=3
z.planner_code=:planner_code
F
Planificateur
US
Planner
12
80
2=2
mfp.pegging_id in
(
select
mfp0.end_pegging_id
from
mtl_system_items_b_kfv msibk0,
mrp_full_pegging mfp0
where
msibk0.buyer_id in (select ppx.person_id from per_people_x ppx where ppx.full_name=:buyer and ppx.current_employee_flag='Y') and
mfp0.organization_id=msibk0.organization_id and
mfp0.inventory_item_id=msibk0.inventory_item_id and
mfp0.compile_designator=:compile_designator
)
LOV
PO Buyer
8E2FF36EDF2F79D2E0530100007F1FF2
Y
Y
select
ppx.full_name value,
ppx.employee_number description
from
per_people_x ppx
where
ppx.current_employee_flag='Y' and
ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and
ppx.person_id in
(
select
paaf.person_id
from
per_all_assignments_f paaf
where
trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and
(:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y')
)
)
order by
ppx.full_name
select
ppx.full_name
from
fnd_user fu,
per_people_x ppx
where
1=2 and
fu.user_id=fnd_global.user_id and
fu.employee_id=ppx.person_id and
ppx.current_employee_flag='Y' and
ppx.person_id in (select pa.agent_id from po_agents pa)
D
Einkäufer
F
Acheteur
US
Buyer
13
3=3
z.buyer=:buyer
F
Acheteur
US
Buyer
14
90
2=2
mfp.pegging_id in
(
select
mfp0.end_pegging_id
from
mtl_system_items_b_kfv msibk0,
mrp_full_pegging mfp0
where
msibk0.planning_make_buy_code=xxen_util.lookup_code(:make_or_buy,'MTL_PLANNING_MAKE_BUY',700) and
mfp0.organization_id=msibk0.organization_id and
mfp0.inventory_item_id=msibk0.inventory_item_id and
mfp0.compile_designator=:compile_designator
)
LOV
MFG Make or Buy
B0B5FC7B97ED64BCE0530100007F8BA8
Y
select
flvv.meaning value,
null description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type='MTL_PLANNING_MAKE_BUY' and
flvv.view_application_id=700 and
flvv.security_group_id=0
order by
flvv.meaning
D
Fertigen oder Einkaufen
F
Fabriquer ou acheter
US
Make or Buy
15
3=3
z.make_or_buy=:make_or_buy
F
Fabriquer ou acheter
US
Make or Buy
16
100
2=2
mfp.pegging_id in
(
select
mfp0.end_pegging_id
from
mtl_system_items_b_kfv msibk0,
mrp_full_pegging mfp0
where
msibk0.end_assembly_pegging_flag=xxen_util.lookup_code(:pegging,'ASSEMBLY_PEGGING_CODE',0) and
mfp0.organization_id=msibk0.organization_id and
mfp0.inventory_item_id=msibk0.inventory_item_id and
mfp0.compile_designator=:compile_designator
)
LOV
INV Pegging
8E2FF36EDEFB79D2E0530100007F1FF2
Y
select
flvv.meaning value,
null description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type='ASSEMBLY_PEGGING_CODE' and
flvv.view_application_id=0 and
flvv.security_group_id=0
order by
decode(flvv.lookup_code,'A',1,'Y',2,'B',3,'I',4,'X',5,'N',6)
D
Bezugszuordnung
F
Piquage
US
Pegging
17
3=3
z.pegging=:pegging
F
Piquage
US
Pegging
18
110
2=2
mfp.pegging_id in
(
select
mfp0.end_pegging_id
from
mrp_exception_details med,
mrp_full_pegging mfp0
where
med.exception_type=xxen_util.lookup_code(:exception_message,'MRP_EXCEPTION_CODE_TYPE',700) and
med.number1=mfp0.transaction_id
)
LOV custom
Y
select
x.exception_type_desc value,
count(*) description
from
(
select
xxen_util.meaning(med.exception_type,'MRP_EXCEPTION_CODE_TYPE',700) exception_type_desc,
med.*
from
mrp_exception_details med,
mtl_parameters mp
where
med.organization_id=mp.organization_id and
(:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and
xxen_util.contains(:$flex$.plan,med.compile_designator)='Y' and
med.exception_type<>5 and
med.exception_type in (1,2,3,4,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29)
) x
group by
x.exception_type_desc
order by count(*) desc
D
Ausnahme
US
Exception
19
3=3
z.exception like '%'||:exception_message||'%'
US
Exception
20
120
2=2
exists
(
select
null
from
fnd_lookup_values flv
where
flv.meaning=nvl(regexp_substr(:origination_type,'(.*)/',1,1,null,1),:origination_type) and
flv.lookup_type in ('MRP_FLP_SUPPLY_DEMAND_TYPE','MRP_DEMAND_ORIGINATION') and
flv.language=userenv('lang') and
not (flv.lookup_code(+)='18' and flv.lookup_type(+)='MRP_FLP_SUPPLY_DEMAND_TYPE') and
(
to_number(flv.lookup_code)<0 and to_number(flv.lookup_code)=mfp.demand_id or
to_number(flv.lookup_code)>=0 and to_number(flv.lookup_code)=(
select
mgr.origination_type
from
mrp_gross_requirements mgr
where
mgr.compile_designator=:compile_designator and
mfp.demand_id=mgr.demand_id)
)
)
LOV custom
Y
select
x.origination_name value,
count(*) description
from
(
select
mfp.pegging_id,
nvl2(mfp.prev_pegging_id,null,xxen_util.meaning(
case when mfp.demand_id<0 then mfp.demand_id else mgr.origination_type end,
case when mfp.demand_id<0 then 'MRP_FLP_SUPPLY_DEMAND_TYPE' else 'MRP_DEMAND_ORIGINATION' end,700)||
nvl2(flvv.meaning,'/'||flvv.meaning,null)) origination_name
from
mrp_full_pegging mfp,
mtl_parameters mp,
mrp_gross_requirements mgr,
fnd_lookup_values_vl flvv
where
mfp.organization_id=mp.organization_id and
(:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and
xxen_util.contains(:$flex$.plan,mfp.compile_designator)='Y' and
mfp.prev_pegging_id is null and
mfp.demand_id=mgr.demand_id(+) and
case when mfp.demand_id=-1 and mfp.prev_pegging_id is null then to_char(case when mfp.supply_type in (10,13) then 5 else mfp.supply_type end) end=flvv.lookup_code(+) and
flvv.lookup_type(+) in ('MRP_FLP_SUPPLY_DEMAND_TYPE','MRP_ORDER_TYPE') and
flvv.view_application_id(+)=700 and
flvv.security_group_id(+)=0 and
not (flvv.lookup_code(+)='18' and flvv.lookup_type(+)='MRP_FLP_SUPPLY_DEMAND_TYPE')
) x
group by
x.origination_name
order by
x.origination_name
D
Bedarfstyp
F
Type d'origine
US
Origination Type
21
3=3
z.origination_type=:origination_type
F
Type d'origine
US
Origination Type
22
130
3=3
z.plan_delay<=-:plan_delay_days_from
Number
F
Retard du plan Jours de
US
Plan Delay Days from
23
140
3=3
z.delay<=-:delay_days_from
Number
F
Jours de retard réels de
US
Actual Delay Days from
24
150
3=3
trim(z.supply_type)=:supply_type
LOV custom
Y
select
flvv.meaning value,
null description
from
fnd_lookup_values_vl flvv
where
flvv.lookup_type='MRP_ORDER_TYPE' and
flvv.view_application_id=700 and
flvv.security_group_id=0
order by
to_number(flvv.lookup_code)
F
Type de fourniture
US
Supply Type
25
160
3=3
z.receipt_date<sysdate-:receipt_days
Number
F
Date de réception supérieure à x jours
US
Receipt Date older than x days
26
170
1=1
mfp.supply_type<>18
LOV
Yes
8E2FF36EDEA679D2E0530100007F1FF2
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
D
Ohne Bestand
F
Exclut les produits en stock
US
Exclude On Hand
:$flex$.Plan
Plan
Sales Order
:$flex$.organization_code
Organization Code
Buyer
:$flex$.organization_code
Organization Code
Exception
:$flex$.organization_code
Organization Code
Item
:$flex$.organization_code
Organization Code
Order Type
:$flex$.organization_code
Organization Code
Origination Type
:$flex$.organization_code
Organization Code
Plan
:$flex$.organization_code
Organization Code
Planner
:$flex$.organization_code
Organization Code
Sales Order
:$flex$.organization_code
Organization Code
Supplier
:$flex$.plan
Plan
Exception
:$flex$.plan
Plan
Origination Type