APPS.MSC_ATP_PF dependencies on ALL_TAB_PARTITIONS

Line 9326: FROM all_tab_partitions

9322:
9323: BEGIN
9324: SELECT count(*)
9325: INTO l_count
9326: FROM all_tab_partitions
9327: WHERE table_name = l_table_name
9328: AND partition_name = l_partition_name
9329: AND table_owner = l_msc_schema;
9330: EXCEPTION

Line 9401: FROM all_tab_partitions t,

9397:
9398: /* Create temp table in tablespace of MSC_ALLOC_DEMANDS*/
9399: SELECT t.tablespace_name, NVL(i.def_tablespace_name, t.tablespace_name)
9400: INTO l_tbspace, l_ind_tbspace
9401: FROM all_tab_partitions t,
9402: all_part_indexes i
9403: WHERE t.table_owner = l_msc_schema
9404: AND t.table_name = 'MSC_ALLOC_DEMANDS'
9405: AND t.partition_name = 'ALLOC_DEMANDS_' || to_char(l_plan_id)

Line 9661: FROM all_tab_partitions t,

9657:
9658: IF p_demand_priority <> 'Y' THEN
9659: SELECT t.tablespace_name, NVL(i.def_tablespace_name, t.tablespace_name)
9660: INTO l_tbspace, l_ind_tbspace
9661: FROM all_tab_partitions t,
9662: all_part_indexes i
9663: WHERE t.table_owner = l_msc_schema
9664: AND t.table_name = 'MSC_ALLOC_DEMANDS'
9665: AND t.partition_name = 'ALLOC_DEMANDS_' || to_char(l_plan_id)

Line 9847: FROM all_tab_partitions t,

9843: l_temp_table := 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id);
9844:
9845: SELECT t.tablespace_name, NVL(i.def_tablespace_name, t.tablespace_name)
9846: INTO l_tbspace, l_ind_tbspace
9847: FROM all_tab_partitions t,
9848: all_part_indexes i
9849: WHERE t.table_owner = l_msc_schema
9850: AND t.table_name = 'MSC_ALLOC_SUPPLIES'
9851: AND t.partition_name = 'ALLOC_SUPPLIES_' || to_char(l_plan_id)