APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_PERIODS

Line 415: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_periods';

411: END IF;
412: l_count := Plan_List%ROWCOUNT;
413: CLOSE Plan_List;
414:
415: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_periods';
416: EXECUTE IMMEDIATE l_trunc_stmt;
417: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_periods has been truncated.');
418:
419: BIS_COLLECTION_UTILITIES.put_line('Begin to load the base tables from APS instance.');

Line 417: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_periods has been truncated.');

413: CLOSE Plan_List;
414:
415: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_periods';
416: EXECUTE IMMEDIATE l_trunc_stmt;
417: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_periods has been truncated.');
418:
419: BIS_COLLECTION_UTILITIES.put_line('Begin to load the base tables from APS instance.');
420: FII_UTIL.Start_Timer;
421:

Line 497: 'INTO isc_dbi_periods (ORGANIZATION_ID,PERIOD_SET_NAME,PERIOD_NAME,'||

493: 'origination_type,uom_code,using_assembly_demand_date,'||
494: 'average_discount,list_price,selling_price,standard_cost,using_requirement_quantity,'||
495: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login) '||
496: 'WHEN union_flag = 9 THEN '||
497: 'INTO isc_dbi_periods (ORGANIZATION_ID,PERIOD_SET_NAME,PERIOD_NAME,'||
498: 'START_DATE,END_DATE,YEAR_START_DATE,QUARTER_START_DATE,'||
499: 'PERIOD_TYPE,PERIOD_YEAR,PERIOD_NUM,QUARTER_NUM,'||
500: 'ENTERED_PERIOD_NAME,ADJUSTMENT_PERIOD_FLAG,DESCRIPTION,'||
501: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||

Line 941: TABNAME => 'ISC_DBI_PERIODS');

937: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_large_bases(j));
938: END LOOP;
939:
940: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
941: TABNAME => 'ISC_DBI_PERIODS');
942:
943: FII_UTIL.Stop_Timer;
944: FII_UTIL.Print_Timer('Analyzed the base tables in');
945:

Line 1997: isc_dbi_periods per,

1993: 1 UNION1_FLAG,
1994: 0 UNION2_FLAG
1995: FROM isc_dbi_tmp_plans tmp,
1996: isc_dbi_inv_detail_f iinv,
1997: isc_dbi_periods per,
1998: fii_time_day time1
1999: WHERE tmp.plan_id = iinv.plan_id
2000: AND bitand(tmp.plan_usage, 2) = 2
2001: AND iinv.organization_id = per.organization_id

Line 2069: isc_dbi_periods per,

2065: sum(nvl(required_hours,0)/(per.end_date-per.start_date+1)) REQUIRED_HOURS,
2066: sum(nvl(available_hours,0)/(per.end_date-per.start_date+1)) AVAILABLE_HOURS
2067: FROM isc_dbi_tmp_plans tmp,
2068: isc_dbi_res_summary_f ires,
2069: isc_dbi_periods per,
2070: fii_time_day time
2071: WHERE tmp.plan_id = ires.plan_id
2072: AND bitand(tmp.plan_usage, 2) = 2
2073: AND ires.organization_id = per.organization_id