APPS.WSH_INTERFACE dependencies on WSH_CONTAINER_ITEMS

Line 1975: from wsh_container_items

1971: l_container_item_id := l_detail_rec.detail_container_item_id ;
1972:
1973: select max_load_quantity
1974: into l_max_load_quantity
1975: from wsh_container_items
1976: where container_item_id = l_detail_rec.detail_container_item_id
1977: and nvl ( load_item_id , l_detail_rec.inventory_item_id ) = l_detail_rec.inventory_item_id
1978: and master_organization_id = l_detail_rec.organization_id
1979: and rownum = 1 ;

Line 1985: from wsh_container_items

1981: else
1982:
1983: select max_load_quantity , container_item_id
1984: into l_max_load_quantity , l_container_item_id
1985: from wsh_container_items
1986: where load_item_id = l_detail_rec.inventory_item_id
1987: and preferred_flag ='Y'
1988: and master_organization_id = l_detail_rec.organization_id
1989: and rownum = 1 ;