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_DB_OBJECTS

Line 952: l_db_object_id WMS_DB_OBJECTS.DB_OBJECT_ID%type;

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;
956: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;

Line 953: l_table_name WMS_DB_OBJECTS.TABLE_NAME%type;

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;
956: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
957: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;

Line 954: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%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;
956: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
957: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
958: l_expression WMS_PARAMETERS_B.EXPRESSION%type;

Line 955: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%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;
956: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
957: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
958: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
959: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;

Line 978: l_table_alias_left WMS_DB_OBJECTS.TABLE_ALIAS%type;

974: ---
975: --
976: --Bug # 2465807 / Grao - To handle SO for Cost Group Search Order (Item Type)
977:
978: l_table_alias_left WMS_DB_OBJECTS.TABLE_ALIAS%type;
979:
980: -- cursor for getting actual inventory org to search for strategy
981: cursor input is
982: select decode(p_type_code, 1, mpsmttv.TO_ORGANIZATION_ID,

Line 1015: from WMS_DB_OBJECTS mpdo

1011: cursor objects is
1012: select mpdo.DB_OBJECT_ID
1013: ,mpdo.TABLE_NAME
1014: ,mpdo.TABLE_ALIAS
1015: from WMS_DB_OBJECTS mpdo
1016: where mpdo.db_object_id IN
1017: (SELECT mpdo.db_object_id
1018: FROM wms_db_objects mpdo
1019: WHERE mpdo.db_object_id = l_strat_asgmt_db_object_id

Line 1018: FROM wms_db_objects mpdo

1014: ,mpdo.TABLE_ALIAS
1015: from WMS_DB_OBJECTS mpdo
1016: where mpdo.db_object_id IN
1017: (SELECT mpdo.db_object_id
1018: FROM wms_db_objects mpdo
1019: WHERE mpdo.db_object_id = l_strat_asgmt_db_object_id
1020: UNION
1021: SELECT mpdop.parent_db_object_id
1022: FROM wms_db_objects_parents mpdop

Line 1022: FROM wms_db_objects_parents mpdop

1018: FROM wms_db_objects mpdo
1019: WHERE mpdo.db_object_id = l_strat_asgmt_db_object_id
1020: UNION
1021: SELECT mpdop.parent_db_object_id
1022: FROM wms_db_objects_parents mpdop
1023: WHERE mpdop.type_code = l_search_type_code
1024: Connect by mpdop.DB_OBJECT_ID = prior mpdop.PARENT_DB_OBJECT_ID
1025: Start with mpdop.DB_OBJECT_ID = l_strat_asgmt_db_object_id AND
1026: mpdop.type_code = l_search_type_code );

Line 1043: from WMS_DB_OBJECTS mpdop

1039: ,mppp.COLUMN_NAME
1040: ,mppp.EXPRESSION
1041: ,mppp.DATA_TYPE_CODE
1042: ,mpdop.TABLE_ALIAS -- alias n.a. for multi object based parameters
1043: from WMS_DB_OBJECTS mpdop
1044: ,WMS_DB_OBJECTS mpdop1 -- added for CG
1045: ,WMS_PARAMETERS_B mppp
1046: ,WMS_PARAMETERS_B mpp
1047: ,WMS_DB_OBJECT_JOINS mpdoj

Line 1044: ,WMS_DB_OBJECTS mpdop1 -- added for CG

1040: ,mppp.EXPRESSION
1041: ,mppp.DATA_TYPE_CODE
1042: ,mpdop.TABLE_ALIAS -- alias n.a. for multi object based parameters
1043: from WMS_DB_OBJECTS mpdop
1044: ,WMS_DB_OBJECTS mpdop1 -- added for CG
1045: ,WMS_PARAMETERS_B mppp
1046: ,WMS_PARAMETERS_B mpp
1047: ,WMS_DB_OBJECT_JOINS mpdoj
1048: where mpdoj.DB_OBJECT_ID = l_db_object_id