ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 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 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 3A37C6EB67B2AEE8E06362FB0905B3AA select mosv.compile_designator plan, mosv.organization_code organization, mosv.item_segments item, mosv.description description, (select mck.concatenated_segments from mtl_categories_kfv mck where mck.category_id = mosv.category) category, xxen_util.meaning(decode(mosv.source_table,'MRP_GROSS_REQUIREMENTS','DEMAND','SUPPLY'),'MSC_QUESTION_TYPE',3) supply_demand, mosv.order_type_text order_type, mosv.new_due_date suggested_due_date, mosv.days_from_today, mosv.quantity_rate, mosv.order_number, case when mosv.source_table = 'MRP_GROSS_REQUIREMENTS' then xxen_util.meaning(5,'MRP_ACTIONS',700) else xxen_util.meaning( case when mosv.bom_item_type in (1,2,3,5) or (mosv.base_item_id is not null and mwdo.orders_release_configs = 'N' ) or (mosv.wip_supply_type = 6 and mwdo.orders_release_phantoms = 'N' ) or mosv.order_type in (14,15,16,17,18,19) or (mosv.rescheduled_flag = 1 and nvl(mosv.release_status,2) = 2 ) then 6 --none when mosv.disposition_status_type = 2 then 1 --cancel when mosv.new_due_date > mosv.old_due_date then 3 --reschedule out when mosv.new_due_date < mosv.old_due_date then 2 --reschedule in when mosv.order_type = 5 then --planned order case when nvl(mosv.implemented_quantity,0) + nvl(mosv.quantity_in_process,0) >= nvl(mosv.firm_quantity,mosv.quantity_rate) and nvl(mosv.release_status,2)=2 then 6 --none, planned order has been released else 4 --release end else 6 --none end,'MRP_ACTIONS',700) end action, xxen_util.meaning(nvl2(mosv.firm_date,'Y',null),'YES_NO',0) firm, mosv.firm_date, mosv.firm_quantity, mosv.schedule_compression_days, mosv.supply_avail_date, xxen_util.meaning(decode(mosv.release_status,1,'Y',null),'YES_NO',0) selected_for_release, xxen_util.meaning(decode(mosv.rescheduled_flag,1,'Y',null),'YES_NO',0) rescheduled_flag, mosv.new_processing_days, mosv.implement_date, mosv.implement_quantity_rate implement_quantity, mosv.implement_as_text implement_as, (select hl.location_code from hr_locations hl where hl.location_id = mosv.implement_location_id) implement_location, mosv.quantity_in_process, mosv.implemented_quantity, -- mosv.source_organization_code, mosv.source_vendor_name, mosv.source_vendor_site_code, xxen_util.meaning(decode(mosv.in_source_plan,1,'Y',null),'YES_NO',0) in_source_plan, mosv.source_schedule, -- (select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.organization_id = mosv.organization_id and msiv.inventory_item_id = mosv.using_assembly_item_id) using_assembly, -- mosv.planner_code planner, mosv.buyer_name buyer, xxen_util.meaning(mosv.bom_item_type,'BOM_ITEM_TYPE',700) bom_item_type, xxen_util.meaning(mosv.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_buy, xxen_util.meaning(decode(mosv.purchasing_enabled_flag,1,'Y',null),'YES_NO',0) purchasable, xxen_util.meaning(decode(mosv.build_in_wip_flag,1,'Y',null),'YES_NO',0) build_in_wip_flag, xxen_util.meaning(mosv.wip_supply_type,'WIP_SUPPLY',700) wip_supply_type, xxen_util.meaning(mosv.mrp_planning_code,'MRP_PLANNING_CODE',700) mrp_planning_method, xxen_util.meaning(mosv.release_time_fence_code,'MTL_RELEASE_TIME_FENCE',700) release_time_fence, mosv.planning_group, -- mosv.alternate_bom_designator, mosv.alternate_routing_designator, xxen_util.meaning(decode(mosv.cfm_routing_flag,1,'Y',null),'YES_NO',0) cfm_routing, -- mosv.project_number, mosv.task_number, mosv.unit_number, -- mosv.old_order_quantity, mosv.old_due_date, mosv.old_dock_date, mosv.new_due_date, mosv.new_dock_date, mosv.new_order_date, mosv.new_start_date, mosv.first_unit_start_date, mosv.last_unit_start_date, mosv.last_unit_completion_date, -- xxen_util.meaning(decode(mosv.implement_firm,1,'Y',null),'YES_NO',0) implement_firm, mosv.implement_wip_class_code, mosv.implement_job_name, mosv.implement_demand_class, mosv.implement_alternate_bom, mosv.implement_build_sequence, mosv.implement_alternate_routing, mosv.schedule_group_name wip_schedule_group, mosv.build_sequence wip_build_sequence, mosv.line_code wip_line_code, mosv.implement_alternate_bom, mosv.implement_alternate_routing, mrp_get_project.project(mosv.implement_project_id) implement_project, mrp_get_project.task(mosv.implement_task_id) implement_task, mosv.implement_unit_number, mosv.implement_processing_days, mosv.release_errors, -- item dff attributes &lp_item_dff_cols mosv.transaction_id from mrp_orders_sc_v mosv, ( 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 where 1=1 and (mosv.compile_designator,mosv.organization_id) in (select mpsv.compile_designator,mpsv.organization_id from mrp_plans_sc_v mpsv where 2=2 and mpsv.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) and nvl(mpsv.disable_date,sysdate)>=sysdate and mpsv.data_completion_date is not null and nvl(mpsv.plan_type,mpsv.curr_plan_type) in (1,2,3,4) ) order by plan, organization, planner, item, suggested_due_date, supply_demand, order_type, order_number Y US MRP Plan Orders MRP: Export Supply and Demand Orders from the Planners Workbench. Enginatics &lp_item_dff_cols 1=1 2=2 1 -10 1=1 (mosv.compile_designator,mosv.organization_id,mosv.inventory_item_id) in ( select distinct xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',1) compile_designator, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',2) organization_id, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',3) inventory_item_id from xxen_report_run_param_values xrrpv where xrrpv.parameter_id in (select xrpv.parameter_id from xxen_report_parameters_v xrpv where xrpv.parameter_name='compile_designator|organization_id|inventory_item_id') and xrrpv.run_id=:run_id ) Char US compile_designator|organization_id|inventory_item_id 2 10 2=2 mpsv.organization_code=:p_org_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 coalesce( (select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')), (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and oav.organization_id not in (select mp.master_organization_id from mtl_parameters mp) and rownum=1) ) US Organization Code 3 20 2=2 mpsv.compile_designator=:p_plan LOV custom Y select distinct mpsv.compile_designator value, mpsv.organization_code ||' - '|| mpsv.plan_type_text||' - '||mpsv.description description from mrp_plans_sc_v mpsv where nvl(mpsv.disable_date,sysdate)>=sysdate and mpsv.data_completion_date is not null and nvl(mpsv.plan_type,mpsv.curr_plan_type) in (1,2,3,4) and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mpsv.organization_code) = 'Y' ) and mpsv.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) order by mpsv.compile_designator US Plan 4 30 1=1 mosv.source_organization_code=:p_source_org_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 US Source Organiziation Code 5 40 1=1 :p_category_set_name=:p_category_set_name LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name select category_set_name from mtl_default_sets_view where functional_area_id = 3 US Category Set 6 50 1=1 mosv.category IN (select mck. category_id from mtl_categories_kfv mck where mck.concatenated_segments = :p_category) LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US Category 7 60 1=1 mosv.item_segments||''=:p_item LOV custom Y Y select distinct msisv.item_segments value, msisv.description from mrp_system_items_sc_v msisv ,mtl_system_items_b msib where msib.organization_id = msisv.organization_id and msib.inventory_item_id = msisv.inventory_item_id and (:$flex$.organization_code is null or msisv.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') ) and (:$flex$.plan is null or xxen_util.contains(:$flex$.plan,msisv.compile_designator) = 'Y' ) and (:$flex$.category is null or exists (select null from mtl_category_sets mcs, mtl_categories_kfv mck, mtl_item_categories mic where mic.inventory_item_id = msisv.inventory_item_id and mic.organization_id = msisv.organization_id and mcs.category_set_id = mic.category_set_id and mcs.category_set_name = :$flex$.category_set and mck.category_id = mic.category_id and xxen_util.contains(:$flex$.category,mck.concatenated_segments)='Y' ) ) order by msisv.item_segments US Item 8 70 1=1 mosv.source_table=decode(xxen_util.lookup_code(:p_supply_demand,'MSC_QUESTION_TYPE',3),'DEMAND','MRP_GROSS_REQUIREMENTS',mosv.source_table) LOV custom Y select distinct meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MSC_QUESTION_TYPE' and flvv.view_application_id = 3 and flvv.lookup_code in ('SUPPLY','DEMAND') order by value US Supply/Demand 9 80 1=1 mosv.planner_code = :p_planner LOV custom Y select mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id in (select mpsv.planned_organization from mrp_plans_sc_v mpsv where (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mpsv.organization_code) = 'Y' ) and (:$flex$.plan is null or xxen_util.contains(:$flex$.plan,mpsv.compile_designator) = 'Y' ) ) order by mp.planner_code US Planner 10 90 1=1 mosv.buyer_name = :p_buyer 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 US Buyer 11 100 1=1 mosv.planning_make_buy_code =xxen_util.lookup_code(:p_makeorbuy,'MTL_PLANNING_MAKE_BUY',700) 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 US Make/Buy 12 110 1=1 mosv.order_type_text =:order_type LOV custom Y select flv.meaning value, null description from fnd_lookup_values flv where flv.lookup_type IN ('MRP_ORDER_TYPE','MRP_DEMAND_ORIGINATION') and flv.security_group_id = 0 and flv.enabled_flag = 'Y' and sysdate between nvl(flv.start_date_active,sysdate) and nvl(flv.end_date_active,sysdate) and flv.language = nvl((select fl.language_code from fnd_languages fl where fl.installed_flag in ('B','I') and language_code = userenv('lang')),fnd_global.base_language ) order by value US Order Type 13 120 1=1 mosv.order_type!=18 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Exclude Onhand Supply 14 130 1=1 mosv.new_due_date >= :p_sugg_due_date_fr Date US Suggested Due Date From 15 140 1=1 mosv.new_due_date<:p_sugg_due_date_to+1 Date last_day(:$flex$.suggested_due_date_from) US Suggested Due Date To 16 150 1=1 mosv.new_start_date >= :p_sugg_start_date_fr Date US Suggested Start Date From 17 160 1=1 mosv.new_start_date<:p_sugg_start_date_to+1 Date last_day(:$flex$.suggested_start_date_from) US Suggested Start Date To :$flex$.category Category Item :$flex$.category_set Category Set Category :$flex$.category_set Category Set Item :$flex$.organization_code Organization Code Buyer :$flex$.organization_code Organization Code Category Set :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Plan :$flex$.organization_code Organization Code Planner :$flex$.plan Plan Item :$flex$.plan Plan Planner :$flex$.suggested_due_date_from Suggested Due Date From Y Suggested Due Date To :$flex$.suggested_start_date_from Suggested Start Date From Y Suggested Start Date To Plan Orders Y Plan Orders with no Pegging Details ERIC.CLEGG ABC_CLASS 34 ABS_QTY 26 ACTION_REQUIRED 11 BUYER_NAME 5 CATEGORY 6 CATEGORY1 7 CATEGORY2 CATEGORY_SET DAYS_FROM_TODAY 36 DEMAND_CNT DEMAND_ID 33 DEMAND_QTY 29 END_PEGGING_ID FIRM FIRM_DATE FIRM_QUANTITY FIXED_LT FOR_RELEASE FULL_LT INSTANCE INTRANSIT_LT 3 ITEM 3 4 ITEM_DESCRIPTION LAST_UPDATE_DATE 8 MAKE_BUY 18 NEED_BY_DATE 19 OLD_DUE_DATE 20 OLD_NEED_BY_DATE 15 ORDER_NUMBER 7 ORDER_PRIORITY 14 ORDER_TYPE 6 2 ORGANIZATION 2 28 PEGGING_ID PEG_ALLOCATED_QUANTITY PEG_DAYS_FROM_TODAY 30 PEG_DEMAND_ID PEG_NEED_BY_DATE PEG_OLD_DUE_DATE PEG_OLD_NEED_BY_DATE PEG_ORDER_ACTION PEG_ORDER_FOR_RELEASE PEG_ORDER_NUMBER PEG_ORDER_QTY PEG_ORDER_RELEASED_STATUS PEG_ORDER_TYPE PEG_PROMISE_DATE PEG_RELEASED_QTY PEG_SOURCE_ORGANIZATION PEG_SUGGESTED_DUE_DATE PEG_SUGGESTED_ORDER_DATE PEG_SUGGESTED_START_DATE PEG_SUPPLIER PEG_SUPPLIER_SITE PEG_SUPPLY_DEMAND 31 PEG_TRANSACTION_ID 1 PLAN 1 10 PLANNER PLANNING_TIME_FENCE_DATE POST_PROCESSING_LT PRE_PROCESSING_LT PROMISE_DATE 21 QTY 22 RELEASED_QTY RELEASED_STATUS RESCHEDULE_DAYS 9 SAFETY_STOCK SCHEDULE_COMPRESSION_DAYS 23 SOURCE_ORGANIZATION SUBINVENTORY 12 SUGGESTED_DUE_DATE 4 16 SUGGESTED_ORDER_DATE 17 SUGGESTED_START_DATE 24 SUPPLIER 25 SUPPLIER_SITE 35 SUPPLY_CNT 13 SUPPLY_DEMAND 5 32 SUPPLY_QTY TRANSACTION_ID 27 USING_ASSEMBLY VARIABLE_LT S Site Plan Orders with Pegging Y Plan Orders with Pegging Details ERIC.CLEGG ABC_CLASS 48 ABS_QTY 26 ACTION_REQUIRED 11 BUYER_NAME 5 CATEGORY 6 CATEGORY1 7 CATEGORY2 CATEGORY_SET DAYS_FROM_TODAY 50 DEMAND_CNT DEMAND_ID 47 DEMAND_QTY 43 END_PEGGING_ID FIRM FIRM_DATE FIRM_QUANTITY FIXED_LT FOR_RELEASE FULL_LT INSTANCE INTRANSIT_LT 3 ITEM 3 4 ITEM_DESCRIPTION LAST_UPDATE_DATE 8 MAKE_BUY 18 NEED_BY_DATE 19 OLD_DUE_DATE 20 OLD_NEED_BY_DATE 15 ORDER_NUMBER 7 ORDER_PRIORITY 14 ORDER_TYPE 6 2 ORGANIZATION 2 42 PEGGING_ID 30 PEG_ALLOCATED_QUANTITY PEG_DAYS_FROM_TODAY 44 PEG_DEMAND_ID 37 PEG_NEED_BY_DATE PEG_OLD_DUE_DATE PEG_OLD_NEED_BY_DATE 41 PEG_ORDER_ACTION PEG_ORDER_FOR_RELEASE 32 PEG_ORDER_NUMBER 10 33 PEG_ORDER_QTY 11 PEG_ORDER_RELEASED_STATUS 31 PEG_ORDER_TYPE 9 PEG_PROMISE_DATE 34 PEG_RELEASED_QTY 38 PEG_SOURCE_ORGANIZATION 29 PEG_SUGGESTED_DUE_DATE 8 35 PEG_SUGGESTED_ORDER_DATE 36 PEG_SUGGESTED_START_DATE 39 PEG_SUPPLIER 40 PEG_SUPPLIER_SITE 28 PEG_SUPPLY_DEMAND 45 PEG_TRANSACTION_ID 1 PLAN 1 10 PLANNER PLANNING_TIME_FENCE_DATE POST_PROCESSING_LT PRE_PROCESSING_LT PROMISE_DATE 21 QTY 22 RELEASED_QTY RELEASED_STATUS RESCHEDULE_DAYS 9 SAFETY_STOCK SCHEDULE_COMPRESSION_DAYS 23 SOURCE_ORGANIZATION SUBINVENTORY 12 SUGGESTED_DUE_DATE 4 16 SUGGESTED_ORDER_DATE 17 SUGGESTED_START_DATE 24 SUPPLIER 25 SUPPLIER_SITE 49 SUPPLY_CNT 13 SUPPLY_DEMAND 5 46 SUPPLY_QTY TRANSACTION_ID 27 USING_ASSEMBLY VARIABLE_LT S Site