APPS.WMS_CONTAINER_PVT dependencies on WSH_CONTAINER_ITEMS

Line 6129: FROM WSH_CONTAINER_ITEMS

6125: l_temp_value NUMBER;
6126: l_temp_load_quantity NUMBER;
6127: CURSOR max_load_cursor IS
6128: SELECT max_load_quantity
6129: FROM WSH_CONTAINER_ITEMS
6130: WHERE master_organization_id = p_organization_id
6131: AND container_item_id = p_dest_cont_item_id
6132: AND load_item_id = p_source_item_id;
6133:

Line 6136: FROM WSH_CONTAINER_ITEMS

6132: AND load_item_id = p_source_item_id;
6133:
6134: CURSOR container_items_cursor IS
6135: SELECT container_item_id, max_load_quantity, preferred_flag
6136: FROM WSH_CONTAINER_ITEMS
6137: WHERE master_organization_id = p_organization_id
6138: AND load_item_id = p_source_item_id
6139: AND container_item_id IN
6140: (SELECT inventory_item_id

Line 6334: -- Search through all the containers in WSH_CONTAINER_ITEMS table which can store

6330: END IF;
6331:
6332: ELSE /* No container item was given */
6333: l_curr_min_container := 0;
6334: -- Search through all the containers in WSH_CONTAINER_ITEMS table which can store
6335: -- the given load_item_id
6336: FOR v_container_item IN container_items_cursor LOOP
6337: /* Get the item information for the current container item being considered */
6338: l_cont_item.inventory_item_id := v_container_item.container_item_id;

Line 6648: FROM wsh_container_items

6644: error_msg VARCHAR2(2000);
6645:
6646: CURSOR container_load IS
6647: SELECT max_load_quantity
6648: FROM wsh_container_items
6649: WHERE load_item_id = p_inventory_item_id
6650: AND container_item_id = p_container_item_id
6651: AND master_organization_id = p_organization_id
6652: AND ROWNUM < 2;