Select
Fu.description Creator,
Msi. Creation_date Settling Time,
Msi.segment1 Material Code,
Msi. DESCRIPTION Material Description,
Msi. Inventory_item_status_code Item Status,
DECODE (MSI. Mrp_planning_code, ' 3 ', ' MRP ', ' 4 ', ' MPS ', ' 6 ', ' unplanned ') planning method,
Msi. Planner_code Planner,
--decode (MSI. Item_type, ' FG ', ' finished ', ' SA ', ' sub-assembly ', ' P ', ' purchase ', ' MP ', ' homemade and purchase ' type,
DECODE (MSI. Planning_make_buy_code, ' 1 ', ' manufacturing ', ' 2 ', ' buy ') manufacturing purchases,
PER. Last_Name Buyer,
Msi. Postprocessing_lead_time Inspection Cycle,
Msi. Fixed_order_quantity Fixed Order quantity,
Msi. Minimum_order_quantity Minimum Order quantity,
Msi. Fixed_days_supply Fixed days supply,
FLV. Meaning supply type,
Msi. Wip_supply_subinventory Supply Sub-Library,
Msi. Fixed_lot_multiplier Fixed Batch multiples,
Msi.primary_unit_of_measure main unit of measurement,
Msi.purchasing_item_flag whether to purchase
From Inv. Mtl_system_items_b MSI,
APPS. Per_people_f PER,
APPS. Fnd_lookup_values FLV,
Inv. Mtl_system_items_tl Msit,
Applsys.fnd_user FU
WHERE msi.organization_id = X and
msit.inventory_item_id = msi.inventory_item_id and
msit.organization_id = msi.organization_id and msit.language = ' ZHS ' and
Msi. buyer_id = PER. PERSON_ID (+) and FLV. LANGUAGE = ' ZHS ' and
FLV. Lookup_type (+) = ' wip_supply ' and
FLV. Lookup_code (+) = MSI. Wip_supply_type
and FU. User_id=msi. Created_by
and (Trunc (MSI). creation_date) between to_date (' 20**-01-01 ', ' yyyy-mm-dd ') and to_date (' 20**-01-31 ', ' yyyy-mm-dd ')-- Enter a specific time frame here (month-day-year)