Oracle Ebs-sql (BOM-4): Total number of new encodings during the check. SQL

Source: Internet
Author: User

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.