APPS.MSC_SNAPSHOT_PK dependencies on MSC_ITEM_FCST_SR_LEVELS

Line 834: DBMS_MVIEW.REFRESH ('MSC_ITEM_FCST_SR_LEVELS_MV','c');*/

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);
838:

Line 842: lv_sql_stmt:= 'TRUNCATE TABLE '||lv_msc_schema||'.MSC_ITEM_FCST_SR_LEVELS';

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;
844:
845: lv_plan_id := ' ';
846:

Line 849: DELETE MSC_ITEM_FCST_SR_LEVELS where plan_id = p_plan_id;

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:
853: COMMIT;

Line 929: ' INSERT /*+ APPEND */ INTO MSC_ITEM_FCST_SR_LEVELS '

925:
926:
927: IF (p_global_forecast > 0 OR p_plan_id is NULL) THEN
928: lv_sql_stmt :=
929: ' INSERT /*+ APPEND */ INTO MSC_ITEM_FCST_SR_LEVELS '
930: ||' (INVENTORY_ITEM_ID ,'
931: ||' SR_INVENTORY_ITEM_ID ,'
932: ||' ORGANIZATION_ID ,'
933: ||' SR_INSTANCE_ID ,'

Line 1003: ||' FROM MSC_ITEM_FCST_SR_LEVELS_V '

999: ||' CUSTOMER_SITE_ID ,'
1000: ||' ZONE_ID ,'
1001: ||' ASSY_DRP_PLANNED ,'
1002: ||' COMP_DRP_PLANNED '
1003: ||' FROM MSC_ITEM_FCST_SR_LEVELS_V '
1004: ||lv_plan_id;
1005:
1006: EXECUTE IMMEDIATE lv_sql_stmt ;
1007: COMMIT;

Line 1009: LOG_MESSAGE( 'Inserted records into MSC_ITEM_FCST_SR_LEVELS');

1005:
1006: EXECUTE IMMEDIATE lv_sql_stmt ;
1007: COMMIT;
1008:
1009: LOG_MESSAGE( 'Inserted records into MSC_ITEM_FCST_SR_LEVELS');
1010: END IF;
1011: p_err_code := G_SUCCESS;
1012: p_err_mesg := 'SUCCESS';
1013: EXCEPTION