APPS.WMS_RULE_PVT dependencies on WMS_RULE_CONSISTENCIES

Line 998: wms_rule_consistencies c,

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
1002: AND wsc.return_type_code = 'S'

Line 1811: FROM wms_rule_consistencies wrc

1807: WHERE wr.rule_id = p_rule_id
1808: AND wr.operand_type_code = 4
1809: UNION
1810: SELECT wrc.parameter_id
1811: FROM wms_rule_consistencies wrc
1812: WHERE wrc.rule_id = p_rule_id) x
1813: WHERE wpb.parameter_id = x.parameter_id
1814: AND wpb.db_object_ref_type_code = 1
1815: AND wdo.db_object_id = wpb.db_object_id

Line 1845: FROM wms_rule_consistencies wrcd

1841: WHERE wrd.rule_id = p_rule_id
1842: AND wrd.operand_type_code = 4
1843: UNION
1844: SELECT wrcd.parameter_id
1845: FROM wms_rule_consistencies wrcd
1846: WHERE wrcd.rule_id = p_rule_id) xd
1847: WHERE wpbd.parameter_id = xd.parameter_id
1848: AND wpbd.db_object_ref_type_code = 1
1849: AND wdod.db_object_id = wpbd.db_object_id)) x

Line 1876: FROM wms_rule_consistencies wrc

1872: WHERE wr.rule_id = p_rule_id
1873: AND wr.operand_type_code = 4
1874: UNION
1875: SELECT wrc.parameter_id
1876: FROM wms_rule_consistencies wrc
1877: WHERE wrc.rule_id = p_rule_id) x
1878: WHERE wpb.parameter_id = x.parameter_id
1879: AND wpb.db_object_ref_type_code = 2
1880: AND wdor.db_object_reference_id = wpb.db_object_reference_id

Line 1914: FROM wms_rule_consistencies wrc

1910: WHERE wr.rule_id = p_rule_id
1911: AND wr.operand_type_code = 4
1912: UNION
1913: SELECT wrc.parameter_id
1914: FROM wms_rule_consistencies wrc
1915: WHERE wrc.rule_id = p_rule_id) xi
1916: WHERE wpbi.parameter_id = xi.parameter_id
1917: AND wpbi.db_object_ref_type_code = 2
1918: AND wdori.db_object_reference_id = wpbi.db_object_reference_id

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 6753: FROM wms_rule_consistencies

6749:
6750: --cursor used to determine if rule has any consistency requirements
6751: CURSOR l_consist IS
6752: SELECT consistency_id
6753: FROM wms_rule_consistencies
6754: WHERE rule_id = l_rule_id;
6755:
6756: --cursor to get lpn controlled flag from subinventory
6757: CURSOR c_subinventory IS

Line 15892: FROM wms_rule_consistencies

15888:
15889: --cursor used to determine if rule has any consistency requirements
15890: CURSOR l_consist IS
15891: SELECT consistency_id
15892: FROM wms_rule_consistencies
15893: WHERE rule_id = l_rule_id;
15894:
15895: --cursor to get lpn controlled flag from subinventory
15896: CURSOR c_subinventory IS