[Home] [Help]
1268: -- Forming group by statement for the inner SQL.
1269: -- -------------------------------------------------------------------------------
1270: IF p_selection_criteria = g_drop_attr_match THEN
1271:
1272: l_where := l_where || ') group by party_id having mod(sum(rank),2) <> 0 ) t, pv_partner_profiles pvpp ';
1273:
1274: ELSIF p_selection_criteria = g_nodrop_attr_match THEN
1275:
1276: l_where := l_where || ') group by party_id ) t, pv_partner_profiles pvpp ';
1272: l_where := l_where || ') group by party_id having mod(sum(rank),2) <> 0 ) t, pv_partner_profiles pvpp ';
1273:
1274: ELSIF p_selection_criteria = g_nodrop_attr_match THEN
1275:
1276: l_where := l_where || ') group by party_id ) t, pv_partner_profiles pvpp ';
1277:
1278: END IF;
1279:
1280:
2121: hzp.party_name,
2122: hzop_pt.internal_flag pt_int_flag,
2123: vend.party_name,
2124: hzop_vend.internal_flag vend_int_flag
2125: from hz_parties hzp , pv_partner_profiles pvpp , hz_parties vend,
2126: hz_relationships hzr,
2127: hz_organization_profiles HZOP_pt,
2128: hz_organization_profiles hzop_vend
2129: where hzr.party_id = pvpp.partner_id
2166: and hzr.start_date <= SYSDATE and NVL(hzr.end_date,SYSDATE) >= SYSDATE
2167: then 'A'
2168: else 'I'
2169: end ) active_flag
2170: from hz_parties hzp , pv_partner_profiles pvpp ,
2171: pv_attribute_codes_vl pvac, hz_relationships hzr ,
2172: hz_organization_profiles HZOP,
2173: (SELECT rownum idx, column_value
2174: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2193: to_char(pvpp.OPPTY_LAST_OFFERED_DATE, 'YYYY-MM-DD HH:MM:SS'),
2194: pvac.description,
2195: pvpp.status active_flag
2196: from hz_parties hzp,
2197: pv_partner_profiles pvpp,
2198: pv_attribute_codes_vl pvac,
2199: (SELECT rownum idx, column_value
2200: FROM (SELECT column_value FROM TABLE (CAST(p_matched_id AS JTF_NUMBER_TABLE)))) x_partner
2201: where pvpp.partner_id = x_partner.column_value
2281: 'hzp.postal_code, hzp.country, hzp.address1, hzp.address2, hzp.address3, '||
2282: 'hzp.party_id, pvpp.partner_id, pvac.description, '||
2283: 'to_char(pvpp.oppty_last_offered_date, ''YYYY-MM-DD HH:MI:SS''), '||
2284: 'pvpp.status active_flag ' ||
2285: 'from hz_parties hzp , pv_partner_profiles pvpp, pv_attribute_codes_tl pvac, '||
2286: '(SELECT rownum idx, column_value FROM '||
2287: '(SELECT column_value FROM TABLE (CAST(:1 AS JTF_NUMBER_TABLE)))) x_partner '||
2288: 'where pvpp.partner_id = x_partner.column_value ' ||
2289: 'and pvpp.partner_party_id = hzp.party_id ' ||