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_PARAMETERS_B

Line 1077: wms_parameters_b p

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
1079: AND wsc.enabled_flag = 1
1080: AND wsc.return_type_code = 'S'
1081: AND wsc.from_organization_id = p_organization_id

Line 1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;

1822: l_table_name wms_db_objects.table_name%TYPE;
1823: l_table_alias wms_db_objects.table_alias%TYPE;
1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1827: l_column_name wms_parameters_b.column_name%TYPE;
1828: l_expression wms_parameters_b.expression%TYPE;
1829: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1830: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;

Line 1827: l_column_name wms_parameters_b.column_name%TYPE;

1823: l_table_alias wms_db_objects.table_alias%TYPE;
1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1827: l_column_name wms_parameters_b.column_name%TYPE;
1828: l_expression wms_parameters_b.expression%TYPE;
1829: l_data_type_code wms_parameters_b.data_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;

Line 1828: l_expression wms_parameters_b.expression%TYPE;

1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1827: l_column_name wms_parameters_b.column_name%TYPE;
1828: l_expression wms_parameters_b.expression%TYPE;
1829: l_data_type_code wms_parameters_b.data_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;

Line 1829: l_data_type_code wms_parameters_b.data_type_code%TYPE;

1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1827: l_column_name wms_parameters_b.column_name%TYPE;
1828: l_expression wms_parameters_b.expression%TYPE;
1829: l_data_type_code wms_parameters_b.data_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;

Line 1830: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;

1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1827: l_column_name wms_parameters_b.column_name%TYPE;
1828: l_expression wms_parameters_b.expression%TYPE;
1829: l_data_type_code wms_parameters_b.data_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;

Line 1831: l_parent_column_name wms_parameters_b.column_name%TYPE;

1827: l_column_name wms_parameters_b.column_name%TYPE;
1828: l_expression wms_parameters_b.expression%TYPE;
1829: l_data_type_code wms_parameters_b.data_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;

Line 1832: l_parent_expression wms_parameters_b.expression%TYPE;

1828: l_expression wms_parameters_b.expression%TYPE;
1829: l_data_type_code wms_parameters_b.data_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;

Line 1833: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;

1829: l_data_type_code wms_parameters_b.data_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;

Line 1883: , wms_parameters_b wpb

1879: , wdo.table_name
1880: , wdo.table_alias
1881: , wdo.context_dependent_flag
1882: FROM wms_db_objects wdo
1883: , wms_parameters_b wpb
1884: , (SELECT wsc.parameter_id
1885: FROM wms_sort_criteria wsc
1886: WHERE wsc.rule_id = p_rule_id
1887: UNION

Line 1917: , wms_parameters_b wpbd

1913: WHERE wdop.type_code = p_type_code
1914: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id
1915: START WITH wdop.db_object_id IN (SELECT wdod.db_object_id
1916: FROM wms_db_objects wdod
1917: , wms_parameters_b wpbd
1918: , (SELECT wscd.parameter_id
1919: FROM wms_sort_criteria wscd
1920: WHERE wscd.rule_id = p_rule_id
1921: UNION

Line 1948: , wms_parameters_b wpb

1944: , wdo.context_dependent_flag
1945: FROM wms_db_objects wdo
1946: , wms_db_obj_ref_members wdorm
1947: , wms_db_object_references wdor
1948: , wms_parameters_b wpb
1949: , (SELECT wsc.parameter_id
1950: FROM wms_sort_criteria wsc
1951: WHERE wsc.rule_id = p_rule_id
1952: UNION

Line 1986: , wms_parameters_b wpbi

1982: START WITH wdop.db_object_id IN (SELECT wdoi.db_object_id
1983: FROM wms_db_objects wdoi
1984: , wms_db_obj_ref_members wdormi
1985: , wms_db_object_references wdori
1986: , wms_parameters_b wpbi
1987: , (SELECT wsc.parameter_id
1988: FROM wms_sort_criteria wsc
1989: WHERE wsc.rule_id = p_rule_id
1990: UNION

Line 2025: FROM wms_db_objects wdop, wms_parameters_b wpbp, wms_parameters_b wpb, wms_db_object_joins wdoj

2021: , wpbp.column_name
2022: , wpbp.expression
2023: , wpbp.data_type_code
2024: , wdop.table_alias -- alias n.a. for multi object based parameters
2025: FROM wms_db_objects wdop, wms_parameters_b wpbp, wms_parameters_b wpb, wms_db_object_joins wdoj
2026: WHERE wdoj.db_object_id = l_db_object_id
2027: AND wdoj.type_code = p_type_code
2028: AND wpb.parameter_id = wdoj.parameter_id
2029: AND wpbp.parameter_id = wdoj.parent_parameter_id

Line 2041: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_rules_b wrb

2037: , wpb.column_name
2038: , wpb.expression
2039: , wpb.data_type_code
2040: , wdo.table_alias -- alias n.a. for multi object based parameters
2041: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_rules_b wrb
2042: WHERE wrb.rule_id = p_rule_id
2043: AND wpb.parameter_id = wrb.qty_function_parameter_id
2044: AND wdo.db_object_id(+) = wpb.db_object_id;
2045:

Line 2102: , wms_parameters_b wpbr

2098: , wr.sequence_number
2099: FROM fnd_flex_validation_tables ffvt
2100: , fnd_flex_value_sets ffvs
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

Line 2104: , wms_parameters_b wpbl

2100: , fnd_flex_value_sets ffvs
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

Line 2139: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_sort_criteria wsc

2135: , wsc.rule_id
2136: , wsc.sequence_number
2137: , wpb.object_id -- Added for Bug 13448337
2138: , wsc.parameter_id -- Added for Bug 13448337
2139: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_sort_criteria wsc
2140: WHERE wsc.rule_id = p_rule_id
2141: AND wpb.parameter_id = wsc.parameter_id
2142: AND wdo.db_object_id(+) = wpb.db_object_id
2143: ORDER BY wsc.rule_id, wsc.sequence_number;

Line 2153: FROM wms_rule_consistencies wrc, wms_parameters_b wpb, wms_db_objects wdo

2149: SELECT wpb.parameter_type_code
2150: , wpb.column_name
2151: , wpb.expression
2152: , wdo.table_alias
2153: FROM wms_rule_consistencies wrc, wms_parameters_b wpb, wms_db_objects wdo
2154: WHERE wrc.rule_id = p_rule_id
2155: AND wpb.parameter_id = wrc.parameter_id
2156: AND wdo.db_object_id(+) = wpb.db_object_id;
2157: BEGIN

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'