APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_INTERORG_SHIP_METHODS

Line 1148: FROM msc_interorg_ship_methods sm,

1144: to_date(NULL),
1145: NVL(sm.weight_capacity,0),
1146: to_number(null),
1147: to_char(NULL)
1148: FROM msc_interorg_ship_methods sm,
1149: msc_form_query list,
1150: msc_trading_partners tp,
1151: msc_calendar_dates cal
1152: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date

Line 1176: FROM msc_interorg_ship_methods sm,

1172: to_date(NULL),
1173: NVL(sm.volume_capacity,0)
1174: , to_number(null),
1175: to_char(NULL)
1176: FROM msc_interorg_ship_methods sm,
1177: msc_form_query list,
1178: msc_trading_partners tp,
1179: msc_calendar_dates cal
1180: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date

Line 1204: FROM msc_interorg_ship_methods sm,

1200: to_date(NULL),
1201: NVL(sup.weight_capacity_used,0)
1202: , to_number(null),
1203: to_char(NULL)
1204: FROM msc_interorg_ship_methods sm,
1205: msc_supplies sup,
1206: msc_form_query list
1207: WHERE sm.plan_id = g_designator
1208: AND sm.plan_id = sup.plan_id

Line 1230: FROM msc_interorg_ship_methods sm,

1226: to_date(NULL),
1227: NVL(sup.volume_capacity_used,0)
1228: , to_number(null),
1229: to_char(NULL)
1230: FROM msc_interorg_ship_methods sm,
1231: msc_supplies sup,
1232: msc_form_query list
1233: WHERE sm.plan_id = g_designator
1234: AND sm.plan_id = sup.plan_id

Line 2539: ' FROM msc_interorg_ship_methods '||

2535: ',-1 ' ||
2536: ',msc_get_name.org_code(to_organization_id,sr_instance_id), '||
2537: 'ship_method, '||
2538: ''' ''' || -- insert an empty space, otherwise will error out in java
2539: ' FROM msc_interorg_ship_methods '||
2540: 'WHERE transaction_id in ('||p_res_list||') ' ||
2541: 'AND (sr_instance_id,to_organization_id) in ('||p_org_list||') ';
2542:
2543: ELSE