eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_CL_PRE_PROCESS dependencies on MSD_SETUP_PARAMETERS

Line 692: ||' from msc_st_system_items mssi2, msd_setup_parameters par'

688: ||' AND mssi.process_flag = '||G_VALID
689: ||' AND mssi.batch_id = :p_batch_id'
690: ||' AND mssi.sr_instance_id = :p_instance_id'
691: ||' AND NOT EXISTS ( select 1'
692: ||' from msc_st_system_items mssi2, msd_setup_parameters par'
693: ||' where mssi.item_name =mssi2.item_name'
694: ||' and mssi2.organization_code = par.PARAMETER_VALUE'
695: ||' and ((mssi2.mrp_planning_code <> 6) OR (mssi2.pick_components_flag =''Y''))'
696: ||' and (('||v_plan_per_profile||'= 4) OR (mssi2.ato_forecast_control <> 3))'

Line 703: ||' from msc_system_items msi, msd_setup_parameters par'

699: ||' and par.parameter_name = ''MSD_MASTER_ORG_LEGACY'''
700: ||' and par.instance_id = mssi2.sr_instance_id'
701: ||' UNION'
702: ||' select 1'
703: ||' from msc_system_items msi, msd_setup_parameters par'
704: ||' where mssi.item_name = msi.item_name'
705: ||' and msi.organization_code = par.PARAMETER_VALUE'
706: ||' and ((msi.mrp_planning_code <> 6) OR (msi.pick_components_flag =''Y''))'
707: ||' and (('||v_plan_per_profile||'= 4) OR (msi.ato_forecast_control <> 3))'

Line 805: ||' parameter_value from msd_setup_parameters'

801: ||' WHERE mic.sr_instance_id = :p_instance_id'
802: ||' AND mic.process_flag = '||G_VALID
803: ||' AND mic.batch_id = :p_batch_id'
804: ||' AND mic.organization_code = ( SELECT '
805: ||' parameter_value from msd_setup_parameters'
806: ||' WHERE parameter_name = ''MSD_MASTER_ORG_LEGACY'''
807: ||' AND instance_id = mic.sr_instance_id)'
808: ||' AND mic.category_set_name = ( SELECT '
809: ||' parameter_value from msd_setup_parameters'

Line 809: ||' parameter_value from msd_setup_parameters'

805: ||' parameter_value from msd_setup_parameters'
806: ||' WHERE parameter_name = ''MSD_MASTER_ORG_LEGACY'''
807: ||' AND instance_id = mic.sr_instance_id)'
808: ||' AND mic.category_set_name = ( SELECT '
809: ||' parameter_value from msd_setup_parameters'
810: ||' WHERE parameter_name = ''MSD_CATEGORY_SET_NAME_LEGACY'' '
811: ||' AND instance_id = mic.sr_instance_id)'
812: ||' AND (('||v_plan_per_profile||'= 4) OR (mssi.ato_forecast_control <> 3))'
813: ||' AND mssi.mrp_planning_code <> 6'

Line 843: ||' parameter_value from msd_setup_parameters'

839: ||' WHERE mic.sr_instance_id = :p_instance_id'
840: ||' AND mic.process_flag = '||G_VALID
841: ||' AND mic.batch_id = :p_batch_id'
842: ||' AND mic.organization_code = ( SELECT '
843: ||' parameter_value from msd_setup_parameters'
844: ||' WHERE parameter_name = ''MSD_MASTER_ORG_LEGACY'''
845: ||' AND instance_id = mic.sr_instance_id)'
846: ||' AND mic.category_set_name = ( SELECT '
847: ||' parameter_value from msd_setup_parameters'

Line 847: ||' parameter_value from msd_setup_parameters'

843: ||' parameter_value from msd_setup_parameters'
844: ||' WHERE parameter_name = ''MSD_MASTER_ORG_LEGACY'''
845: ||' AND instance_id = mic.sr_instance_id)'
846: ||' AND mic.category_set_name = ( SELECT '
847: ||' parameter_value from msd_setup_parameters'
848: ||' WHERE parameter_name = ''MSD_CATEGORY_SET_NAME_LEGACY'' '
849: ||' AND instance_id = mic.sr_instance_id)'
850: ||' AND (('||v_plan_per_profile||'= 4) OR (msi.ato_forecast_control <> 3))'
851: ||' AND msi.mrp_planning_code <> 6'

Line 918: ||' parameter_value from msd_setup_parameters'

914: ||' WHERE mic.sr_instance_id = :p_instance_id'
915: ||' AND mic.process_flag = '||G_VALID
916: ||' AND mic.batch_id = :p_batch_id'
917: ||' AND mic.organization_code = ( SELECT '
918: ||' parameter_value from msd_setup_parameters'
919: ||' WHERE parameter_name = ''MSD_MASTER_ORG_LEGACY'''
920: ||' AND instance_id = mic.sr_instance_id)'
921: ||' AND mic.category_set_name = ( SELECT '
922: ||' parameter_value from msd_setup_parameters'

Line 922: ||' parameter_value from msd_setup_parameters'

918: ||' parameter_value from msd_setup_parameters'
919: ||' WHERE parameter_name = ''MSD_MASTER_ORG_LEGACY'''
920: ||' AND instance_id = mic.sr_instance_id)'
921: ||' AND mic.category_set_name = ( SELECT '
922: ||' parameter_value from msd_setup_parameters'
923: ||' WHERE parameter_name = ''MSD_CATEGORY_SET_NAME_LEGACY'' '
924: ||' AND instance_id = mic.sr_instance_id)'
925: ||' AND (('||v_plan_per_profile||'= 4) OR (mssi.ato_forecast_control <> 3))'
926: ||' AND mssi.mrp_planning_code <> 6'

Line 956: ||' parameter_value from msd_setup_parameters'

952: ||' WHERE mic.sr_instance_id = :p_instance_id'
953: ||' AND mic.process_flag = '||G_VALID
954: ||' AND mic.batch_id = :p_batch_id'
955: ||' AND mic.organization_code = ( SELECT '
956: ||' parameter_value from msd_setup_parameters'
957: ||' WHERE parameter_name = ''MSD_MASTER_ORG_LEGACY'''
958: ||' AND instance_id = mic.sr_instance_id)'
959: ||' AND mic.category_set_name = ( SELECT '
960: ||' parameter_value from msd_setup_parameters'

Line 960: ||' parameter_value from msd_setup_parameters'

956: ||' parameter_value from msd_setup_parameters'
957: ||' WHERE parameter_name = ''MSD_MASTER_ORG_LEGACY'''
958: ||' AND instance_id = mic.sr_instance_id)'
959: ||' AND mic.category_set_name = ( SELECT '
960: ||' parameter_value from msd_setup_parameters'
961: ||' WHERE parameter_name = ''MSD_CATEGORY_SET_NAME_LEGACY'' '
962: ||' AND instance_id = mic.sr_instance_id)'
963: ||' AND (('||v_plan_per_profile||'= 4) OR (msi.ato_forecast_control <> 3))'
964: ||' AND msi.mrp_planning_code <> 6'

Line 1423: FROM msd_setup_parameters

1419: WHERE instance_id=p_instance_id;
1420: /*
1421: CURSOR master_org(p_instance_id NUMBER) IS
1422: SELECT parameter_value
1423: FROM msd_setup_parameters
1424: WHERE parameter_name = 'MSD_MASTER_ORG'
1425: AND instance_id = p_instance_id;
1426: */
1427: CURSOR c3(p_batch_id NUMBER)IS

Line 1651: from msc_trading_partners mtp,msd_setup_parameters msp

1647: WHERE item_name = lb_level_value(j)
1648: AND sr_instance_id = p_instance_id
1649: AND plan_id = -1
1650: AND organization_id = (select mtp.sr_tp_id
1651: from msc_trading_partners mtp,msd_setup_parameters msp
1652: where msp.parameter_name ='MSD_MASTER_ORG_LEGACY'
1653: and msp.instance_id = p_instance_id
1654: and msp.parameter_value = substr(mtp.organization_code,instr(mtp.organization_code,':')+1,length(mtp.organization_code))
1655: and nvl(mtp.company_id,-1) = -1

Line 7832: -- Update the msd_setup_parameters

7828: RAISE ex_logging_err;
7829: END IF;
7830:
7831:
7832: -- Update the msd_setup_parameters
7833: FOR c_rec IN c2 LOOP
7834:
7835: BEGIN
7836:

Line 7837: UPDATE msd_setup_parameters

7833: FOR c_rec IN c2 LOOP
7834:
7835: BEGIN
7836:
7837: UPDATE msd_setup_parameters
7838: SET parameter_value = c_rec.parameter_value
7839: WHERE parameter_name = c_rec.parameter_name
7840: AND instance_id = c_rec.instance ;
7841:

Line 7844: DELETE FROM msd_setup_parameters

7840: AND instance_id = c_rec.instance ;
7841:
7842: IF SQL%NOTFOUND THEN
7843:
7844: DELETE FROM msd_setup_parameters
7845: WHERE PARAMETER_NAME = c_rec.parameter_name;
7846:
7847: INSERT INTO MSD_SETUP_PARAMETERS
7848: ( INSTANCE_ID,

Line 7847: INSERT INTO MSD_SETUP_PARAMETERS

7843:
7844: DELETE FROM msd_setup_parameters
7845: WHERE PARAMETER_NAME = c_rec.parameter_name;
7846:
7847: INSERT INTO MSD_SETUP_PARAMETERS
7848: ( INSTANCE_ID,
7849: PARAMETER_NAME,
7850: PARAMETER_VALUE )
7851: VALUES