[Home] [Help]
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
1079: AND wsc.enabled_flag = 1
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
1888: SELECT wr.parameter_id
1889: FROM wms_restrictions wr
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
1922: SELECT wrd.parameter_id
1923: FROM wms_restrictions wrd
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
1953: SELECT wr.parameter_id
1954: FROM wms_restrictions wr
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
1991: SELECT wr.parameter_id
1992: FROM wms_restrictions wr
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;