0 Replies Latest reply on Oct 2, 2014 3:10 AM by User910243567

    MRP and Supply Chain Query

    User910243567

      I am trying to find join the below view with PO header and PO Lines to get details. Can you please help.

       

      SELECT *

        FROM apps.mrp_orders_sc_v mos,

             APPS.MRP_SYSTEM_ITEMS_SC_V mrsi,

             apps.mrp_plans_sc_v MP

      -- apps.PO_PO_SUPPLY_VIEW ppsv

      WHERE     MOS.COMPILE_DESIGNATOR = MRSI.COMPILE_DESIGNATOR

             AND MOS.ORGANIZATION_ID = MRSI.ORGANIZATION_ID

             AND MOS.inventory_item_id = MRSI.inventory_item_id

             AND MP.compile_designator = MRSI.compile_designator

             AND MP.organization_id = MRSI.organization_id

             AND MOS.compile_designator = 'XXXXX'

             AND MOS.ORDER_NUMBER IS NOT NULL

             AND MOS.order_number = '12345'

       

      Thanks!