APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on MSC_COLL_SNAPSHOTS_V

Line 1752: from msc_coll_snapshots_v

1748: lv_mrp_schema := MSC_UTIL.G_MRP_SCHEMA;
1749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'MRP schema - ' || lv_mrp_schema);
1750:
1751: lv_cusros_str := ' select mview_name, existance_check
1752: from msc_coll_snapshots_v
1753: where mview_name in ' || lv_snapshot_groups_str || '
1754: or snapshot_group_string in ' || lv_snapshot_groups_str ;
1755:
1756: OPEN c_snap for lv_cusros_str;

Line 2181: lv_update_cr_stmt:= 'UPDATE MSC_COLL_SNAPSHOTS_V '

2177: -- we will add the single quote in the first and last place
2178: lv_snapshot_str_tmp := '''' || lv_snapshot_str_tmp || '''';
2179:
2180:
2181: lv_update_cr_stmt:= 'UPDATE MSC_COLL_SNAPSHOTS_V '
2182: || ' SET complete_refresh_timestamp = to_char(sysdate,''YYYY-MM-DD HH24:MI:SS'') '
2183: || ' WHERE MVIEW_NAME in ( '
2184: || ' SELECT mview_name from all_mviews WHERE mview_name in (' || lv_snapshot_str_tmp || ') '
2185: || ' and last_refresh_type= ''COMPLETE'' AND owner = '

Line 2803: FROM MSC_COLL_SNAPSHOTS_V

2799:
2800: ELSE -- automatic or force
2801: SELECT master_table, erp_product_code
2802: INTO lv_base_table_name,lv_erp_product_code
2803: FROM MSC_COLL_SNAPSHOTS_V
2804: WHERE mview_name = lv_snapshot_name;
2805:
2806: lv_base_schema := MSC_UTIL.GET_SCHEMA_NAME(lv_erp_product_code);
2807:

Line 2890: UPDATE MSC_COLL_SNAPSHOTS_V

2886: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '---------------------------------------------');
2887:
2888:
2889: IF lv_refresh_param = 'C' THEN
2890: UPDATE MSC_COLL_SNAPSHOTS_V
2891: SET complete_refresh_timestamp = to_char(sysdate,'YYYY-MM-DD HH:MI:SS')
2892: WHERE MVIEW_NAME = lv_snapshot_name ;
2893:
2894: COMMIT;

Line 2955: from msc_coll_snapshots_v

2951:
2952: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_snapshot_groups_str);
2953:
2954: lv_cusror_str := ' select mview_name, existance_check
2955: from msc_coll_snapshots_v
2956: where mview_name in ' || lv_snapshot_groups_str || '
2957: or snapshot_group_string in ' || lv_snapshot_groups_str ;
2958:
2959: OPEN c_snap for lv_cusror_str;

Line 3048: from msc_coll_snapshots_v

3044:
3045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_snapshot_groups_str);
3046:
3047: lv_cusror_str := ' select mview_name, existance_check
3048: from msc_coll_snapshots_v
3049: where mview_name in ' || lv_snapshot_groups_str || '
3050: or snapshot_group_string in ' || lv_snapshot_groups_str ;
3051:
3052: OPEN c_snap for lv_cusror_str;

Line 3139: from msc_coll_snapshots_v

3135: IF p_last_tgt_cont_coll_time is NOT NULL THEN
3136: BEGIN
3137: select 1 , existance_check
3138: into lv_MV_complete_refresh, lv_existance_check
3139: from msc_coll_snapshots_v
3140: where mview_name = p_MV_name
3141: and nvl(to_date(complete_refresh_timestamp,'YYYY-MM-DD HH:MI:SS'),p_last_tgt_cont_coll_time) > p_last_tgt_cont_coll_time;
3142:
3143: if NOT eval(lv_existance_check) then

Line 3262: from msc_coll_snapshots_v

3258: IF p_last_tgt_cont_coll_time is NOT NULL THEN
3259: BEGIN
3260: Execute immediate '
3261: select 1
3262: from msc_coll_snapshots_v
3263: where snapshot_group_string = ''' || p_entity_name || '''
3264: and existance_check = to_char(' || MSC_UTIL.SYS_YES || ')
3265: and check_for_cont_refresh = ' || MSC_UTIL.SYS_YES || '
3266: and to_date(nvl(complete_refresh_timestamp,to_char(:vDate,''YYYY-MM-DD HH:MI:SS'')),''YYYY-MM-DD HH:MI:SS'') > :vDate

Line 3281: from msc_coll_snapshots_v

3277: END IF;
3278: END IF;
3279:
3280: lv_cusros_str := ' select mview_name, ad_table_name, existance_check
3281: from msc_coll_snapshots_v
3282: where check_for_cont_refresh = ' || MSC_UTIL.SYS_YES || '
3283: and snapshot_group_string = ''' || p_entity_name || '''' ;
3284:
3285: OPEN c_snap for lv_cusros_str;