[Home] [Help]
MATERIALIZED VIEW: APPS.OKI_SRM_019_MV
Source
Select /* 12.0: bug#4526784 */ 'RESOURCE' UMARKER
, authoring_org_id
, RESOURCE_GROUP_ID rg_id
, RESOURCE_GROUP_ID prg_id
, NVL (resource_id, -1) resource_id
, SERVICE_ITEM_ORG_ID
, SERVICE_ITEM_CATEGORY_ID
, GROUPING_ID ( RESOURCE_GROUP_ID
,NVL (resource_id, -1)
,authoring_org_id
,SERVICE_ITEM_ORG_ID
,SERVICE_ITEM_CATEGORY_ID
,ENT_YEAR_ID) GRP_ID
, ENT_YEAR_ID
, SUM (price_negotiated_f) B_R_AMT_F
, SUM (price_negotiated_g ) B_R_AMT_G
, SUM (price_negotiated_sg) B_R_AMT_SG
, SUM (price_negotiated_a ) B_R_AMT_A
, COUNT (price_negotiated_f) C_B_R_AMT_F
, COUNT (price_negotiated_g ) C_B_R_AMT_G
, COUNT (price_negotiated_sg) C_B_R_AMT_SG
, COUNT (price_negotiated_a ) C_B_R_AMT_A
, count(*) AS c_total FROM oki_Srm_001_mv f
,OKI_TIME_ENT_YEAR_MV YEAR
WHERE
f.renewal_flag =1
AND f.start_date < year.start_date
AND COALESCE(f.date_signed, f.date_cancelled, year.start_date + 1) >= year.start_date
GROUP BY resource_group_id,
NVL (resource_id, -1),
SERVICE_ITEM_ORG_ID,
SERVICE_ITEM_CATEGORY_ID,
authoring_org_id,
ENT_YEAR_ID