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.WMS_PARAMETER_PVT dependencies on WSH_DELIVERY_DETAILS

Line 5894: CURSOR l_wsh_delivery_details_curs IS

5890: , line_id
5891: FROM oe_order_lines_all
5892: WHERE line_id = p_reference_id;
5893:
5894: CURSOR l_wsh_delivery_details_curs IS
5895: SELECT source_header_id
5896: , source_line_id
5897: FROM wsh_delivery_details
5898: WHERE move_order_line_id = p_line_id;

Line 5897: FROM wsh_delivery_details

5893:
5894: CURSOR l_wsh_delivery_details_curs IS
5895: SELECT source_header_id
5896: , source_line_id
5897: FROM wsh_delivery_details
5898: WHERE move_order_line_id = p_line_id;
5899: --Begin bug 4505225
5900: CURSOR l_oe_rcv_curs IS
5901: SELECT oe_order_header_id

Line 5958: OPEN l_wsh_delivery_details_curs;

5954: If (p_line_id <> nvl(g_gsohl_mo_line_id, -1)) OR
5955: (g_gsohl_header_id IS NULL) OR
5956: (g_gsohl_line_id IS NULL) THEN
5957: -- Retrieve Sale information from shipping delivery detail
5958: OPEN l_wsh_delivery_details_curs;
5959: FETCH l_wsh_delivery_details_curs INTO g_gsohl_header_id,g_gsohl_line_id;
5960: CLOSE l_wsh_delivery_details_curs;
5961: g_gsohl_reference_id := NULL;
5962: g_gsohl_mo_line_id := p_line_id;

Line 5959: FETCH l_wsh_delivery_details_curs INTO g_gsohl_header_id,g_gsohl_line_id;

5955: (g_gsohl_header_id IS NULL) OR
5956: (g_gsohl_line_id IS NULL) THEN
5957: -- Retrieve Sale information from shipping delivery detail
5958: OPEN l_wsh_delivery_details_curs;
5959: FETCH l_wsh_delivery_details_curs INTO g_gsohl_header_id,g_gsohl_line_id;
5960: CLOSE l_wsh_delivery_details_curs;
5961: g_gsohl_reference_id := NULL;
5962: g_gsohl_mo_line_id := p_line_id;
5963: END IF;

Line 5960: CLOSE l_wsh_delivery_details_curs;

5956: (g_gsohl_line_id IS NULL) THEN
5957: -- Retrieve Sale information from shipping delivery detail
5958: OPEN l_wsh_delivery_details_curs;
5959: FETCH l_wsh_delivery_details_curs INTO g_gsohl_header_id,g_gsohl_line_id;
5960: CLOSE l_wsh_delivery_details_curs;
5961: g_gsohl_reference_id := NULL;
5962: g_gsohl_mo_line_id := p_line_id;
5963: END IF;
5964: END IF;

Line 6007: wsh_delivery_details wdd,

6003: SELECT wda.delivery_id
6004: INTO l_delivery_id
6005: FROM
6006: wsh_delivery_assignments_v wda,
6007: wsh_delivery_details wdd,
6008: mtl_material_transactions_temp mmtt
6009: WHERE
6010: mmtt.cartonization_id = p_lpn_id
6011: AND mmtt.move_order_line_id = wdd.move_order_line_id -- kkoothan Removed the NVL as part of Bug Fix:2631051

Line 6035: FROM mtl_material_transactions_temp mmtt, wsh_delivery_details wdd, wsh_delivery_assignments_v wda

6031: SELECT 'Y'
6032: INTO multiple_lpns
6033: FROM DUAL
6034: WHERE EXISTS( SELECT mmtt.transaction_temp_id
6035: FROM mtl_material_transactions_temp mmtt, wsh_delivery_details wdd, wsh_delivery_assignments_v wda
6036: WHERE NVL(mmtt.cartonization_id, -1) <> p_lpn_id
6037: AND mmtt.move_order_line_id = wdd.move_order_line_id
6038: AND wdd.delivery_detail_id = wda.delivery_detail_id
6039: AND wda.delivery_id = l_delivery_id);