APPS.PV_CATEGORY_MIGRATION dependencies on AS_INTEREST_CODES_VL

Line 92: from as_interest_types_vl i, as_interest_codes_vl p

88: union
89: select i.interest_type ||'/'||p.code code,
90: i.interest_type_id ||'/'||p.interest_code_id id,
91: p.product_category_id
92: from as_interest_types_vl i, as_interest_codes_vl p
93: where i.interest_type_id*1 = p.interest_type_id and
94: p.parent_interest_code_id is null
95: union
96: select i.interest_type ||'/'||p.code ||'/'||s.code code,

Line 99: from as_interest_types_vl i, as_interest_codes_vl p,

95: union
96: select i.interest_type ||'/'||p.code ||'/'||s.code code,
97: i.interest_type_id ||'/'||p.interest_code_id ||'/'||s.interest_code_id id,
98: s.product_category_id
99: from as_interest_types_vl i, as_interest_codes_vl p,
100: as_interest_codes_vl s
101: where i.interest_type_id = p.interest_type_id and
102: p.interest_type_id = s.interest_type_id*1 and
103: s.parent_interest_code_id = p.interest_code_id

Line 100: as_interest_codes_vl s

96: select i.interest_type ||'/'||p.code ||'/'||s.code code,
97: i.interest_type_id ||'/'||p.interest_code_id ||'/'||s.interest_code_id id,
98: s.product_category_id
99: from as_interest_types_vl i, as_interest_codes_vl p,
100: as_interest_codes_vl s
101: where i.interest_type_id = p.interest_type_id and
102: p.interest_type_id = s.interest_type_id*1 and
103: s.parent_interest_code_id = p.interest_code_id
104: ) b

Line 124: from as_interest_types_vl i, as_interest_codes_vl p

120: union
121: select i.interest_type ||'/'||p.code code,
122: i.interest_type_id ||'/'||p.interest_code_id id,
123: p.product_category_id
124: from as_interest_types_vl i, as_interest_codes_vl p
125: where i.interest_type_id*1 = p.interest_type_id and
126: p.parent_interest_code_id is null
127: union
128: select i.interest_type ||'/'||p.code ||'/'||s.code code,

Line 131: from as_interest_types_vl i, as_interest_codes_vl p,

127: union
128: select i.interest_type ||'/'||p.code ||'/'||s.code code,
129: i.interest_type_id ||'/'||p.interest_code_id ||'/'||s.interest_code_id id,
130: s.product_category_id
131: from as_interest_types_vl i, as_interest_codes_vl p,
132: as_interest_codes_vl s
133: where i.interest_type_id = p.interest_type_id and
134: p.interest_type_id = s.interest_type_id*1 and
135: s.parent_interest_code_id = p.interest_code_id

Line 132: as_interest_codes_vl s

128: select i.interest_type ||'/'||p.code ||'/'||s.code code,
129: i.interest_type_id ||'/'||p.interest_code_id ||'/'||s.interest_code_id id,
130: s.product_category_id
131: from as_interest_types_vl i, as_interest_codes_vl p,
132: as_interest_codes_vl s
133: where i.interest_type_id = p.interest_type_id and
134: p.interest_type_id = s.interest_type_id*1 and
135: s.parent_interest_code_id = p.interest_code_id
136: ) b