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.WSH_BATCH_PROCESS dependencies on WSH_SHIPPING_PARAMETERS

Line 2958: -- p_autocreate_deliveries = 'SP', need to join with wsh_shipping_parameters

2954: -- clear up x_selected_det_tbl table
2955: x_selected_det_tbl.delete;
2956:
2957: IF p_autocreate_deliveries is NULL OR p_autocreate_deliveries='SP' THEN
2958: -- p_autocreate_deliveries = 'SP', need to join with wsh_shipping_parameters
2959: l_sc_SELECT := l_sc_SELECT || ' wdd.delivery_detail_id ';
2960: l_sc_FROM := l_sc_FROM || ' wsh_delivery_details wdd , wsh_delivery_assignments_v wda ';
2961: l_sc_FROM := l_sc_FROM || ' , wsh_shipping_parameters wsp ';
2962: l_sc_WHERE := l_sc_WHERE || ' wda.delivery_detail_id = wdd.delivery_detail_id ';

Line 2961: l_sc_FROM := l_sc_FROM || ' , wsh_shipping_parameters wsp ';

2957: IF p_autocreate_deliveries is NULL OR p_autocreate_deliveries='SP' THEN
2958: -- p_autocreate_deliveries = 'SP', need to join with wsh_shipping_parameters
2959: l_sc_SELECT := l_sc_SELECT || ' wdd.delivery_detail_id ';
2960: l_sc_FROM := l_sc_FROM || ' wsh_delivery_details wdd , wsh_delivery_assignments_v wda ';
2961: l_sc_FROM := l_sc_FROM || ' , wsh_shipping_parameters wsp ';
2962: l_sc_WHERE := l_sc_WHERE || ' wda.delivery_detail_id = wdd.delivery_detail_id ';
2963: l_sc_WHERE := l_sc_WHERE || ' and wdd.organization_id = wsp.organization_id ';
2964: l_sc_WHERE := l_sc_WHERE || ' and wsp.autocreate_deliveries_flag = ''Y'' ';
2965:

Line 2967: -- p_autocreate_deliveries = 'Y' do not join with wsh_shipping_parameters

2963: l_sc_WHERE := l_sc_WHERE || ' and wdd.organization_id = wsp.organization_id ';
2964: l_sc_WHERE := l_sc_WHERE || ' and wsp.autocreate_deliveries_flag = ''Y'' ';
2965:
2966: ELSIF p_autocreate_deliveries = 'Y' THEN
2967: -- p_autocreate_deliveries = 'Y' do not join with wsh_shipping_parameters
2968: l_sc_SELECT := l_sc_SELECT || ' wdd.delivery_detail_id ';
2969: l_sc_FROM := l_sc_FROM || ' wsh_delivery_details wdd , wsh_delivery_assignments_v wda ';
2970: l_sc_WHERE := l_sc_WHERE || ' wda.delivery_detail_id = wdd.delivery_detail_id ';
2971:

Line 3648: FROM wsh_shipping_parameters

3644: --RTV changes --TCA View Changes end
3645:
3646: CURSOR get_appending_limit (c_organization_id NUMBER) IS
3647: SELECT appending_limit,autocreate_del_orders_flag --Bug 10353854
3648: FROM wsh_shipping_parameters
3649: WHERE organization_id = c_organization_id;
3650:
3651: l_completion_status VARCHAR2(30);
3652: l_error_code NUMBER;