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_PACKING_WORKBENCH_PVT dependencies on WMS_CONSOLIDATION_PUB

Line 2014: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))

2010:
2011: -- Use this cursor when p_delivery_is is not null
2012: CURSOR l_delivery_cur_del IS
2013: SELECT wnd.delivery_id, wnd.name,
2014: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
2015: FROM wsh_new_deliveries_ob_grp_v wnd
2016: WHERE wnd.organization_id = p_organization_id
2017: AND wnd.delivery_id = p_delivery_id
2018: AND ((p_trip_id IS NULL) OR

Line 2025: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));

2021: where wdl.pick_up_stop_id = wts.stop_id
2022: and wts.trip_id = p_trip_id)))
2023: AND ((p_delivery_state IS NULL) OR
2024: (p_delivery_state IS NOT NULL AND
2025: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));
2026:
2027: -- Use this cursor when p_delivery_is is null but p_trip_id is not null
2028: CURSOR l_delivery_cur_trip IS
2029: SELECT wnd.delivery_id, wnd.name,

Line 2030: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))

2026:
2027: -- Use this cursor when p_delivery_is is null but p_trip_id is not null
2028: CURSOR l_delivery_cur_trip IS
2029: SELECT wnd.delivery_id, wnd.name,
2030: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
2031: FROM wsh_new_deliveries_ob_grp_v wnd
2032: WHERE wnd.organization_id = p_organization_id
2033: AND wnd.delivery_id IN
2034: (select wdl.delivery_id from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

Line 2039: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));

2035: where wdl.pick_up_stop_id = wts.stop_id
2036: and wts.trip_id = p_trip_id)
2037: AND ((p_delivery_state IS NULL) OR
2038: (p_delivery_state IS NOT NULL AND
2039: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));
2040:
2041: -- Use this cursor when both p_delivery_id and p_trip_id are null
2042: -- Then have to use this expensive cursor
2043: CURSOR l_delivery_cur_exp IS

Line 2045: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))

2041: -- Use this cursor when both p_delivery_id and p_trip_id are null
2042: -- Then have to use this expensive cursor
2043: CURSOR l_delivery_cur_exp IS
2044: SELECT wnd.delivery_id, wnd.name,
2045: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
2046: FROM wsh_new_deliveries_ob_grp_v wnd
2047: WHERE wnd.organization_id = p_organization_id
2048: AND ((p_delivery_state IS NULL) OR
2049: (p_delivery_state IS NOT NULL AND

Line 2050: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));

2046: FROM wsh_new_deliveries_ob_grp_v wnd
2047: WHERE wnd.organization_id = p_organization_id
2048: AND ((p_delivery_state IS NULL) OR
2049: (p_delivery_state IS NOT NULL AND
2050: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));
2051:
2052: CURSOR l_wdd_cur(pl_delivery_id NUMBER) IS
2053: SELECT wdd1.organization_id
2054: ,wdd1.subinventory

Line 2413: l_material_rec.delivery_completed := wms_consolidation_pub.is_delivery_consolidated(l_material_rec.delivery_id, p_organization_id, p_subinventory_code, p_locator_id);

2409: -- Delivery State
2410: IF l_delivery_state IS NOT NULL THEN
2411: l_material_rec.delivery_completed := l_delivery_state;
2412: ELSIF l_material_rec.delivery_id IS NOT NULL THEN
2413: l_material_rec.delivery_completed := wms_consolidation_pub.is_delivery_consolidated(l_material_rec.delivery_id, p_organization_id, p_subinventory_code, p_locator_id);
2414: END IF;
2415:
2416: l_progress := '0415'||'-'||l_rec_count;
2417: -- Trip