APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_PLAN_ORGANIZATIONS

Line 21: g_small_bases TableList := TableList('ISC_DBI_PLAN_ORGANIZATIONS', 'ISC_DBI_PLAN_BUCKETS', 'ISC_DBI_PLANS');

17: g_sec_global_rate_type VARCHAR2(15);
18: g_rebuild_snapshot_index VARCHAR2(1) := 'N';
19:
20: TYPE TableList IS TABLE OF VARCHAR2(80);
21: g_small_bases TableList := TableList('ISC_DBI_PLAN_ORGANIZATIONS', 'ISC_DBI_PLAN_BUCKETS', 'ISC_DBI_PLANS');
22: g_large_bases TableList := TableList('ISC_DBI_SUPPLIES_F','ISC_DBI_INV_DETAIL_F','ISC_DBI_RES_SUMMARY_F',
23: 'ISC_DBI_EXCEPTION_DETAILS_F','ISC_DBI_DEMANDS_F',
24: 'ISC_DBI_FULL_PEGGING_F');
25:

Line 432: 'INTO isc_dbi_plan_organizations ( '||

428: 'VALUES(plan_id,organization_id,compile_designator,constrained_flag, curr_cutoff_date,'||
429: 'curr_plan_type,curr_start_date,cutoff_date,data_start_date,description,complete_flag,'||
430: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login) '||
431: 'WHEN union_flag = 2 THEN '||
432: 'INTO isc_dbi_plan_organizations ( '||
433: 'PLAN_ID,ORGANIZATION_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||
434: 'VALUES(plan_id,organization_id,'||
435: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login) '||
436: 'WHEN union_flag = 3 THEN '||

Line 965: FROM isc_dbi_plan_organizations ido,

961: g_snapshot_date CONVERSION_DATE,
962: fii_currency.get_global_rate_primary(gsb.currency_code, g_snapshot_date) RATE,
963: fii_currency.get_global_rate_secondary(gsb.currency_code, g_snapshot_date) RATE2
964: FROM (SELECT distinct organization_id
965: FROM isc_dbi_plan_organizations ido,
966: isc_dbi_tmp_plans tmp
967: WHERE bitand(tmp.plan_usage, 2) = 2
968: AND ido.plan_id = tmp.plan_id) org,
969: GL_SETS_OF_BOOKS gsb,

Line 1591: isc_dbi_plan_organizations ipo

1587: ip.curr_plan_type, ip.cutoff_date, ip.data_start_date,
1588: ip.description, count(*), g_snapshot_date
1589: FROM isc_dbi_tmp_plans tmp,
1590: isc_dbi_plans ip,
1591: isc_dbi_plan_organizations ipo
1592: WHERE tmp.plan_id = ip.plan_id
1593: AND bitand(tmp.plan_usage, 2) = 2
1594: AND ip.plan_id = ipo.plan_id
1595: GROUP BY tmp.snapshot_id, ip.plan_id, ip.organization_id, ip.compile_designator, ip.constrained_flag, ip.curr_plan_type,

Line 1616: isc_dbi_plan_organizations ipo

1612: SNAPSHOT_ID,
1613: ORGANIZATION_ID)
1614: SELECT tmp.snapshot_id, ipo.organization_id
1615: FROM isc_dbi_tmp_plans tmp,
1616: isc_dbi_plan_organizations ipo
1617: WHERE tmp.plan_id = ipo.plan_id
1618: AND bitand(tmp.plan_usage, 2) = 2;
1619:
1620: FII_UTIL.Stop_Timer;

Line 1621: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_organizations in');

1617: WHERE tmp.plan_id = ipo.plan_id
1618: AND bitand(tmp.plan_usage, 2) = 2;
1619:
1620: FII_UTIL.Stop_Timer;
1621: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_organizations in');
1622: -- COMMIT;
1623:
1624: -- ----------------------------------
1625: -- Collect ISC_DBI_SUPPLIES_SNAPSHOTS