eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOC_NUMBERING_PKG dependencies on PO_HEADERS_ALL

Line 76: FROM po_headers_draft_all phda, po_headers_all pha

72: --and pass it as an external parameter
73: BEGIN
74: --This is an autocreate case with idv number populated.
75: SELECT pha.clm_document_number INTO l_idv_number
76: FROM po_headers_draft_all phda, po_headers_all pha
77: WHERE phda.po_header_id = p_doc_header_id
78: AND phda.clm_source_document_id = pha.po_header_id;
79: EXCEPTION
80: WHEN No_Data_Found THEN

Line 84: FROM po_headers_all pha1, po_headers_all pha2

80: WHEN No_Data_Found THEN
81: BEGIN
82: --This is an copy case where idv number is populated
83: SELECT pha2.clm_document_number INTO l_idv_number
84: FROM po_headers_all pha1, po_headers_all pha2
85: WHERE pha1.po_header_id = p_doc_header_id
86: AND pha1.clm_source_document_id = pha2.po_header_id;
87: EXCEPTION
88: WHEN No_Data_Found THEN

Line 344: FROM po_headers_all_ext_b

340:
341: ELSIF p_caller = 'PO' OR p_caller = 'PO_MOD' THEN
342:
343: SELECT c_ext_attr40 INTO x_doc_number
344: FROM po_headers_all_ext_b
345: WHERE po_header_id = p_doc_header_id
346: AND draft_id = p_draft_id
347: AND attr_group_id = l_attrb_grp_id;
348:

Line 1572: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||

1568: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
1569: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
1570: ' minus '||
1571: ' SELECT distinct plc.lookup_code FROM '||
1572: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
1573: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
1574: ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
1575: ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
1576: ' and prheb.C_EXT_ATTR2 = '||x_fiscal_year ||

Line 1597: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||

1593: AND language = userenv ('LANG')
1594: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1595:
1596: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
1597: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
1598: ' WHERE prheb..C_EXT_ATTR1 = '''||x_prefix ||''''||
1599: ' AND prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
1600: ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
1601: ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||

Line 1726: from PO_HEADERS_ALL_EXT_B

1722:
1723: ELSE
1724:
1725: select count(*) INTO l_cnt
1726: from PO_HEADERS_ALL_EXT_B
1727: WHERE C_EXT_ATTR40 = x_document_number
1728: AND po_header_id <> x_order_header_id;
1729:
1730: IF l_cnt > 0 THEN

Line 1825: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||

1821: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
1822: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
1823: ' minus '||
1824: ' SELECT distinct plc.lookup_code FROM '||
1825: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
1826: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
1827: ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
1828: ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
1829: ' and prheb.C_EXT_ATTR2 = '||x_fiscal_year ||

Line 1850: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||

1846: AND language = userenv ('LANG')
1847: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1848:
1849: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
1850: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
1851: ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
1852: ' AND prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
1853: ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
1854: ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||

Line 1956: FROM po_headers_all

1952:
1953: IF x_document_number IS NULL THEN
1954:
1955: SELECT CLM_DOCUMENT_NUMBER INTO x_base_doc_number
1956: FROM po_headers_all
1957: WHERE po_header_id = p_po_header_id;
1958:
1959: OPEN C;
1960: FETCH C BULK COLLECT INTO l_attr_grp_ids;

Line 1970: ' FROM PO_HEADERS_ALL_EXT_B '||

1966:
1967: l_where_cls := SubStr(l_where_cls,1, Length(l_where_cls)-1);
1968:
1969: l_query := ' SELECT Max(To_Number(C_EXT_ATTR2)) '||
1970: ' FROM PO_HEADERS_ALL_EXT_B '||
1971: ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
1972: ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
1973: ' and C_EXT_ATTR7 not like ''%X%'' ';
1974:

Line 2033: from PO_HEADERS_ALL_EXT_B

2029: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2030: END IF;
2031:
2032: select count(*) INTO l_cnt
2033: from PO_HEADERS_ALL_EXT_B
2034: WHERE C_EXT_ATTR40 = x_document_number
2035: AND draft_id <> p_draft_id
2036: AND po_header_id <> p_po_header_id;
2037:

Line 2911: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||

2907: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
2908: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
2909: ' minus '||
2910: ' SELECT distinct plc.lookup_code FROM '||
2911: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
2912: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
2913: ' and ( prheb.C_EXT_ATTR7 = plc.displayed_field OR SubStr(prheb.C_EXT_ATTR40,-4) = plc.displayed_field)' ||
2914: ' and prheb.C_EXT_ATTR1 = '''||x_dodaac ||''''||
2915: ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||

Line 2936: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||

2932: AND language = userenv ('LANG')
2933: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2934:
2935: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
2936: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
2937: ' WHERE prheb.C_EXT_ATTR1 = ''' || x_dodaac || '''' ||
2938: ' AND prheb.C_EXT_ATTR2 = ''' || x_fiscal_year || '''' ||
2939: ' AND prheb.C_EXT_ATTR3 = ''' || x_instrument_type || '''' ||
2940: ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||

Line 3002: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||

2998: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
2999: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
3000: ' minus '||
3001: ' SELECT distinct plc.lookup_code FROM '||
3002: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
3003: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
3004: ' and ( prheb.C_EXT_ATTR7 = plc.displayed_field OR SubStr(prheb.C_EXT_ATTR40,-4) = plc.displayed_field)' ||
3005: ' and prheb.C_EXT_ATTR1 = '''||x_dodaac ||''''||
3006: ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||

Line 3027: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||

3023: AND language = userenv ('LANG')
3024: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3025:
3026: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
3027: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
3028: ' WHERE prheb.C_EXT_ATTR1 = ''' || x_dodaac || '''' ||
3029: ' AND prheb.C_EXT_ATTR2 = ''' || x_fiscal_year || '''' ||
3030: ' AND prheb.C_EXT_ATTR3 = ''' || x_instrument_type || '''' ||
3031: ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||

Line 3196: from PO_HEADERS_ALL_EXT_B

3192: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3193: END IF;
3194:
3195: select count(*) INTO l_cnt
3196: from PO_HEADERS_ALL_EXT_B
3197: WHERE C_EXT_ATTR40 = x_document_number
3198: AND po_header_id <> x_order_header_id;
3199:
3200: IF l_cnt > 0 THEN

Line 3442: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||

3438: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
3439: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
3440: ' minus '||
3441: ' SELECT distinct plc.lookup_code FROM '||
3442: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
3443: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
3444: ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
3445: ' and prheb.C_EXT_ATTR1 = '''||x_source_doc_number ||''''||
3446: ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||

Line 3465: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||

3461: AND language = userenv ('LANG')
3462: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3463:
3464: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
3465: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
3466: ' WHERE prheb.C_EXT_ATTR1 = '''||x_source_doc_number ||''''||
3467: ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
3468: ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
3469: ' AND flv.language = userenv (''LANG'')' ||

Line 3522: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||

3518: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
3519: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
3520: ' minus '||
3521: ' SELECT distinct plc.lookup_code FROM '||
3522: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
3523: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
3524: ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
3525: ' and prheb.C_EXT_ATTR1 = '''||x_source_doc_number ||''''||
3526: ' and prheb.attr_group_id in ('|| l_where_cls ||')))' ||

Line 3545: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||

3541: AND language = userenv ('LANG')
3542: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3543:
3544: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
3545: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
3546: ' WHERE prheb.C_EXT_ATTR1 = '''||x_source_doc_number ||''''||
3547: ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||
3548: ' AND flv.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
3549: ' AND flv.language = userenv (''LANG'')' ||

Line 3655: from PO_HEADERS_ALL_EXT_B

3651: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3652: ELSE
3653:
3654: select count(*) INTO l_cnt
3655: from PO_HEADERS_ALL_EXT_B
3656: WHERE C_EXT_ATTR40 = x_document_number
3657: AND po_header_id <> x_order_header_id;
3658:
3659: IF l_cnt > 0 THEN

Line 3881: ' FROM PO_HEADERS_ALL_EXT_B '||

3877:
3878: l_where_cls := SubStr(l_where_cls,1, Length(l_where_cls)-1);
3879:
3880: l_query := ' SELECT Max(To_Number(C_EXT_ATTR7)) '||
3881: ' FROM PO_HEADERS_ALL_EXT_B '||
3882: ' where C_EXT_ATTR1 ='''||x_source_doc_number||''' ' ||
3883: ' and C_EXT_ATTR2 ='''|| x_call_order_number ||''' ' ||
3884: ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
3885: ' and C_EXT_ATTR7 not like ''%X%'' ';

Line 3961: from PO_HEADERS_ALL_EXT_B

3957: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
3958: ELSE
3959:
3960: select count(*) INTO l_cnt
3961: from PO_HEADERS_ALL_EXT_B
3962: WHERE C_EXT_ATTR40 = x_document_number
3963: AND po_header_id <> x_order_header_id;
3964:
3965: IF l_cnt > 0 THEN

Line 4316: FROM po_headers_all

4312: IF(x_base_doc_number is NULL AND x_control_char IS NULL AND
4313: x_serial_number IS NULL AND x_document_number IS null) THEN
4314:
4315: SELECT CLM_DOCUMENT_NUMBER INTO x_base_doc_number
4316: FROM po_headers_all
4317: WHERE po_header_id = p_po_header_id;
4318:
4319: x_control_char := 'C';
4320:

Line 4373: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||

4369: ' SELECT lookup_code FROM po_lookup_codes '||
4370: ' WHERE lookup_type='''||l_lookup_const||''' '||
4371: ' minus '||
4372: ' SELECT distinct plc.lookup_code FROM '||
4373: ' PO_HEADERS_ALL_EXT_B prheb, po_lookup_codes plc ' ||
4374: ' WHERE plc.lookup_type='''||l_lookup_const||''''||
4375: ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
4376: ' and prheb.C_EXT_ATTR1 = '''||x_base_doc_number ||''''||
4377: ' and prheb.C_EXT_ATTR2 = '''||x_control_char ||''''||

Line 4384: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||

4380: ' AND lookup_type = '''||l_lookup_const||''' ';*/
4381:
4382: BEGIN
4383: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
4384: ' FROM PO_HEADERS_ALL_EXT_B prheb, fnd_lookup_values flv ' ||
4385: ' WHERE prheb.C_EXT_ATTR1 = '''||x_base_doc_number ||''''||
4386: ' AND prheb.C_EXT_ATTR2 = '''||x_control_char ||''''||
4387: ' AND prheb.C_EXT_ATTR3 = '''||x_modif_type ||''''||
4388: ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||

Line 4463: from PO_HEADERS_ALL_EXT_B

4459:
4460: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN
4461:
4462: select count(*) INTO l_cnt
4463: from PO_HEADERS_ALL_EXT_B
4464: WHERE C_EXT_ATTR40 = x_document_number
4465: AND draft_id <> p_draft_id
4466: AND po_header_id <> p_po_header_id;
4467:

Line 4660: FROM po_headers_all

4656: x_serial_number IS NULL AND x_document_number IS null) THEN
4657:
4658:
4659: SELECT CLM_DOCUMENT_NUMBER INTO x_base_doc_number
4660: FROM po_headers_all
4661: WHERE po_header_id = p_po_header_id;
4662:
4663: x_control_char := 'C';
4664:

Line 4721: ' FROM PO_HEADERS_ALL_EXT_B '||

4717:
4718: l_where_cls := SubStr(l_where_cls,1, Length(l_where_cls)-1);
4719:
4720: l_query := ' SELECT Max(To_Number(C_EXT_ATTR7)) '||
4721: ' FROM PO_HEADERS_ALL_EXT_B '||
4722: ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
4723: ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
4724: ' and C_EXT_ATTR7 not like ''%X%'' ';
4725:

Line 4787: from PO_HEADERS_ALL_EXT_B

4783: END IF;
4784:
4785: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN
4786: select count(*) INTO l_cnt
4787: from PO_HEADERS_ALL_EXT_B
4788: WHERE C_EXT_ATTR40 = x_document_number
4789: AND draft_id <> p_draft_id
4790: AND po_header_id <> p_po_header_id;
4791:

Line 4902: ' FROM PO_HEADERS_ALL_EXT_B '||

4898:
4899: l_where_cls := SubStr(l_where_cls,1, Length(l_where_cls)-1);
4900:
4901: l_query :=' SELECT Max(To_Number(C_EXT_ATTR13)) '||
4902: ' FROM PO_HEADERS_ALL_EXT_B '||
4903: ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
4904: ' and C_EXT_ATTR10 = '''||x_modif_type||''' ' ||
4905: ' and ATTR_GROUP_ID in ('||l_where_cls||') ';
4906:

Line 5030: po_headers_all_ext_b phaeb

5026: INTO l_attr_group_id, l_attr_group_name
5027: FROM PO_UDA_AG_TEMPLATE_USAGES puatu,
5028: po_uda_ag_templates puat,
5029: ego_attr_groups_v ags,
5030: po_headers_all_ext_b phaeb
5031: WHERE puat.ENTITY_CODE=p_ag_type
5032: AND phaeb.po_header_id = p_po_header_id
5033: AND phaeb.draft_id = p_po_draft_id
5034: AND phaeb.attr_group_id = puatu.attribute_group_id

Line 5143: FROM po_headers_all_ext_b

5139:
5140: --Now get the c_ext_attr40 update the modification_number
5141: SELECT c_ext_attr40
5142: INTO l_doc_number
5143: FROM po_headers_all_ext_b
5144: WHERE po_header_id = p_po_header_id
5145: AND draft_id = p_po_draft_id
5146: AND attr_group_id = l_attr_group_id;
5147:

Line 5185: FROM po_headers_all

5181: END IF;
5182:
5183: SELECT clm_document_number
5184: INTO l_source_doc_number
5185: FROM po_headers_all
5186: WHERE po_header_id = p_idv_number;
5187:
5188: --Get user's default DoDAAC
5189: BEGIN

Line 5257: FROM po_headers_all

5253: BEGIN
5254:
5255: SELECT uda_template_id, clm_source_document_id, org_id
5256: INTO l_template_id, l_clm_source_document_id, l_org_id
5257: FROM po_headers_all
5258: WHERE po_header_id = p_po_header_id;
5259:
5260: l_source_org_owned := get_owned_by_issuing_org(l_clm_source_document_id);
5261:

Line 5298: --If there is no org_id fetched from po_headers_all

5294:
5295: -- bug 13054072 : No_data_Found exception needs to be handled if Attribute3 column does not have org_id i.e. Attribute3 has DEFAULT value
5296: EXCEPTION
5297: WHEN No_Data_Found THEN
5298: --If there is no org_id fetched from po_headers_all
5299:
5300: SELECT usages.ATTRIBUTE_GROUP_ID , ags.ATTR_GROUP_NAME
5301: INTO l_attrb_grp_id, l_attr_group_name
5302: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

Line 5431: FROM PO_HEADERS_ALL

5427: WHEN No_Data_Found THEN
5428: --If this is the First Modification of a document
5429: SELECT SEGMENT1
5430: INTO l_base_po_number
5431: FROM PO_HEADERS_ALL
5432: WHERE PO_HEADER_ID = p_document_id;
5433:
5434: l_default_mod_number := l_base_po_number || '-' || '1';
5435: RETURN l_default_mod_number;

Line 5511: FROM po_headers_all

5507: d_progress := 20;
5508:
5509: SELECT CLM_DOCUMENT_NUMBER, TYPE_LOOKUP_CODE, ORG_ID, CLM_SOURCE_DOCUMENT_ID, STYLE_ID
5510: INTO x_base_doc_number, x_doc_sub_type, x_org_id, l_src_doc_id, x_style_id
5511: FROM po_headers_all
5512: WHERE po_header_id = p_po_header_id;
5513:
5514: IF l_src_doc_id IS NOT NULL
5515: THEN

Line 5519: FROM po_headers_all

5515: THEN
5516: BEGIN
5517: SELECT CLM_DOCUMENT_NUMBER
5518: INTO x_source_doc_number
5519: FROM po_headers_all
5520: WHERE po_header_id = l_src_doc_id;
5521:
5522: EXCEPTION
5523: WHEN No_Data_Found THEN

Line 5565: ' FROM PO_HEADERS_ALL_EXT_B '||

5561:
5562: l_where_cls := SubStr(l_where_cls,1, Length(l_where_cls)-1);
5563:
5564: l_query := ' SELECT Max(To_Number(C_EXT_ATTR7)) '||
5565: ' FROM PO_HEADERS_ALL_EXT_B '||
5566: ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
5567: ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
5568: ' and C_EXT_ATTR7 not like ''%X%'' ';
5569: