APPS.WMS_CONTAINER2_PUB dependencies on WSH_CONTAINER_ITEMS

Line 658: FROM WSH_CONTAINER_ITEMS

654: l_temp_value NUMBER;
655: l_temp_load_quantity NUMBER;
656: CURSOR max_load_cursor IS
657: SELECT max_load_quantity
658: FROM WSH_CONTAINER_ITEMS
659: WHERE master_organization_id = p_organization_id
660: AND container_item_id = p_dest_cont_item_id
661: AND load_item_id = p_source_item_id;
662:

Line 665: FROM WSH_CONTAINER_ITEMS

661: AND load_item_id = p_source_item_id;
662:
663: CURSOR container_items_cursor IS
664: SELECT container_item_id, max_load_quantity, preferred_flag
665: FROM WSH_CONTAINER_ITEMS
666: WHERE master_organization_id = p_organization_id
667: AND load_item_id = p_source_item_id
668: AND container_item_id IN
669: (SELECT inventory_item_id

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

880: END IF;
881:
882: ELSE /* No container item was given */
883: l_curr_min_container := 0;
884: -- Search through all the containers in WSH_CONTAINER_ITEMS table which can store
885: -- the given load_item_id
886: FOR v_container_item IN container_items_cursor LOOP
887: /* Get the item information for the current container item being considered */
888: l_cont_item.inventory_item_id := v_container_item.container_item_id;