DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on MTL_ITEM_SUB_DEFAULTS

Line 2381: From MTL_ITEM_SUB_DEFAULTS

2377: and organization_id = p_org_id;
2378:
2379: Cursor get_default_sub (p_org_id number) IS
2380: Select subinventory_code
2381: From MTL_ITEM_SUB_DEFAULTS
2382: Where inventory_item_id = p_shipping_line.inventory_item_id
2383: and organization_id = p_org_id;
2384:
2385: l_intransit_type NUMBER;

Line 2505: --esle if item not location cotrolled then get def subinv from MTL_ITEM_SUB_DEFAULTS

2501: /* Bug #3415847 punkumar,commeting out the exception so that it does not stop insertion of record in RTI
2502: RAISE FND_API.G_EXC_ERROR;
2503: */
2504: END IF;
2505: --esle if item not location cotrolled then get def subinv from MTL_ITEM_SUB_DEFAULTS
2506: ELSIF l_ctl_ind = 'N' THEN
2507: Open get_default_sub(l_po_info.destination_organization_id) ;
2508: Fetch get_default_sub into l_subinventory;
2509: IF get_default_sub%NOTFOUND THEN