eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_STRATEGY_PVT dependencies on WMS_OBJECTS_B

Line 950: l_object_id WMS_OBJECTS_B.OBJECT_ID%type;

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;
954: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;

Line 951: l_strat_asgmt_db_object_id WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID%type;

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;
954: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
955: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;

Line 1001: from WMS_OBJECTS_B mpo

997: -- defined by users using form, which doesn't show strat search types
998: cursor hierarchy is
999: select mpo.OBJECT_ID
1000: ,mpo.STRAT_ASGMT_DB_OBJECT_ID
1001: from WMS_OBJECTS_B mpo
1002: ,WMS_ORG_HIERARCHY_OBJS mpoho
1003: where mpoho.ORGANIZATION_ID = l_organization_id
1004: and mpoho.TYPE_CODE = p_type_code
1005: and mpo.OBJECT_ID = mpoho.OBJECT_ID