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 912: l_object_id WMS_OBJECTS_B.OBJECT_ID%type;

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

Line 913: l_strat_asgmt_db_object_id WMS_OBJECTS_B.STRAT_ASGMT_DB_OBJECT_ID%type;

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

Line 963: from WMS_OBJECTS_B mpo

959: -- defined by users using form, which doesn't show strat search types
960: cursor hierarchy is
961: select mpo.OBJECT_ID
962: ,mpo.STRAT_ASGMT_DB_OBJECT_ID
963: from WMS_OBJECTS_B mpo
964: ,WMS_ORG_HIERARCHY_OBJS mpoho
965: where mpoho.ORGANIZATION_ID = l_organization_id
966: and mpoho.TYPE_CODE = p_type_code
967: and mpo.OBJECT_ID = mpoho.OBJECT_ID