[Home] [Help]
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
21: is
22: t msc_apcc_fact_type_table := msc_apcc_fact_type_table();
23: n number;
24: begin
18: end item_dim_table;
19:
20: function meta_info return msc_apcc_fact_type_table
21: is
22: t msc_apcc_fact_type_table := msc_apcc_fact_type_table();
23: n number;
24: begin
25: t.extend(15);
26: t(1) := msc_apcc_fact_type(1, 'msc_supply_pkg', 'supplies', '11.5.10', 'supply_date', 1);
1616: procedure gather_items(p_query_id number, p_fact_type number, p_plan_id number, p_plan_run_id number)
1617: is
1618: l_table varchar2(30);
1619: l_is_plan boolean := (p_fact_type <> 4);
1620: l_meta_info msc_apcc_fact_type_table := meta_info;
1621: l_item_columns varchar2(100);
1622: l_sql varchar2(1000);
1623: begin
1624: l_table := upper('msc_'||l_meta_info(p_fact_type).entity_name||'_f');