415: lh.name, b.attribute1
416: FROM
417: qp_list_headers_tl lh,
418: qp_list_headers_b b,
419: qp_qualifiers qc,
420: qp_qualifiers qs,
421: qp_qualifiers qm
422: WHERE
423: lh.list_header_id = b.list_header_id AND
416: FROM
417: qp_list_headers_tl lh,
418: qp_list_headers_b b,
419: qp_qualifiers qc,
420: qp_qualifiers qs,
421: qp_qualifiers qm
422: WHERE
423: lh.list_header_id = b.list_header_id AND
424: qc.qualifier_attribute = 'QUALIFIER_ATTRIBUTE1' AND
417: qp_list_headers_tl lh,
418: qp_list_headers_b b,
419: qp_qualifiers qc,
420: qp_qualifiers qs,
421: qp_qualifiers qm
422: WHERE
423: lh.list_header_id = b.list_header_id AND
424: qc.qualifier_attribute = 'QUALIFIER_ATTRIBUTE1' AND
425: qc.qualifier_context = 'PARTY' AND
2205: l_end_date
2206: FROM
2207: qp_list_headers_tl lh,
2208: qp_list_headers_b b,
2209: qp_qualifiers q
2210: WHERE
2211: lh.list_header_id = b.list_header_id AND
2212: lh.list_header_id = q.list_header_id AND
2213: q.qualifier_context = 'PARTY' AND
2306: l_list_header_id
2307: FROM
2308: qp_list_headers_tl modc,
2309: qp_list_headers_b b,
2310: qp_qualifiers qual
2311: WHERE
2312: modc.list_header_id = b.list_header_id AND
2313: qual.list_header_id = modc.list_header_id AND
2314: qual.qualifier_context = 'MODLIST' AND