APPS.AML_CATEGORY_MIGRATION dependencies on AS_INTEREST_CODES_VL

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 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