APPS.OEXCPSVR dependencies on SO_STANDARD_VALUE_RULES

Line 13: INSERT INTO SO_STANDARD_VALUE_RULES

9: )
10:
11: IS
12: BEGIN
13: INSERT INTO SO_STANDARD_VALUE_RULES
14: ( STANDARD_VALUE_RULE_ID
15: , CREATION_DATE
16: , CREATED_BY
17: , LAST_UPDATE_DATE

Line 28: SELECT SO_STANDARD_VALUE_RULES_S.NEXTVAL

24: , ATTRIBUTE_VALUE
25: , OVERRIDE_ALLOWED_FLAG
26: , OVERRIDE_EXISTING_VALUE_FLAG
27: )
28: SELECT SO_STANDARD_VALUE_RULES_S.NEXTVAL
29: , SYSDATE
30: , 1
31: , SYSDATE
32: , 1

Line 41: FROM SO_STANDARD_VALUE_RULES OESRC

37: , STANDARD_VALUE_SOURCE_ID
38: , ATTRIBUTE_VALUE
39: , OVERRIDE_ALLOWED_FLAG
40: , OVERRIDE_EXISTING_VALUE_FLAG
41: FROM SO_STANDARD_VALUE_RULES OESRC
42: WHERE STANDARD_VALUE_RULE_SET_ID = source_id
43: AND NOT EXISTS (
44: SELECT NULL
45: FROM SO_STANDARD_VALUE_RULES OEDST

Line 45: FROM SO_STANDARD_VALUE_RULES OEDST

41: FROM SO_STANDARD_VALUE_RULES OESRC
42: WHERE STANDARD_VALUE_RULE_SET_ID = source_id
43: AND NOT EXISTS (
44: SELECT NULL
45: FROM SO_STANDARD_VALUE_RULES OEDST
46: WHERE OEDST.STANDARD_VALUE_RULE_SET_ID = destination_id
47: AND OEDST.ATTRIBUTE_ID = OESRC.ATTRIBUTE_ID
48: AND OEDST.STANDARD_VALUE_SOURCE_ID =
49: OESRC.STANDARD_VALUE_SOURCE_ID);