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 5908: CURSOR l_wsh_delivery_details_curs IS

5904: , line_id
5905: FROM oe_order_lines_all
5906: WHERE line_id = p_reference_id;
5907:
5908: CURSOR l_wsh_delivery_details_curs IS
5909: SELECT source_header_id
5910: , source_line_id
5911: FROM wsh_delivery_details
5912: WHERE move_order_line_id = p_line_id;

Line 5911: FROM wsh_delivery_details

5907:
5908: CURSOR l_wsh_delivery_details_curs IS
5909: SELECT source_header_id
5910: , source_line_id
5911: FROM wsh_delivery_details
5912: WHERE move_order_line_id = p_line_id;
5913: --Begin bug 4505225
5914: CURSOR l_oe_rcv_curs IS
5915: SELECT oe_order_header_id

Line 5972: OPEN l_wsh_delivery_details_curs;

5968: If (p_line_id <> nvl(g_gsohl_mo_line_id, -1)) OR
5969: (g_gsohl_header_id IS NULL) OR
5970: (g_gsohl_line_id IS NULL) THEN
5971: -- Retrieve Sale information from shipping delivery detail
5972: OPEN l_wsh_delivery_details_curs;
5973: FETCH l_wsh_delivery_details_curs INTO g_gsohl_header_id,g_gsohl_line_id;
5974: CLOSE l_wsh_delivery_details_curs;
5975: g_gsohl_reference_id := NULL;
5976: g_gsohl_mo_line_id := p_line_id;

Line 5973: FETCH l_wsh_delivery_details_curs INTO g_gsohl_header_id,g_gsohl_line_id;

5969: (g_gsohl_header_id IS NULL) OR
5970: (g_gsohl_line_id IS NULL) THEN
5971: -- Retrieve Sale information from shipping delivery detail
5972: OPEN l_wsh_delivery_details_curs;
5973: FETCH l_wsh_delivery_details_curs INTO g_gsohl_header_id,g_gsohl_line_id;
5974: CLOSE l_wsh_delivery_details_curs;
5975: g_gsohl_reference_id := NULL;
5976: g_gsohl_mo_line_id := p_line_id;
5977: END IF;

Line 5974: CLOSE l_wsh_delivery_details_curs;

5970: (g_gsohl_line_id IS NULL) THEN
5971: -- Retrieve Sale information from shipping delivery detail
5972: OPEN l_wsh_delivery_details_curs;
5973: FETCH l_wsh_delivery_details_curs INTO g_gsohl_header_id,g_gsohl_line_id;
5974: CLOSE l_wsh_delivery_details_curs;
5975: g_gsohl_reference_id := NULL;
5976: g_gsohl_mo_line_id := p_line_id;
5977: END IF;
5978: END IF;

Line 6021: wsh_delivery_details wdd,

6017: SELECT wda.delivery_id
6018: INTO l_delivery_id
6019: FROM
6020: wsh_delivery_assignments_v wda,
6021: wsh_delivery_details wdd,
6022: mtl_material_transactions_temp mmtt
6023: WHERE
6024: mmtt.cartonization_id = p_lpn_id
6025: AND mmtt.move_order_line_id = wdd.move_order_line_id -- kkoothan Removed the NVL as part of Bug Fix:2631051

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

6045: SELECT 'Y'
6046: INTO multiple_lpns
6047: FROM DUAL
6048: WHERE EXISTS( SELECT mmtt.transaction_temp_id
6049: FROM mtl_material_transactions_temp mmtt, wsh_delivery_details wdd, wsh_delivery_assignments_v wda
6050: WHERE NVL(mmtt.cartonization_id, -1) <> p_lpn_id
6051: AND mmtt.move_order_line_id = wdd.move_order_line_id
6052: AND wdd.delivery_detail_id = wda.delivery_detail_id
6053: AND wda.delivery_id = l_delivery_id);