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 999: wms_parameters_b p

995: wms_rules_b wrb,
996: wms_restrictions r,
997: wms_sort_criteria s,
998: wms_rule_consistencies c,
999: wms_parameters_b p
1000: WHERE wsc.rule_type_code = 2
1001: AND wsc.enabled_flag = 1
1002: AND wsc.return_type_code = 'S'
1003: AND wsc.from_organization_id = p_organization_id

Line 1743: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;

1739: l_table_name wms_db_objects.table_name%TYPE;
1740: l_table_alias wms_db_objects.table_alias%TYPE;
1741: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1742: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1743: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1744: l_column_name wms_parameters_b.column_name%TYPE;
1745: l_expression wms_parameters_b.expression%TYPE;
1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;

Line 1744: l_column_name wms_parameters_b.column_name%TYPE;

1740: l_table_alias wms_db_objects.table_alias%TYPE;
1741: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1742: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1743: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1744: l_column_name wms_parameters_b.column_name%TYPE;
1745: l_expression wms_parameters_b.expression%TYPE;
1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1748: l_parent_column_name wms_parameters_b.column_name%TYPE;

Line 1745: l_expression wms_parameters_b.expression%TYPE;

1741: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1742: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1743: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1744: l_column_name wms_parameters_b.column_name%TYPE;
1745: l_expression wms_parameters_b.expression%TYPE;
1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1748: l_parent_column_name wms_parameters_b.column_name%TYPE;
1749: l_parent_expression wms_parameters_b.expression%TYPE;

Line 1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;

1742: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1743: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1744: l_column_name wms_parameters_b.column_name%TYPE;
1745: l_expression wms_parameters_b.expression%TYPE;
1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1748: l_parent_column_name wms_parameters_b.column_name%TYPE;
1749: l_parent_expression wms_parameters_b.expression%TYPE;
1750: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;

Line 1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;

1743: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1744: l_column_name wms_parameters_b.column_name%TYPE;
1745: l_expression wms_parameters_b.expression%TYPE;
1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1748: l_parent_column_name wms_parameters_b.column_name%TYPE;
1749: l_parent_expression wms_parameters_b.expression%TYPE;
1750: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;
1751: l_operand_type_code wms_restrictions.operand_type_code%TYPE;

Line 1748: l_parent_column_name wms_parameters_b.column_name%TYPE;

1744: l_column_name wms_parameters_b.column_name%TYPE;
1745: l_expression wms_parameters_b.expression%TYPE;
1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1748: l_parent_column_name wms_parameters_b.column_name%TYPE;
1749: l_parent_expression wms_parameters_b.expression%TYPE;
1750: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;
1751: l_operand_type_code wms_restrictions.operand_type_code%TYPE;
1752: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;

Line 1749: l_parent_expression wms_parameters_b.expression%TYPE;

1745: l_expression wms_parameters_b.expression%TYPE;
1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1748: l_parent_column_name wms_parameters_b.column_name%TYPE;
1749: l_parent_expression wms_parameters_b.expression%TYPE;
1750: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;
1751: l_operand_type_code wms_restrictions.operand_type_code%TYPE;
1752: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;
1753: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;

Line 1750: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;

1746: l_data_type_code wms_parameters_b.data_type_code%TYPE;
1747: l_parent_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1748: l_parent_column_name wms_parameters_b.column_name%TYPE;
1749: l_parent_expression wms_parameters_b.expression%TYPE;
1750: l_parent_data_type_code wms_parameters_b.data_type_code%TYPE;
1751: l_operand_type_code wms_restrictions.operand_type_code%TYPE;
1752: l_operand_constant_number wms_restrictions.operand_constant_number%TYPE;
1753: l_operand_constant_character wms_restrictions.operand_constant_character%TYPE;
1754: l_operand_constant_date wms_restrictions.operand_constant_date%TYPE;

Line 1796: , wms_parameters_b wpb

1792: , wdo.table_name
1793: , wdo.table_alias
1794: , wdo.context_dependent_flag
1795: FROM wms_db_objects wdo
1796: , wms_parameters_b wpb
1797: , (SELECT wsc.parameter_id
1798: FROM wms_sort_criteria wsc
1799: WHERE wsc.rule_id = p_rule_id
1800: UNION

Line 1830: , wms_parameters_b wpbd

1826: WHERE wdop.type_code = p_type_code
1827: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id
1828: START WITH wdop.db_object_id IN (SELECT wdod.db_object_id
1829: FROM wms_db_objects wdod
1830: , wms_parameters_b wpbd
1831: , (SELECT wscd.parameter_id
1832: FROM wms_sort_criteria wscd
1833: WHERE wscd.rule_id = p_rule_id
1834: UNION

Line 1861: , wms_parameters_b wpb

1857: , wdo.context_dependent_flag
1858: FROM wms_db_objects wdo
1859: , wms_db_obj_ref_members wdorm
1860: , wms_db_object_references wdor
1861: , wms_parameters_b wpb
1862: , (SELECT wsc.parameter_id
1863: FROM wms_sort_criteria wsc
1864: WHERE wsc.rule_id = p_rule_id
1865: UNION

Line 1899: , wms_parameters_b wpbi

1895: START WITH wdop.db_object_id IN (SELECT wdoi.db_object_id
1896: FROM wms_db_objects wdoi
1897: , wms_db_obj_ref_members wdormi
1898: , wms_db_object_references wdori
1899: , wms_parameters_b wpbi
1900: , (SELECT wsc.parameter_id
1901: FROM wms_sort_criteria wsc
1902: WHERE wsc.rule_id = p_rule_id
1903: UNION

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

1934: , wpbp.column_name
1935: , wpbp.expression
1936: , wpbp.data_type_code
1937: , wdop.table_alias -- alias n.a. for multi object based parameters
1938: FROM wms_db_objects wdop, wms_parameters_b wpbp, wms_parameters_b wpb, wms_db_object_joins wdoj
1939: WHERE wdoj.db_object_id = l_db_object_id
1940: AND wdoj.type_code = p_type_code
1941: AND wpb.parameter_id = wdoj.parameter_id
1942: AND wpbp.parameter_id = wdoj.parent_parameter_id

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

1950: , wpb.column_name
1951: , wpb.expression
1952: , wpb.data_type_code
1953: , wdo.table_alias -- alias n.a. for multi object based parameters
1954: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_rules_b wrb
1955: WHERE wrb.rule_id = p_rule_id
1956: AND wpb.parameter_id = wrb.qty_function_parameter_id
1957: AND wdo.db_object_id(+) = wpb.db_object_id;
1958:

Line 2015: , wms_parameters_b wpbr

2011: , wr.sequence_number
2012: FROM fnd_flex_validation_tables ffvt
2013: , fnd_flex_value_sets ffvs
2014: , wms_db_objects wdor
2015: , wms_parameters_b wpbr
2016: , wms_db_objects wdol
2017: , wms_parameters_b wpbl
2018: , wms_restrictions wr
2019: WHERE wr.rule_id = p_rule_id

Line 2017: , wms_parameters_b wpbl

2013: , fnd_flex_value_sets ffvs
2014: , wms_db_objects wdor
2015: , wms_parameters_b wpbr
2016: , wms_db_objects wdol
2017: , wms_parameters_b wpbl
2018: , wms_restrictions wr
2019: WHERE wr.rule_id = p_rule_id
2020: AND wpbl.parameter_id = wr.parameter_id
2021: AND wdol.db_object_id(+) = wpbl.db_object_id

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

2046: )
2047: , DECODE(wsc.order_code, 1, 'asc', 2, 'desc', NULL)
2048: , wsc.rule_id
2049: , wsc.sequence_number
2050: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_sort_criteria wsc
2051: WHERE wsc.rule_id = p_rule_id
2052: AND wpb.parameter_id = wsc.parameter_id
2053: AND wdo.db_object_id(+) = wpb.db_object_id
2054: ORDER BY wsc.rule_id, wsc.sequence_number;

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

2060: SELECT wpb.parameter_type_code
2061: , wpb.column_name
2062: , wpb.expression
2063: , wdo.table_alias
2064: FROM wms_rule_consistencies wrc, wms_parameters_b wpb, wms_db_objects wdo
2065: WHERE wrc.rule_id = p_rule_id
2066: AND wpb.parameter_id = wrc.parameter_id
2067: AND wdo.db_object_id(+) = wpb.db_object_id;
2068: BEGIN

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

14557: UPDATE wms_rules_b
14558: SET rule_weight = (SELECT 100 * COUNT(parameter_id)
14559: FROM (SELECT DISTINCT rules.rule_id
14560: , par.parameter_id
14561: FROM wms_rules_b rules, wms_restrictions rest, wms_parameters_b par
14562: WHERE rules.rule_id = p_rule_id
14563: AND rules.rule_id = rest.rule_id(+)
14564: AND rest.parameter_id = par.parameter_id(+)
14565: AND (NVL(par.use_for_tt_assn_flag, 'Y') = 'Y'