APPS.MSC_SNAPSHOT_PK dependencies on MSC_ITEM_SO_SR_LEVELS

Line 833: /* DBMS_MVIEW.REFRESH ('MSC_ITEM_SO_SR_LEVELS_MV','c');

829: lv_dummy1 varchar2(32);
830: lv_dummy2 varchar2(32);
831: lv_msc_schema varchar2(32);
832: BEGIN
833: /* DBMS_MVIEW.REFRESH ('MSC_ITEM_SO_SR_LEVELS_MV','c');
834: DBMS_MVIEW.REFRESH ('MSC_ITEM_FCST_SR_LEVELS_MV','c');*/
835:
836: IF p_plan_id is NULL THEN
837: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', lv_dummy1, lv_dummy2, lv_msc_schema);

Line 839: lv_sql_stmt:= 'TRUNCATE TABLE '||lv_msc_schema||'.MSC_ITEM_SO_SR_LEVELS';

835:
836: IF p_plan_id is NULL THEN
837: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'MSC', lv_dummy1, lv_dummy2, lv_msc_schema);
838:
839: lv_sql_stmt:= 'TRUNCATE TABLE '||lv_msc_schema||'.MSC_ITEM_SO_SR_LEVELS';
840: EXECUTE IMMEDIATE lv_sql_stmt;
841:
842: lv_sql_stmt:= 'TRUNCATE TABLE '||lv_msc_schema||'.MSC_ITEM_FCST_SR_LEVELS';
843: EXECUTE IMMEDIATE lv_sql_stmt;

Line 848: DELETE MSC_ITEM_SO_SR_LEVELS where plan_id = p_plan_id;

844:
845: lv_plan_id := ' ';
846:
847: ELSE
848: DELETE MSC_ITEM_SO_SR_LEVELS where plan_id = p_plan_id;
849: DELETE MSC_ITEM_FCST_SR_LEVELS where plan_id = p_plan_id;
850: lv_plan_id := ' WHERE plan_id = '||p_plan_id||' ';
851: END IF;
852:

Line 858: ' INSERT /*+ APPEND */ INTO MSC_ITEM_SO_SR_LEVELS'

854:
855: IF (p_plan_so > 0 OR p_plan_id IS NULL) THEN
856:
857: lv_sql_stmt :=
858: ' INSERT /*+ APPEND */ INTO MSC_ITEM_SO_SR_LEVELS'
859: ||' (INVENTORY_ITEM_ID ,'
860: ||' ORGANIZATION_ID ,'
861: ||' SR_INSTANCE_ID ,'
862: ||' PLAN_ID ,'

Line 918: ||' FROM MSC_ITEM_SO_SR_LEVELS_V '

914: ||' CUSTOMER_ID ,'
915: ||' CUSTOMER_SITE_ID ,'
916: ||' REGION_ID ,'
917: ||' COMP_DRP_PLANNED '
918: ||' FROM MSC_ITEM_SO_SR_LEVELS_V '
919: ||lv_plan_id;
920: EXECUTE IMMEDIATE lv_sql_stmt ;
921: COMMIT;
922:

Line 923: LOG_MESSAGE('Inserted records into MSC_ITEM_SO_SR_LEVELS');

919: ||lv_plan_id;
920: EXECUTE IMMEDIATE lv_sql_stmt ;
921: COMMIT;
922:
923: LOG_MESSAGE('Inserted records into MSC_ITEM_SO_SR_LEVELS');
924: END IF;
925:
926:
927: IF (p_global_forecast > 0 OR p_plan_id is NULL) THEN