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 1943: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))

1939:
1940: -- Use this cursor when p_delivery_is is not null
1941: CURSOR l_delivery_cur_del IS
1942: SELECT wnd.delivery_id, wnd.name,
1943: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
1944: FROM wsh_new_deliveries_ob_grp_v wnd
1945: WHERE wnd.organization_id = p_organization_id
1946: AND wnd.delivery_id = p_delivery_id
1947: AND ((p_trip_id IS NULL) OR

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

1950: where wdl.pick_up_stop_id = wts.stop_id
1951: and wts.trip_id = p_trip_id)))
1952: AND ((p_delivery_state IS NULL) OR
1953: (p_delivery_state IS NOT NULL AND
1954: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));
1955:
1956: -- Use this cursor when p_delivery_is is null but p_trip_id is not null
1957: CURSOR l_delivery_cur_trip IS
1958: SELECT wnd.delivery_id, wnd.name,

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

1955:
1956: -- Use this cursor when p_delivery_is is null but p_trip_id is not null
1957: CURSOR l_delivery_cur_trip IS
1958: SELECT wnd.delivery_id, wnd.name,
1959: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
1960: FROM wsh_new_deliveries_ob_grp_v wnd
1961: WHERE wnd.organization_id = p_organization_id
1962: AND wnd.delivery_id IN
1963: (select wdl.delivery_id from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts

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

1964: where wdl.pick_up_stop_id = wts.stop_id
1965: and wts.trip_id = p_trip_id)
1966: AND ((p_delivery_state IS NULL) OR
1967: (p_delivery_state IS NOT NULL AND
1968: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));
1969:
1970: -- Use this cursor when both p_delivery_id and p_trip_id are null
1971: -- Then have to use this expensive cursor
1972: CURSOR l_delivery_cur_exp IS

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

1970: -- Use this cursor when both p_delivery_id and p_trip_id are null
1971: -- Then have to use this expensive cursor
1972: CURSOR l_delivery_cur_exp IS
1973: SELECT wnd.delivery_id, wnd.name,
1974: nvl(p_delivery_state, wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id))
1975: FROM wsh_new_deliveries_ob_grp_v wnd
1976: WHERE wnd.organization_id = p_organization_id
1977: AND ((p_delivery_state IS NULL) OR
1978: (p_delivery_state IS NOT NULL AND

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

1975: FROM wsh_new_deliveries_ob_grp_v wnd
1976: WHERE wnd.organization_id = p_organization_id
1977: AND ((p_delivery_state IS NULL) OR
1978: (p_delivery_state IS NOT NULL AND
1979: wms_consolidation_pub.is_delivery_consolidated(wnd.delivery_id, p_organization_id, p_subinventory_code, p_locator_id) = p_delivery_state));
1980:
1981: CURSOR l_wdd_cur(pl_delivery_id NUMBER) IS
1982: SELECT wdd1.organization_id
1983: ,wdd1.subinventory

Line 2340: 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);

2336: -- Delivery State
2337: IF l_delivery_state IS NOT NULL THEN
2338: l_material_rec.delivery_completed := l_delivery_state;
2339: ELSIF l_material_rec.delivery_id IS NOT NULL THEN
2340: 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);
2341: END IF;
2342:
2343: l_progress := '0415'||'-'||l_rec_count;
2344: -- Trip