APPS.MRP_GET_ORDER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

  select po_number
  from mrp_item_purchase_orders
  where transaction_id = arg_disp_id
  and compile_designator = arg_compile_desig
  and organization_id = arg_org_id
  and inventory_item_id = arg_item_id;

Line: 26

  select wip_entity_name
  from mrp_item_wip_entities
  where wip_entity_id = arg_disp_id
  and compile_designator = arg_compile_desig
  and organization_id = arg_org_id
  and inventory_item_id = arg_item_id;

Line: 34

  select wip_entity_name
  from mrp_item_wip_entities
  where wip_entity_id = arg_disp_id
  and compile_designator = arg_compile_desig
  and organization_id = arg_org_id
  and inventory_item_id = arg_by_prod_assy_id;

Line: 108

  select so.segment1||':'||so.segment2||':'||so.segment3
  from
        mtl_sales_orders so, mrp_schedule_dates msd
  where
        msd.mps_transaction_id = arg_demand_id
        and msd.schedule_level =3
        and so.sales_order_id = msd.source_sales_order_id;