APPS.WMS_RULE_PVT dependencies on WMS_RULE_CONSISTENCIES

Line 1076: wms_rule_consistencies c,

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

Line 1898: FROM wms_rule_consistencies wrc

1894: WHERE wr.rule_id = p_rule_id
1895: AND wr.operand_type_code = 4
1896: UNION
1897: SELECT wrc.parameter_id
1898: FROM wms_rule_consistencies wrc
1899: WHERE wrc.rule_id = p_rule_id) x
1900: WHERE wpb.parameter_id = x.parameter_id
1901: AND wpb.db_object_ref_type_code = 1
1902: AND wdo.db_object_id = wpb.db_object_id

Line 1932: FROM wms_rule_consistencies wrcd

1928: WHERE wrd.rule_id = p_rule_id
1929: AND wrd.operand_type_code = 4
1930: UNION
1931: SELECT wrcd.parameter_id
1932: FROM wms_rule_consistencies wrcd
1933: WHERE wrcd.rule_id = p_rule_id) xd
1934: WHERE wpbd.parameter_id = xd.parameter_id
1935: AND wpbd.db_object_ref_type_code = 1
1936: AND wdod.db_object_id = wpbd.db_object_id)) x

Line 1963: FROM wms_rule_consistencies wrc

1959: WHERE wr.rule_id = p_rule_id
1960: AND wr.operand_type_code = 4
1961: UNION
1962: SELECT wrc.parameter_id
1963: FROM wms_rule_consistencies wrc
1964: WHERE wrc.rule_id = p_rule_id) x
1965: WHERE wpb.parameter_id = x.parameter_id
1966: AND wpb.db_object_ref_type_code = 2
1967: AND wdor.db_object_reference_id = wpb.db_object_reference_id

Line 2001: FROM wms_rule_consistencies wrc

1997: WHERE wr.rule_id = p_rule_id
1998: AND wr.operand_type_code = 4
1999: UNION
2000: SELECT wrc.parameter_id
2001: FROM wms_rule_consistencies wrc
2002: WHERE wrc.rule_id = p_rule_id) xi
2003: WHERE wpbi.parameter_id = xi.parameter_id
2004: AND wpbi.db_object_ref_type_code = 2
2005: AND wdori.db_object_reference_id = wpbi.db_object_reference_id

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

8694:
8695: --cursor used to determine if rule has any consistency requirements
8696: CURSOR l_consist IS
8697: SELECT consistency_id
8698: FROM wms_rule_consistencies
8699: WHERE rule_id = l_rule_id;
8700:
8701: --cursor to get the total quantity for the LPN
8702: CURSOR c_lpn_quantity IS

Line 18539: FROM wms_rule_consistencies

18535:
18536: --cursor used to determine if rule has any consistency requirements
18537: CURSOR l_consist IS
18538: SELECT consistency_id
18539: FROM wms_rule_consistencies
18540: WHERE rule_id = l_rule_id;
18541:
18542: --cursor to get the total quantity for the LPN
18543: CURSOR c_lpn_quantity IS