APPS.MSC_SCN_UTILS dependencies on MSC_PLANNING_PROC_ACTIVITIES

Line 2562: 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';

2558: 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, ';
2559: 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'') ';
2560: from_query := from_query || ' SOURCE_TABLE, MPPA.Owner Owner,';
2561: 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 ';
2562: 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';
2563: l_where_clause := ' where ';
2564: --dbms_output.put_line(' 1');
2565: --dbms_output.put_line(' printing from within proc: ' || where_clause);
2566: --dbms_output.put_line(' 2');

Line 2749: from msc_planning_proc_activities

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