[Home] [Help]
993: wms_strategies_b wsb,
994: wms_strategy_members wsm,
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
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
1801: SELECT wr.parameter_id
1802: FROM wms_restrictions wr
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
1835: SELECT wrd.parameter_id
1836: FROM wms_restrictions wrd
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
1866: SELECT wr.parameter_id
1867: FROM wms_restrictions wr
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
1904: SELECT wr.parameter_id
1905: FROM wms_restrictions wr
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;