APPS.MSC_SCN_UTILS dependencies on MSC_PLANNING_PROC_ACTIVITIES

Line 2565: from_query := from_query || ' from msc_planning_proc_activities MPPA, msc_planning_process mpp where MPPA.status in (1,2,4) and mppa.run_sequence=mpp.curr_run_sequence and mppa.process_id=mpp.process_id ) )) from_query';

2561: from_query := from_query || ' Created_By_User, MPPA.Creation_date Creation_Date, mppa.rowid ROW_ID, MPPA.Activity_Id Activity_Id, to_number(NULL) Scenario_Id, to_number(NULL) Scenario_Set_Id, ';
2562: from_query := from_query || ' decode (to_char(decode(MPPA.activity_type,14,''Manual'',15,''Manual'',16,''Manual'',17,''Manual'',18,''Manual'',20,''Manual'',22,''Manual'',23,''Manual'',''System'' ) ),''Manual'',''MSA'',''MPPA'') ';
2563: from_query := from_query || ' SOURCE_TABLE, MPPA.Owner Owner,';
2564: from_query := from_query || ' MPPA.Status Status, MPPA.created_by, MPPA.last_update_date, MPPA.Last_updated_by, MPPA.last_update_login, to_number(NULL) Priority, MPPA.Alternate_Owner Alternate_Owner, to_number(NULL) Scenario_Owner ';
2565: from_query := from_query || ' from msc_planning_proc_activities MPPA, msc_planning_process mpp where MPPA.status in (1,2,4) and mppa.run_sequence=mpp.curr_run_sequence and mppa.process_id=mpp.process_id ) )) from_query';
2566: l_where_clause := ' where ';
2567: --dbms_output.put_line(' 1');
2568: --dbms_output.put_line(' printing from within proc: ' || where_clause);
2569: --dbms_output.put_line(' 2');

Line 2752: from msc_planning_proc_activities

2748: sign(sum(decode(status,3,1,0))-1) s3,
2749: sign(sum(decode(status,4,1,0))-1) s4,
2750: sign(sum(decode(status,5,1,0))-1) s5,
2751: sign(sum(decode(status,6,1,0))-1) s6
2752: from msc_planning_proc_activities
2753: where
2754: process_id = p_process_id
2755: and run_sequence = p_curr_run_seq
2756: and skip=2) a;