[Home] [Help]
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))'
834: ||' mic.request_id , '
835: ||' mic.program_application_id, '
836: ||' mic.program_id , '
837: ||' mic.program_update_date '
838: ||' FROM msc_st_item_categories mic,msc_system_items msi'
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 '
947: ||' mic.request_id , '
948: ||' mic.program_application_id, '
949: ||' mic.program_id , '
950: ||' mic.program_update_date '
951: ||' FROM msc_st_item_categories mic,msc_system_items msi'
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 '
1642: request_id ,
1643: program_application_id,
1644: program_id ,
1645: program_update_date
1646: FROM MSC_SYSTEM_ITEMS
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
2548: p_token_value1 => 'SR_INSTANCE_CODE AND'
2549: ||' INV_ORG AND ITEM AND ITEM.ATO_FORECAST_CONTROL'
2550: ||' AND ITEM.MRP_PLANNING_CODE',
2551: p_token2 => 'MASTER_TABLE',
2552: p_token_value2 => 'MSC_SYSTEM_ITEMS',
2553: p_token3 => 'CHILD_TABLE',
2554: p_token_value3 => 'MSD_ST_BOOKING_DATA');
2555:
2556: IF lv_return <> 0 THEN
2572: AND ((v_plan_per_profile = 4) OR (msi.ato_forecast_control <> 3)) --forecast control - none
2573: AND ((msi.mrp_planning_code <> 6 ) OR (msi.pick_components_flag='Y' )) --Not planned item
2574: UNION
2575: SELECT 1
2576: FROM msc_system_items mls
2577: WHERE mls.sr_instance_id = p_instance_id
2578: AND mls.organization_id = mbd.sr_inv_org_pk
2579: AND mls.item_name = mbd.item
2580: AND mls.plan_id = -1
3440: p_token_value1 => 'SR_INSTANCE_CODE AND'
3441: ||' INV_ORG AND ITEM AND ITEM.ATO_FORECAST_CONTROL'
3442: ||' AND ITEM.MRP_PLANNING_CODE',
3443: p_token2 => 'MASTER_TABLE',
3444: p_token_value2 => 'MSC_SYSTEM_ITEMS',
3445: p_token3 => 'CHILD_TABLE',
3446: p_token_value3 => 'MSD_ST_SHIPMENT_DATA');
3447:
3448: IF lv_return <> 0 THEN
3464: AND ((v_plan_per_profile = 4) OR (msi.ato_forecast_control <> 3)) --forecast control - none
3465: AND ((msi.mrp_planning_code <> 6 ) OR (msi.pick_components_flag='Y' )) --Not planned item
3466: UNION
3467: SELECT 1
3468: FROM msc_system_items mls
3469: WHERE mls.sr_instance_id = p_instance_id
3470: AND mls.organization_id = msd.sr_inv_org_pk
3471: AND mls.item_name = msd.item
3472: AND mls.plan_id = -1
4549: p_token_value1 => 'SR_INSTANCE_CODE AND'
4550: ||' INV_ORG AND ITEM AND ITEM.ATO_FORECAST_CONTROL'
4551: ||' AND ITEM.MRP_PLANNING_CODE',
4552: p_token2 => 'MASTER_TABLE',
4553: p_token_value2 => 'MSC_SYSTEM_ITEMS',
4554: p_token3 => 'CHILD_TABLE',
4555: p_token_value3 => 'MSD_ST_MFG_FORECAST');
4556:
4557: IF lv_return <> 0 THEN
4573: AND ((v_plan_per_profile = 4) OR (msi.ato_forecast_control <> 3)) --forecast control - none
4574: AND ((msi.mrp_planning_code <> 6 ) OR (msi.pick_components_flag='Y' )) --Not planned item
4575: UNION
4576: SELECT 1
4577: FROM msc_system_items mls
4578: WHERE mls.sr_instance_id = p_instance_id
4579: AND mls.organization_id = mmf.sr_inv_org_pk
4580: AND mls.item_name = mmf.item
4581: AND mls.plan_id = -1
6664: p_token_value1 => 'SR_INSTANCE_CODE AND'
6665: ||' INV_ORG AND ITEM AND ITEM.ATO_FORECAST_CONTROL'
6666: ||' AND ITEM.MRP_PLANNING_CODE',
6667: p_token2 => 'MASTER_TABLE',
6668: p_token_value2 => 'MSC_SYSTEM_ITEMS',
6669: p_token3 => 'CHILD_TABLE',
6670: p_token_value3 => 'MSD_ST_CS_DATA');
6671:
6672: IF lv_return <> 0 THEN
6688: AND ((v_plan_per_profile = 4) OR (msi.ato_forecast_control <> 3)) --forecast control - none
6689: AND ((msi.mrp_planning_code <> 6 ) OR (msi.pick_components_flag='Y' )) --Not planned item
6690: UNION
6691: SELECT 1
6692: FROM msc_system_items mls
6693: WHERE mls.sr_instance_id = p_instance_id
6694: AND mls.organization_id = mcd.attribute_11
6695: AND mls.item_name = mcd.attribute_4
6696: AND mls.plan_id = -1
7417: p_token_value1 => 'SR_INSTANCE_CODE AND'
7418: ||' INV_ORG AND ITEM AND ITEM.ATO_FORECAST_CONTROL'
7419: ||' AND ITEM.MRP_PLANNING_CODE',
7420: p_token2 => 'MASTER_TABLE',
7421: p_token_value2 => 'MSC_SYSTEM_ITEMS',
7422: p_token3 => 'CHILD_TABLE',
7423: p_token_value3 => 'MSD_ST_PRICE_LIST');
7424:
7425: IF lv_return <> 0 THEN
7441: AND ((v_plan_per_profile = 4) OR (msi.ato_forecast_control <> 3)) --forecast control - none
7442: AND ((msi.mrp_planning_code <> 6 ) OR (msi.pick_components_flag='Y' )) --Not planned item
7443: UNION
7444: SELECT 1
7445: FROM msc_system_items mls
7446: WHERE mls.sr_instance_id = p_instance_id
7447: AND mls.organization_id = mpl.sr_organization_lvl_pk
7448: AND mls.item_name = mpl.sr_product_lvl_val
7449: AND mls.plan_id = -1