APPS.AML_CATEGORY_MIGRATION dependencies on AS_INTEREST_TYPES_VL

Line 134: FROM as_interest_types_vl

130:
131: --- Cursor to check if all the interest types/codes are mapped.
132: CURSOR c_interest_codes IS
133: SELECT to_char(interest_type_id) code, description meaning
134: FROM as_interest_types_vl
135: WHERE product_category_id IS NULL
136: UNION
137: SELECT to_char(i.interest_type_id)||'/'||p.interest_code_id code,
138: i.description||'/'||p.description meaning

Line 139: FROM as_interest_types_vl i, as_interest_codes_vl p

135: WHERE product_category_id IS NULL
136: UNION
137: SELECT to_char(i.interest_type_id)||'/'||p.interest_code_id code,
138: i.description||'/'||p.description meaning
139: FROM as_interest_types_vl i, as_interest_codes_vl p
140: WHERE i.interest_type_id*1 = p.interest_type_id
141: AND p.parent_interest_code_id is null
142: AND p.product_category_id IS NULL
143: UNION

Line 146: FROM as_interest_types_vl i, as_interest_codes_vl p, as_interest_codes_vl s

142: AND p.product_category_id IS NULL
143: UNION
144: SELECT to_char(i.interest_type_id)||'/'||p.interest_code_id||'/'||
145: s.interest_code_id code, i.description||'/'||p.description||'/'||s.description meaning
146: FROM as_interest_types_vl i, as_interest_codes_vl p, as_interest_codes_vl s
147: WHERE i.interest_type_id = p.interest_type_id
148: AND p.interest_type_id = s.interest_type_id*1
149: AND s.parent_interest_code_id = p.interest_code_id
150: AND s.product_category_id IS NULL;

Line 154: FROM as_sales_lead_lines line, as_interest_types_vl interest

150: AND s.product_category_id IS NULL;
151:
152: CURSOR c_lead_line_values IS
153: SELECT distinct to_char(interest.interest_type_id) code ,interest.description meaning
154: FROM as_sales_lead_lines line, as_interest_types_vl interest
155: WHERE line.interest_type_id = interest.interest_type_id
156: AND line.primary_interest_code_id is null
157: AND line.secondary_interest_code_id is null
158: AND interest.product_category_id is null

Line 162: FROM as_sales_lead_lines line, as_interest_codes_vl pic, as_interest_types_vl interest

158: AND interest.product_category_id is null
159: UNION
160: SELECT distinct to_char(interest.interest_type_id)||'/'||pic.interest_code_id code,
161: interest.description||'/'||pic.description meaning
162: FROM as_sales_lead_lines line, as_interest_codes_vl pic, as_interest_types_vl interest
163: WHERE line.primary_interest_code_id = pic.interest_code_id
164: AND pic.interest_type_id = interest.interest_type_id
165: AND pic.parent_interest_code_id is null
166: AND line.secondary_interest_code_id is null

Line 171: FROM as_sales_lead_lines line, as_interest_codes_vl sic, as_interest_codes_vl pic, as_interest_types_vl interest

167: AND pic.product_category_id is null
168: UNION
169: SELECT distinct to_char(interest.interest_type_id)||'/'||pic.interest_code_id||'/'||sic.interest_code_id code,
170: interest.description||'/'||pic.description||'/'||sic.description meaning
171: FROM as_sales_lead_lines line, as_interest_codes_vl sic, as_interest_codes_vl pic, as_interest_types_vl interest
172: WHERE line.secondary_interest_code_id = sic.interest_code_id
173: AND line.primary_interest_code_id = sic.parent_interest_code_id
174: AND sic.interest_type_id = interest.interest_type_id
175: and sic.parent_interest_code_id = pic.interest_code_id