DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_SECONDARY_INVENTORIES

Line 3018: FROM mtl_secondary_inventories msi

3014:
3015: IF l_sub IS NOT NULL THEN
3016: SELECT NVL(subinventory_type, 1), Nvl(lpn_controlled_flag, 2)
3017: INTO l_sub_type, l_lpn_cont_flag
3018: FROM mtl_secondary_inventories msi
3019: WHERE secondary_inventory_name = l_sub
3020: AND organization_id = l_org_id;
3021:
3022: IF (l_sub_type = 2