APPS.PV_CATEGORY_MIGRATION dependencies on AS_INTEREST_TYPES_VL

Line 87: from as_interest_types_vl

83: (
84: select interest_type code,
85: TO_CHAR(interest_type_id) id,
86: product_category_id
87: from as_interest_types_vl
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

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 119: from as_interest_types_vl

115: (
116: select interest_type code,
117: TO_CHAR(interest_type_id) id,
118: product_category_id
119: from as_interest_types_vl
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

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