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_PARAMETERS_B

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

Line 957: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%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;
960: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
961: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;

Line 958: l_expression WMS_PARAMETERS_B.EXPRESSION%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;
960: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
961: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
962: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;

Line 959: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%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;
960: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
961: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
962: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
963: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;

Line 960: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%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;
960: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
961: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
962: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
963: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
964: l_left_part_conv_fct varchar2(100);

Line 961: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%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;
960: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
961: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
962: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
963: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
964: l_left_part_conv_fct varchar2(100);
965: l_right_part_conv_fct varchar2(100);

Line 962: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;

958: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
959: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
960: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
961: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
962: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
963: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
964: l_left_part_conv_fct varchar2(100);
965: l_right_part_conv_fct varchar2(100);
966: l_search_type_code NUMBER;

Line 963: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;

959: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
960: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
961: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
962: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
963: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
964: l_left_part_conv_fct varchar2(100);
965: l_right_part_conv_fct varchar2(100);
966: l_search_type_code NUMBER;
967: l_join varchar2(400);

Line 1045: ,WMS_PARAMETERS_B mppp

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
1049: and mpdoj.type_code = l_search_type_code

Line 1046: ,WMS_PARAMETERS_B mpp

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
1049: and mpdoj.type_code = l_search_type_code
1050: and mpp.PARAMETER_ID = mpdoj.PARAMETER_ID