DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on MTL_PARAMETERS

Line 911: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;

907: l_cursor integer;
908: l_rows integer;
909:
910: -- other variables
911: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%type;
912: l_object_id WMS_OBJECTS_B.OBJECT_ID%type;
913: l_strat_asgmt_db_object_id WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID%type;
914: l_db_object_id WMS_DB_OBJECTS.DB_OBJECT_ID%type;
915: l_table_name WMS_DB_OBJECTS.TABLE_NAME%type;

Line 1999: from mtl_parameters

1995: raise fnd_api.g_exc_error;
1996: end if;
1997:
1998: select NVL(WMS_ENABLED_FLAG, 'N') INTO l_wms_enabled_flag
1999: from mtl_parameters
2000: where ORGANIZATION_ID = l_organization_id;
2001:
2002: -- Build Qty Tree, if type_code = 2
2003: l_tree_id := null;