APPS.MSC_POST_PRO dependencies on ALL_TAB_PARTITIONS

Line 202: FROM ALL_TAB_PARTITIONS

198: SELECT count(*)
199: INTO l_count
200: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
201: --FROM DBA_TAB_PARTITIONS
202: FROM ALL_TAB_PARTITIONS
203: WHERE TABLE_NAME = l_table_name
204: AND PARTITION_NAME = l_partition_name
205: AND table_owner = l_msc_schema;
206: EXCEPTION

Line 1176: FROM ALL_TAB_PARTITIONS

1172: SELECT count(*)
1173: INTO l_count
1174: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
1175: --FROM DBA_TAB_PARTITIONS
1176: FROM ALL_TAB_PARTITIONS
1177: WHERE TABLE_NAME = l_table_name
1178: AND PARTITION_NAME = l_partition_name
1179: AND table_owner = l_msc_schema;
1180: EXCEPTION

Line 3471: FROM all_tab_partitions

3467: BEGIN
3468: SELECT partition_name
3469: INTO l_name
3470: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
3471: FROM all_tab_partitions
3472: WHERE table_name = l_table_name
3473: AND table_owner = p_owner
3474: AND partition_name = l_partition_name;
3475:

Line 3732: FROM ALL_TAB_PARTITIONS

3728: SELECT count(*)
3729: INTO l_count
3730: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
3731: --FROM DBA_TAB_PARTITIONS
3732: FROM ALL_TAB_PARTITIONS
3733: WHERE TABLE_NAME = l_table_name
3734: AND PARTITION_NAME = l_partition_name
3735: AND table_owner = l_msc_schema;
3736: EXCEPTION

Line 3793: from ALL_tab_partitions

3789: select count(*)
3790: into l_count
3791: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
3792: --from dba_tab_partitions
3793: from ALL_tab_partitions
3794: where table_name = l_table_name
3795: and table_owner = l_msc_schema
3796: and partition_name = l_partition_name;
3797: EXCEPTION

Line 3819: from all_tab_partitions

3815: select count(*)
3816: into l_count
3817: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
3818: --from dba_tab_partitions
3819: from all_tab_partitions
3820: where table_name = l_table_name
3821: and table_owner = l_msc_schema
3822: and partition_name = l_partition_name;
3823: EXCEPTION

Line 3882: from all_tab_partitions

3878: select count(*)
3879: into l_count
3880: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
3881: --from dba_tab_partitions
3882: from all_tab_partitions
3883: where table_name = l_table_name
3884: and table_owner = l_msc_schema
3885: and partition_name = l_partition_name;
3886: EXCEPTION

Line 4226: FROM all_tab_partitions

4222: SELECT count(*)
4223: INTO l_count
4224: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
4225: --FROM dba_tab_partitions
4226: FROM all_tab_partitions
4227: WHERE table_name = l_table_name
4228: AND partition_name = l_partition_name
4229: AND table_owner = l_msc_schema;
4230: EXCEPTION

Line 5102: FROM all_tab_partitions t,

5098: INTO l_tbspace, l_ind_tbspace
5099: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
5100: --FROM dba_tab_partitions t,
5101: -- dba_part_indexes i
5102: FROM all_tab_partitions t,
5103: all_part_indexes i
5104: WHERE t.table_owner = l_msc_schema
5105: AND t.table_name = 'MSC_ALLOC_DEMANDS'
5106: AND t.partition_name = 'ALLOC_DEMANDS_' || to_char(l_plan_id)

Line 5654: FROM all_tab_partitions t,

5650: INTO l_tbspace, l_ind_tbspace
5651: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
5652: --FROM dba_tab_partitions t,
5653: -- dba_part_indexes i
5654: FROM all_tab_partitions t,
5655: all_part_indexes i
5656: WHERE t.table_owner = l_msc_schema
5657: AND t.table_name = 'MSC_ALLOC_SUPPLIES'
5658: AND t.partition_name = 'ALLOC_SUPPLIES_' || to_char(l_plan_id)