APPS.WMS_CONTAINER_PVT dependencies on WSH_CONTAINER_ITEMS

Line 6689: FROM WSH_CONTAINER_ITEMS

6685: l_temp_value NUMBER;
6686: l_temp_load_quantity NUMBER;
6687: CURSOR max_load_cursor IS
6688: SELECT max_load_quantity
6689: FROM WSH_CONTAINER_ITEMS
6690: WHERE master_organization_id = p_organization_id
6691: AND container_item_id = p_dest_cont_item_id
6692: AND load_item_id = p_source_item_id;
6693:

Line 6696: FROM WSH_CONTAINER_ITEMS

6692: AND load_item_id = p_source_item_id;
6693:
6694: CURSOR container_items_cursor IS
6695: SELECT container_item_id, max_load_quantity, preferred_flag
6696: FROM WSH_CONTAINER_ITEMS
6697: WHERE master_organization_id = p_organization_id
6698: AND load_item_id = p_source_item_id
6699: AND container_item_id IN
6700: (SELECT inventory_item_id

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

6890: END IF;
6891:
6892: ELSE /* No container item was given */
6893: l_curr_min_container := 0;
6894: -- Search through all the containers in WSH_CONTAINER_ITEMS table which can store
6895: -- the given load_item_id
6896: FOR v_container_item IN container_items_cursor LOOP
6897: /* Get the item information for the current container item being considered */
6898: l_cont_item.inventory_item_id := v_container_item.container_item_id;

Line 7208: FROM wsh_container_items

7204: error_msg VARCHAR2(2000);
7205:
7206: CURSOR container_load IS
7207: SELECT max_load_quantity
7208: FROM wsh_container_items
7209: WHERE load_item_id = p_inventory_item_id
7210: AND container_item_id = p_container_item_id
7211: AND master_organization_id = p_organization_id
7212: AND ROWNUM < 2;