APPS.MSC_ATP_PF dependencies on ALL_TAB_PARTITIONS

Line 9300: FROM all_tab_partitions

9296:
9297: BEGIN
9298: SELECT count(*)
9299: INTO l_count
9300: FROM all_tab_partitions
9301: WHERE table_name = l_table_name
9302: AND partition_name = l_partition_name
9303: AND table_owner = l_msc_schema;
9304: EXCEPTION

Line 9375: FROM all_tab_partitions t,

9371:
9372: /* Create temp table in tablespace of MSC_ALLOC_DEMANDS*/
9373: SELECT t.tablespace_name, NVL(i.def_tablespace_name, t.tablespace_name)
9374: INTO l_tbspace, l_ind_tbspace
9375: FROM all_tab_partitions t,
9376: all_part_indexes i
9377: WHERE t.table_owner = l_msc_schema
9378: AND t.table_name = 'MSC_ALLOC_DEMANDS'
9379: AND t.partition_name = 'ALLOC_DEMANDS_' || to_char(l_plan_id)

Line 9635: FROM all_tab_partitions t,

9631:
9632: IF p_demand_priority <> 'Y' THEN
9633: SELECT t.tablespace_name, NVL(i.def_tablespace_name, t.tablespace_name)
9634: INTO l_tbspace, l_ind_tbspace
9635: FROM all_tab_partitions t,
9636: all_part_indexes i
9637: WHERE t.table_owner = l_msc_schema
9638: AND t.table_name = 'MSC_ALLOC_DEMANDS'
9639: AND t.partition_name = 'ALLOC_DEMANDS_' || to_char(l_plan_id)

Line 9821: FROM all_tab_partitions t,

9817: l_temp_table := 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id);
9818:
9819: SELECT t.tablespace_name, NVL(i.def_tablespace_name, t.tablespace_name)
9820: INTO l_tbspace, l_ind_tbspace
9821: FROM all_tab_partitions t,
9822: all_part_indexes i
9823: WHERE t.table_owner = l_msc_schema
9824: AND t.table_name = 'MSC_ALLOC_SUPPLIES'
9825: AND t.partition_name = 'ALLOC_SUPPLIES_' || to_char(l_plan_id)