[Home] [Help]
MATERIALIZED VIEW: APPS.ENI_DBI_CO_DNUM_MV
Source
select /* 12.0: bug#4526784 */ organization_id
, item_id
, item_id||'-'||organization_id item_org_id
, change_order_type_id
, reason_code
, priority_code
, status_type
, creation_date
, implementation_date
, cancellation_date
, approval_date
, need_by_date
, count(*) cnt
from eni_dbi_co_num_mv
group by organization_id
, item_id
, change_order_type_id
, reason_code
, priority_code
, status_type
, creation_date
, implementation_date
, cancellation_date
, approval_date
, need_by_date