Label : Name Nbt_data_collector_name Display. Query. Label : From Date Eff_from_date Display. Query. Format : DD-MON-YYYY. Label : To Date Eff_to_date Display. Query. Format : DD-MON-YYYY. Block: Base table on idb_mkt_ppt_role_in_gsp_group. MPRIGG_DI Query only. Where mkt_ppt_role_code = ‘R’, ctrl_nav.nbt_query_date between eff_from_date and eff_to_date and exists (idb_mkt_ppt_roles.mkt_ppt_id = mkt_ppt_id where active_flag = ‘Y’) and igg.gsp_group_id = gsp_group_id Order by mkt_ppt_id. Label : Distributor Mkt_ppt_id Display. Query. Label : Name Nbt_distributor_name Display. Query. Label : From Settlement Date Eff_From_date Display. Query. Format : DD-MON-YYYY. Label : To Settlement Date Eff_To_date Display. Query. Format : DD-MON-YYYY. Block: Base table on idb_da_summaries view. DASU Query allowed. Where mkt_ppt_role_code in ‘B’,’A’ and exists (idb_mkt_ppt_roles.mkt_ppt_id = da_mkt_ppt_id where active_flag = ‘Y’) and igg.gsp_group_id = gsp_group_id Order by mkt_ppt_id, mkt_ppt_role_code Label : Data Aggregator da_Mkt_ppt_id Display. Query. Label : Name Nbt_aggregator_name Display. Query.
Nbt_data_collector_name Label : Name Display. Query. Eff_from_date Label : From Date Display. Query. Format : DD-MON-YYYY. Eff_to_date Label : To Date Display. Query. Format : DD-MON-YYYY. Block: MPRIGG_DI Base table on idb_mkt_ppt_role_in_gsp_group. Query only. Where mkt_ppt_role_code = ‘R’, ctrl_nav.nbt_query_date between eff_from_date and eff_to_date and exists (idb_mkt_ppt_roles.mkt_ppt_id = mkt_ppt_id where active_flag = ‘Y’) and igg.gsp_group_id = gsp_group_id Order by mkt_ppt_id. Mkt_ppt_id Label : Distributor Display. Query. Nbt_distributor_name Label : Name Display. Query. Eff_From_date Label : From Settlement Date Display. Query. Format : DD-MON-YYYY. Eff_To_date Label : To Settlement Date Display. Query. Format : DD-MON-YYYY. Block: DASU Base table on idb_da_summaries view. Query allowed. Where mkt_ppt_role_code in ‘B’,’A’ and exists (idb_mkt_ppt_roles.mkt_ppt_id = da_mkt_ppt_id where active_flag = ‘Y’) and igg.gsp_group_id = gsp_group_id Order by mkt_ppt_id, mkt_ppt_role_code da_Mkt_ppt_id Label : Data Aggregator Display. Query. Nbt_aggregator_name Label : Name Display. Query.