APPS.WSH_INTERFACE dependencies on WSH_CONTAINER_ITEMS

Line 1965: from wsh_container_items

1961: l_container_item_id := l_detail_rec.detail_container_item_id ;
1962:
1963: select max_load_quantity
1964: into l_max_load_quantity
1965: from wsh_container_items
1966: where container_item_id = l_detail_rec.detail_container_item_id
1967: and nvl ( load_item_id , l_detail_rec.inventory_item_id ) = l_detail_rec.inventory_item_id
1968: and master_organization_id = l_detail_rec.organization_id
1969: and rownum = 1 ;

Line 1975: from wsh_container_items

1971: else
1972:
1973: select max_load_quantity , container_item_id
1974: into l_max_load_quantity , l_container_item_id
1975: from wsh_container_items
1976: where load_item_id = l_detail_rec.inventory_item_id
1977: and preferred_flag ='Y'
1978: and master_organization_id = l_detail_rec.organization_id
1979: and rownum = 1 ;