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 918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%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;
918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;

Line 919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%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;
918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
923: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;

Line 920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;

916: l_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
917: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
923: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
924: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;

Line 921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;

917: l_parent_table_alias WMS_DB_OBJECTS.TABLE_ALIAS%type;
918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
923: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
924: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
925: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;

Line 922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;

918: l_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
923: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
924: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
925: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
926: l_left_part_conv_fct varchar2(100);

Line 923: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;

919: l_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
923: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
924: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
925: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
926: l_left_part_conv_fct varchar2(100);
927: l_right_part_conv_fct varchar2(100);

Line 924: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;

920: l_expression WMS_PARAMETERS_B.EXPRESSION%type;
921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
923: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
924: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
925: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
926: l_left_part_conv_fct varchar2(100);
927: l_right_part_conv_fct varchar2(100);
928: l_search_type_code NUMBER;

Line 925: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;

921: l_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
922: l_parent_parameter_type_code WMS_PARAMETERS_B.PARAMETER_TYPE_CODE%type;
923: l_parent_column_name WMS_PARAMETERS_B.COLUMN_NAME%type;
924: l_parent_expression WMS_PARAMETERS_B.EXPRESSION%type;
925: l_parent_data_type_code WMS_PARAMETERS_B.DATA_TYPE_CODE%type;
926: l_left_part_conv_fct varchar2(100);
927: l_right_part_conv_fct varchar2(100);
928: l_search_type_code NUMBER;
929: l_join varchar2(400);

Line 1007: ,WMS_PARAMETERS_B mppp

1003: ,mppp.DATA_TYPE_CODE
1004: ,mpdop.TABLE_ALIAS -- alias n.a. for multi object based parameters
1005: from WMS_DB_OBJECTS mpdop
1006: ,WMS_DB_OBJECTS mpdop1 -- added for CG
1007: ,WMS_PARAMETERS_B mppp
1008: ,WMS_PARAMETERS_B mpp
1009: ,WMS_DB_OBJECT_JOINS mpdoj
1010: where mpdoj.DB_OBJECT_ID = l_db_object_id
1011: and mpdoj.type_code = l_search_type_code

Line 1008: ,WMS_PARAMETERS_B mpp

1004: ,mpdop.TABLE_ALIAS -- alias n.a. for multi object based parameters
1005: from WMS_DB_OBJECTS mpdop
1006: ,WMS_DB_OBJECTS mpdop1 -- added for CG
1007: ,WMS_PARAMETERS_B mppp
1008: ,WMS_PARAMETERS_B mpp
1009: ,WMS_DB_OBJECT_JOINS mpdoj
1010: where mpdoj.DB_OBJECT_ID = l_db_object_id
1011: and mpdoj.type_code = l_search_type_code
1012: and mpp.PARAMETER_ID = mpdoj.PARAMETER_ID