MATERIALIZED VIEW: APPS.ISC_DR_CURR_01_MV

Source

select
  /* 12.0: bug#4526784 */
  fact.repair_line_id
, fact.inventory_item_id
, fact.repair_organization_id
, fact.master_organization_id
, item_org_id
, nvl(eoi.vbh_category_id,-1) product_category_id
, repair_type_id
, customer_id
, serial_number
, repair_number
, quantity
, status
, flow_status_id
, promise_date
, uom_code
, incident_number
, incident_id
, ( case
      when trunc(sysdate) > nvl(promise_date,sysdate + 1) then
        trunc(sysdate) - promise_date
      else null
    end
  ) past_due_days
, ( case
      when trunc(sysdate) > nvl(promise_date,sysdate + 1) then
        'Y'
      else 'N'
    end
  ) past_due_flag
, ( case
      when promise_date >= trunc(sysdate) then
        promise_date - trunc(sysdate)
      else null
    end
  ) days_until_promised
from
  ISC.ISC_DR_REPAIR_ORDERS_F fact
, ENI.ENI_OLTP_ITEM_STAR eoi
WHERE
    fact.status in ('O','D','H')
and fact.item_org_id = eoi.id