DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on MTL_ITEM_LOC_DEFAULTS

Line 2375: From MTL_ITEM_LOC_DEFAULTS

2371:
2372: Cursor get_default_loct (p_org_id number) IS
2373: Select locator_id
2374: , subinventory_code
2375: From MTL_ITEM_LOC_DEFAULTS
2376: Where inventory_item_id = p_shipping_line.inventory_item_id
2377: and organization_id = p_org_id;
2378:
2379: Cursor get_default_sub (p_org_id number) IS

Line 2488: --if yes then get default subinv and locator from MTL_ITEM_LOC_DEFAULTS

2484: ( p_inventory_item_id => p_shipping_line.inventory_item_id
2485: ,p_mtl_organization_id => l_po_info.destination_organization_id
2486: ,x_ctl_ind => l_ctl_ind
2487: ) ;
2488: --if yes then get default subinv and locator from MTL_ITEM_LOC_DEFAULTS
2489: IF l_ctl_ind = 'Y' THEN
2490: Open get_default_loct(l_po_info.destination_organization_id) ;
2491: Fetch get_default_loct into l_locator_id, l_subinventory;
2492: IF get_default_loct%NOTFOUND THEN