DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on MTL_PARAMETERS

Line 949: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;

945: l_cursor integer;
946: l_rows integer;
947:
948: -- other variables
949: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;
950: l_object_id WMS_OBJECTS_B.OBJECT_ID%type;
951: l_strat_asgmt_db_object_id WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID%type;
952: l_db_object_id WMS_DB_OBJECTS.DB_OBJECT_ID%type;
953: l_table_name WMS_DB_OBJECTS.TABLE_NAME%type;

Line 2155: from mtl_parameters

2151: raise fnd_api.g_exc_error;
2152: end if;
2153:
2154: select NVL(WMS_ENABLED_FLAG, 'N') INTO l_wms_enabled_flag
2155: from mtl_parameters
2156: where ORGANIZATION_ID = l_organization_id;
2157:
2158: -- Build Qty Tree, if type_code = 2
2159: l_tree_id := null;