eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_PHUB_PKG dependencies on MSC_APCC_ITEM_D

Line 16: select 'MSC_APCC_ITEM_D' bulk collect into l_tables from dual;

12: function item_dim_table return object_names
13: is
14: l_tables object_names;
15: begin
16: select 'MSC_APCC_ITEM_D' bulk collect into l_tables from dual;
17: return l_tables;
18: end item_dim_table;
19:
20: function meta_info return msc_apcc_fact_type_table

Line 1259: insert into msc_apcc_item_d (

1255: exception
1256: when others then null;
1257: end;
1258:
1259: insert into msc_apcc_item_d (
1260: plan_id,
1261: sr_instance_id,
1262: organization_id,
1263: inventory_item_id,

Line 1350: from msc_apcc_item_d

1346: fnd_global.conc_program_id, fnd_global.conc_login_id,
1347: fnd_global.prog_appl_id, fnd_global.conc_request_id
1348: from
1349: (select distinct sr_instance_id, sr_category_id1 sr_category_id
1350: from msc_apcc_item_d
1351: where plan_id=p_plan_id and sr_category_id1>=0
1352: union
1353: select distinct sr_instance_id, sr_category_id2 sr_category_id
1354: from msc_apcc_item_d

Line 1354: from msc_apcc_item_d

1350: from msc_apcc_item_d
1351: where plan_id=p_plan_id and sr_category_id1>=0
1352: union
1353: select distinct sr_instance_id, sr_category_id2 sr_category_id
1354: from msc_apcc_item_d
1355: where plan_id=p_plan_id and sr_category_id2>=0
1356: union
1357: select distinct sr_instance_id, sr_category_id3 sr_category_id
1358: from msc_apcc_item_d

Line 1358: from msc_apcc_item_d

1354: from msc_apcc_item_d
1355: where plan_id=p_plan_id and sr_category_id2>=0
1356: union
1357: select distinct sr_instance_id, sr_category_id3 sr_category_id
1358: from msc_apcc_item_d
1359: where plan_id=p_plan_id and sr_category_id3>=0
1360: union
1361: select distinct sr_instance_id, pegging_sr_category_id sr_category_id
1362: from msc_apcc_item_d

Line 1362: from msc_apcc_item_d

1358: from msc_apcc_item_d
1359: where plan_id=p_plan_id and sr_category_id3>=0
1360: union
1361: select distinct sr_instance_id, pegging_sr_category_id sr_category_id
1362: from msc_apcc_item_d
1363: where plan_id=p_plan_id and pegging_sr_category_id>=0
1364: ) b,
1365: (select distinct sr_instance_id, sr_category_id1
1366: from msc_apcc_item_d

Line 1366: from msc_apcc_item_d

1362: from msc_apcc_item_d
1363: where plan_id=p_plan_id and pegging_sr_category_id>=0
1364: ) b,
1365: (select distinct sr_instance_id, sr_category_id1
1366: from msc_apcc_item_d
1367: where plan_id=p_plan_id
1368: ) c1,
1369: (select distinct sr_instance_id, sr_category_id2
1370: from msc_apcc_item_d

Line 1370: from msc_apcc_item_d

1366: from msc_apcc_item_d
1367: where plan_id=p_plan_id
1368: ) c1,
1369: (select distinct sr_instance_id, sr_category_id2
1370: from msc_apcc_item_d
1371: where plan_id=p_plan_id
1372: ) c2,
1373: (select distinct sr_instance_id, sr_category_id3
1374: from msc_apcc_item_d

Line 1374: from msc_apcc_item_d

1370: from msc_apcc_item_d
1371: where plan_id=p_plan_id
1372: ) c2,
1373: (select distinct sr_instance_id, sr_category_id3
1374: from msc_apcc_item_d
1375: where plan_id=p_plan_id
1376: ) c3,
1377: (select distinct sr_instance_id, pegging_sr_category_id
1378: from msc_apcc_item_d

Line 1378: from msc_apcc_item_d

1374: from msc_apcc_item_d
1375: where plan_id=p_plan_id
1376: ) c3,
1377: (select distinct sr_instance_id, pegging_sr_category_id
1378: from msc_apcc_item_d
1379: where plan_id=p_plan_id
1380: ) c4,
1381: msc_plans p
1382: where b.sr_category_id=c1.sr_category_id1(+)

Line 1453: insert into msc_apcc_item_d (

1449: is
1450: begin
1451: msc_phub_util.log('msc_phub_pkg.build_items_from_pds('||p_plan_id||')');
1452: manage_partitions(item_dim_table, p_plan_id, partition_init, partition_list);
1453: insert into msc_apcc_item_d (
1454: plan_id,
1455: sr_instance_id,
1456: organization_id,
1457: inventory_item_id,

Line 1607: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_APCC_ITEM_D', p_plan_id);

1603: msc_phub_util.log('msc_phub_pkg.build_items_from_pds: insert='||sql%rowcount);
1604: commit;
1605:
1606: build_null_items(p_plan_id);
1607: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_APCC_ITEM_D', p_plan_id);
1608: msc_phub_util.log('msc_phub_pkg.build_items_from_pds: complete');
1609:
1610: exception
1611: when others then

Line 1681: delete from msc_apcc_item_d d

1677: -- prepare partition
1678: manage_partitions(item_dim_table, p_plan_id, partition_init, partition_list);
1679:
1680: -- delete existing items
1681: delete from msc_apcc_item_d d
1682: where d.plan_id=p_plan_id
1683: and exists (
1684: select 1 from msc_hub_query q
1685: where q.query_id=l_qid_plan_item

Line 1693: delete from msc_apcc_item_d d

1689: msc_phub_util.log('msc_phub_pkg.build_items_from_apcc: delete='||sql%rowcount);
1690: commit;
1691:
1692: -- delete existing items
1693: delete from msc_apcc_item_d d
1694: where d.plan_id=p_plan_id
1695: and d.inventory_item_id<0;
1696: msc_phub_util.log('msc_phub_pkg.build_items_from_apcc: delete='||sql%rowcount);
1697: commit;

Line 1700: insert into msc_apcc_item_d (

1696: msc_phub_util.log('msc_phub_pkg.build_items_from_apcc: delete='||sql%rowcount);
1697: commit;
1698:
1699: -- insert items
1700: insert into msc_apcc_item_d (
1701: plan_id,
1702: sr_instance_id,
1703: organization_id,
1704: inventory_item_id,

Line 1791: from msc_apcc_item_d d,

1787: fnd_global.user_id, sysdate,
1788: sysdate, fnd_global.user_id, fnd_global.login_id,
1789: fnd_global.conc_program_id, fnd_global.conc_login_id,
1790: fnd_global.prog_appl_id, fnd_global.conc_request_id
1791: from msc_apcc_item_d d,
1792: (select distinct
1793: number3 sr_instance_id,
1794: number4 organization_id,
1795: number5 inventory_item_id

Line 2121: ' from msc_apcc_item_d_bak'||

2117: begin
2118: msc_phub_util.log('msc_phub_pkg.migrate_item_d');
2119: open c for
2120: ' select distinct plan_id'||
2121: ' from msc_apcc_item_d_bak'||
2122: ' where plan_id>0'||
2123: ' order by 1';
2124: loop
2125: fetch c into l_plan_id;

Line 2132: ' insert into msc_apcc_item_d ('||

2128: end loop;
2129: close c;
2130:
2131: l_sql :=
2132: ' insert into msc_apcc_item_d ('||
2133: ' plan_id,'||
2134: ' sr_instance_id,'||
2135: ' organization_id,'||
2136: ' inventory_item_id,'||

Line 2221: ' from msc_apcc_item_d_bak';

2217: ' created_by, creation_date,'||
2218: ' last_update_date, last_updated_by, last_update_login,'||
2219: ' program_id, program_login_id,'||
2220: ' program_application_id, request_id'||
2221: ' from msc_apcc_item_d_bak';
2222: execute immediate l_sql;
2223: msc_phub_util.log('insert into msc_apcc_item_d: '||sql%rowcount);
2224: commit;
2225: exception

Line 2223: msc_phub_util.log('insert into msc_apcc_item_d: '||sql%rowcount);

2219: ' program_id, program_login_id,'||
2220: ' program_application_id, request_id'||
2221: ' from msc_apcc_item_d_bak';
2222: execute immediate l_sql;
2223: msc_phub_util.log('insert into msc_apcc_item_d: '||sql%rowcount);
2224: commit;
2225: exception
2226: when others then
2227: msc_phub_util.log('msc_phub_pkg.migrate_item_d.exception:'||sqlerrm);