DBA Data[Home] [Help]

APPS.PMI_SUMM_TAB_PURGE dependencies on PMI_PROD_SUM

Line 8: ELSIF stable = 'PMI_PROD_SUM' THEN

4: BEGIN
5: IF stable = 'PMI_ONHAND_SALE_SUM' THEN
6: DELETE PMI_ONHAND_SALE_SUM;
7: commit;
8: ELSIF stable = 'PMI_PROD_SUM' THEN
9: DELETE PMI_PROD_SUM;
10: commit;
11: END IF;
12: DELETE PMI_SUMMARY_LOG_TABLE

Line 9: DELETE PMI_PROD_SUM;

5: IF stable = 'PMI_ONHAND_SALE_SUM' THEN
6: DELETE PMI_ONHAND_SALE_SUM;
7: commit;
8: ELSIF stable = 'PMI_PROD_SUM' THEN
9: DELETE PMI_PROD_SUM;
10: commit;
11: END IF;
12: DELETE PMI_SUMMARY_LOG_TABLE
13: WHERE SUMMARY_TABLE = stable;