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_RULE_PVT dependencies on WMS_RESTRICTIONS

Line 1074: wms_restrictions r,

1070: FROM wms_selection_criteria_txn wsc,
1071: wms_strategies_b wsb,
1072: wms_strategy_members wsm,
1073: wms_rules_b wrb,
1074: wms_restrictions r,
1075: wms_sort_criteria s,
1076: wms_rule_consistencies c,
1077: wms_parameters_b p
1078: WHERE wsc.rule_type_code = 2

Line 1834: l_operand_type_code wms_restrictions.operand_type_code%TYPE;

1830: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1831: l_parent_column_name wms_parameters_b.column_name%TYPE;
1832: l_parent_expression wms_parameters_b.expression%TYPE;
1833: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;
1834: l_operand_type_code wms_restrictions.operand_type_code%TYPE;
1835: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;
1836: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;
1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;
1838: l_operand_expression wms_restrictions.operand_expression%TYPE;

Line 1835: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;

1831: l_parent_column_name wms_parameters_b.column_name%TYPE;
1832: l_parent_expression wms_parameters_b.expression%TYPE;
1833: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;
1834: l_operand_type_code wms_restrictions.operand_type_code%TYPE;
1835: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;
1836: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;
1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;
1838: l_operand_expression wms_restrictions.operand_expression%TYPE;
1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;

Line 1836: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;

1832: l_parent_expression wms_parameters_b.expression%TYPE;
1833: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;
1834: l_operand_type_code wms_restrictions.operand_type_code%TYPE;
1835: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;
1836: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;
1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;
1838: l_operand_expression wms_restrictions.operand_expression%TYPE;
1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;
1840: l_bracket_open wms_restrictions.bracket_open%TYPE;

Line 1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;

1833: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;
1834: l_operand_type_code wms_restrictions.operand_type_code%TYPE;
1835: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;
1836: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;
1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;
1838: l_operand_expression wms_restrictions.operand_expression%TYPE;
1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;
1840: l_bracket_open wms_restrictions.bracket_open%TYPE;
1841: l_bracket_close wms_restrictions.bracket_close%TYPE;

Line 1838: l_operand_expression wms_restrictions.operand_expression%TYPE;

1834: l_operand_type_code wms_restrictions.operand_type_code%TYPE;
1835: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;
1836: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;
1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;
1838: l_operand_expression wms_restrictions.operand_expression%TYPE;
1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;
1840: l_bracket_open wms_restrictions.bracket_open%TYPE;
1841: l_bracket_close wms_restrictions.bracket_close%TYPE;
1842: l_validation_type fnd_flex_value_sets.validation_type%TYPE;

Line 1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;

1835: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;
1836: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;
1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;
1838: l_operand_expression wms_restrictions.operand_expression%TYPE;
1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;
1840: l_bracket_open wms_restrictions.bracket_open%TYPE;
1841: l_bracket_close wms_restrictions.bracket_close%TYPE;
1842: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1843: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;

Line 1840: l_bracket_open wms_restrictions.bracket_open%TYPE;

1836: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;
1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;
1838: l_operand_expression wms_restrictions.operand_expression%TYPE;
1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;
1840: l_bracket_open wms_restrictions.bracket_open%TYPE;
1841: l_bracket_close wms_restrictions.bracket_close%TYPE;
1842: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1843: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1844: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

Line 1841: l_bracket_close wms_restrictions.bracket_close%TYPE;

1837: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;
1838: l_operand_expression wms_restrictions.operand_expression%TYPE;
1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;
1840: l_bracket_open wms_restrictions.bracket_open%TYPE;
1841: l_bracket_close wms_restrictions.bracket_close%TYPE;
1842: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1843: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1844: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1845: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;

Line 1889: FROM wms_restrictions wr

1885: FROM wms_sort_criteria wsc
1886: WHERE wsc.rule_id = p_rule_id
1887: UNION
1888: SELECT wr.parameter_id
1889: FROM wms_restrictions wr
1890: WHERE wr.rule_id = p_rule_id
1891: UNION
1892: SELECT wr.operand_parameter_id
1893: FROM wms_restrictions wr

Line 1893: FROM wms_restrictions wr

1889: FROM wms_restrictions wr
1890: WHERE wr.rule_id = p_rule_id
1891: UNION
1892: SELECT wr.operand_parameter_id
1893: FROM wms_restrictions wr
1894: WHERE wr.rule_id = p_rule_id
1895: AND wr.operand_type_code = 4
1896: UNION
1897: SELECT wrc.parameter_id

Line 1923: FROM wms_restrictions wrd

1919: FROM wms_sort_criteria wscd
1920: WHERE wscd.rule_id = p_rule_id
1921: UNION
1922: SELECT wrd.parameter_id
1923: FROM wms_restrictions wrd
1924: WHERE wrd.rule_id = p_rule_id
1925: UNION
1926: SELECT wrd.operand_parameter_id
1927: FROM wms_restrictions wrd

Line 1927: FROM wms_restrictions wrd

1923: FROM wms_restrictions wrd
1924: WHERE wrd.rule_id = p_rule_id
1925: UNION
1926: SELECT wrd.operand_parameter_id
1927: FROM wms_restrictions wrd
1928: WHERE wrd.rule_id = p_rule_id
1929: AND wrd.operand_type_code = 4
1930: UNION
1931: SELECT wrcd.parameter_id

Line 1954: FROM wms_restrictions wr

1950: FROM wms_sort_criteria wsc
1951: WHERE wsc.rule_id = p_rule_id
1952: UNION
1953: SELECT wr.parameter_id
1954: FROM wms_restrictions wr
1955: WHERE wr.rule_id = p_rule_id
1956: UNION
1957: SELECT wr.operand_parameter_id
1958: FROM wms_restrictions wr

Line 1958: FROM wms_restrictions wr

1954: FROM wms_restrictions wr
1955: WHERE wr.rule_id = p_rule_id
1956: UNION
1957: SELECT wr.operand_parameter_id
1958: FROM wms_restrictions wr
1959: WHERE wr.rule_id = p_rule_id
1960: AND wr.operand_type_code = 4
1961: UNION
1962: SELECT wrc.parameter_id

Line 1992: FROM wms_restrictions wr

1988: FROM wms_sort_criteria wsc
1989: WHERE wsc.rule_id = p_rule_id
1990: UNION
1991: SELECT wr.parameter_id
1992: FROM wms_restrictions wr
1993: WHERE wr.rule_id = p_rule_id
1994: UNION
1995: SELECT wr.operand_parameter_id
1996: FROM wms_restrictions wr

Line 1996: FROM wms_restrictions wr

1992: FROM wms_restrictions wr
1993: WHERE wr.rule_id = p_rule_id
1994: UNION
1995: SELECT wr.operand_parameter_id
1996: FROM wms_restrictions wr
1997: WHERE wr.rule_id = p_rule_id
1998: AND wr.operand_type_code = 4
1999: UNION
2000: SELECT wrc.parameter_id

Line 2105: , wms_restrictions wr

2101: , wms_db_objects wdor
2102: , wms_parameters_b wpbr
2103: , wms_db_objects wdol
2104: , wms_parameters_b wpbl
2105: , wms_restrictions wr
2106: WHERE wr.rule_id = p_rule_id
2107: AND wpbl.parameter_id = wr.parameter_id
2108: AND wdol.db_object_id(+) = wpbl.db_object_id
2109: AND wpbr.parameter_id(+) = wr.operand_parameter_id

Line 17212: FROM wms_rules_b rules, wms_restrictions rest, wms_parameters_b par

17208: UPDATE wms_rules_b
17209: SET rule_weight = (SELECT 100 * COUNT(parameter_id)
17210: FROM (SELECT DISTINCT rules.rule_id
17211: , par.parameter_id
17212: FROM wms_rules_b rules, wms_restrictions rest, wms_parameters_b par
17213: WHERE rules.rule_id = p_rule_id
17214: AND rules.rule_id = rest.rule_id(+)
17215: AND rest.parameter_id = par.parameter_id(+)
17216: AND (NVL(par.use_for_tt_assn_flag, 'Y') = 'Y'