[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;