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 FND_LOOKUP_VALUES

Line 609: FROM fnd_lookup_values

605:
606: BEGIN
607: SELECT to_number(lookup_code)
608: INTO min_code
609: FROM fnd_lookup_values
610: WHERE meaning = x_min_value
611: AND language = userenv ('LANG')
612: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
613:

Line 616: FROM fnd_lookup_values

612: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
613:
614: SELECT to_number(lookup_code)
615: INTO max_code
616: FROM fnd_lookup_values
617: WHERE meaning = x_max_value
618: AND language = userenv ('LANG')
619: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
620:

Line 622: ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||

618: AND language = userenv ('LANG')
619: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
620:
621: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
622: ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
623: ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
624: ' AND prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
625: ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
626: ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||

Line 636: FROM fnd_lookup_values

632: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
633:
634: SELECT meaning
635: INTO x_serial_number
636: FROM fnd_lookup_values
637: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
638: AND language = userenv ('LANG')
639: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
640: AND to_number(lookup_code) <= max_code; --

Line 889: FROM fnd_lookup_values

885: BEGIN
886:
887: SELECT to_number(lookup_code)
888: INTO min_code
889: FROM fnd_lookup_values
890: WHERE meaning = x_min_value
891: AND language = userenv ('LANG')
892: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
893:

Line 896: FROM fnd_lookup_values

892: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
893:
894: SELECT to_number(lookup_code)
895: INTO max_code
896: FROM fnd_lookup_values
897: WHERE meaning = x_max_value
898: AND language = userenv ('LANG')
899: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
900:

Line 902: ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||

898: AND language = userenv ('LANG')
899: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
900:
901: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
902: ' FROM PO_REQ_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
903: ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
904: ' AND prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||
905: ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
906: ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||

Line 916: FROM fnd_lookup_values

912: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
913:
914: SELECT meaning
915: INTO x_serial_number
916: FROM fnd_lookup_values
917: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
918: AND language = userenv ('LANG')
919: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
920: AND to_number(lookup_code) <= max_code; --

Line 1116: FROM fnd_lookup_values

1112: BEGIN
1113:
1114: SELECT to_number(lookup_code)
1115: INTO min_code
1116: FROM fnd_lookup_values
1117: WHERE meaning = x_min_value
1118: AND language = userenv ('LANG')
1119: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1120:

Line 1123: FROM fnd_lookup_values

1119: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1120:
1121: SELECT to_number(lookup_code)
1122: INTO max_code
1123: FROM fnd_lookup_values
1124: WHERE meaning = x_max_value
1125: AND language = userenv ('LANG')
1126: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1127:

Line 1129: ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||

1125: AND language = userenv ('LANG')
1126: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1127:
1128: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
1129: ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
1130: ' WHERE prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
1131: ' AND prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
1132: ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||
1133: ' AND flv.meaning = prheb.C_EXT_ATTR9 ' ||

Line 1143: FROM fnd_lookup_values

1139: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
1140:
1141: SELECT meaning
1142: INTO x_serial_number
1143: FROM fnd_lookup_values
1144: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
1145: AND language = userenv ('LANG')
1146: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
1147: AND to_number(lookup_code) <= max_code; --

Line 1370: FROM fnd_lookup_values

1366:
1367: BEGIN
1368: SELECT to_number(lookup_code)
1369: INTO min_code
1370: FROM fnd_lookup_values
1371: WHERE meaning = x_min_value
1372: AND language = userenv ('LANG')
1373: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1374:

Line 1377: FROM fnd_lookup_values

1373: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1374:
1375: SELECT to_number(lookup_code)
1376: INTO max_code
1377: FROM fnd_lookup_values
1378: WHERE meaning = x_max_value
1379: AND language = userenv ('LANG')
1380: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1381:

Line 1383: ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||

1379: AND language = userenv ('LANG')
1380: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1381:
1382: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
1383: ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
1384: ' WHERE prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
1385: ' AND prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
1386: ' AND prheb.C_EXT_ATTR2 = '||x_fiscal_year ||
1387: ' AND prheb.C_EXT_ATTR3 = '''||x_agency_identifier ||''''||

Line 1398: FROM fnd_lookup_values

1394: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
1395:
1396: SELECT meaning
1397: INTO x_serial_number
1398: FROM fnd_lookup_values
1399: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
1400: AND language = userenv ('LANG')
1401: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
1402: AND to_number(lookup_code) <= max_code; --

Line 1584: FROM fnd_lookup_values

1580:
1581: BEGIN
1582: SELECT to_number(lookup_code)
1583: INTO min_code
1584: FROM fnd_lookup_values
1585: WHERE meaning = x_min_value
1586: AND language = userenv ('LANG')
1587: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1588:

Line 1591: FROM fnd_lookup_values

1587: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1588:
1589: SELECT to_number(lookup_code)
1590: INTO max_code
1591: FROM fnd_lookup_values
1592: WHERE meaning = x_max_value
1593: AND language = userenv ('LANG')
1594: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1595:

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 1611: FROM fnd_lookup_values

1607: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
1608:
1609: SELECT meaning
1610: INTO x_serial_number
1611: FROM fnd_lookup_values
1612: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
1613: AND language = userenv ('LANG')
1614: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
1615: AND to_number(lookup_code) <= max_code; --

Line 1837: FROM fnd_lookup_values

1833:
1834: BEGIN
1835: SELECT to_number(lookup_code)
1836: INTO min_code
1837: FROM fnd_lookup_values
1838: WHERE meaning = x_min_value
1839: AND language = userenv ('LANG')
1840: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1841:

Line 1844: FROM fnd_lookup_values

1840: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1841:
1842: SELECT to_number(lookup_code)
1843: INTO max_code
1844: FROM fnd_lookup_values
1845: WHERE meaning = x_max_value
1846: AND language = userenv ('LANG')
1847: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
1848:

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 1864: FROM fnd_lookup_values

1860: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
1861:
1862: SELECT meaning
1863: INTO x_serial_number
1864: FROM fnd_lookup_values
1865: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
1866: AND language = userenv ('LANG')
1867: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
1868: AND to_number(lookup_code) <= max_code; --

Line 2369: FROM fnd_lookup_values

2365:
2366: BEGIN
2367: SELECT to_number(lookup_code)
2368: INTO min_code
2369: FROM fnd_lookup_values
2370: WHERE meaning = x_min_value
2371: AND language = userenv ('LANG')
2372: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2373:

Line 2376: FROM fnd_lookup_values

2372: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2373:
2374: SELECT to_number(lookup_code)
2375: INTO max_code
2376: FROM fnd_lookup_values
2377: WHERE meaning = x_max_value
2378: AND language = userenv ('LANG')
2379: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2380:

Line 2382: ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||

2378: AND language = userenv ('LANG')
2379: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2380:
2381: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
2382: ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
2383: ' WHERE prheb.C_EXT_ATTR1 = ''' || x_dodaac || '''' ||
2384: ' AND prheb.C_EXT_ATTR2 = ''' || x_fiscal_year || '''' ||
2385: ' AND prheb.C_EXT_ATTR3 = ''' || x_instrument_type || '''' ||
2386: ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||

Line 2396: FROM fnd_lookup_values

2392: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
2393:
2394: SELECT meaning
2395: INTO x_serial_number
2396: FROM fnd_lookup_values
2397: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
2398: AND language = userenv ('LANG')
2399: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
2400: AND to_number(lookup_code) <= max_code; --

Line 2454: FROM fnd_lookup_values

2450:
2451: BEGIN
2452: SELECT to_number(lookup_code)
2453: INTO min_code
2454: FROM fnd_lookup_values
2455: WHERE meaning = x_min_value
2456: AND language = userenv ('LANG')
2457: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2458:

Line 2461: FROM fnd_lookup_values

2457: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2458:
2459: SELECT to_number(lookup_code)
2460: INTO max_code
2461: FROM fnd_lookup_values
2462: WHERE meaning = x_max_value
2463: AND language = userenv ('LANG')
2464: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2465:

Line 2467: ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||

2463: AND language = userenv ('LANG')
2464: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2465:
2466: l_query := ' SELECT max(to_number(lookup_code)) + 1 ' ||
2467: ' FROM PON_AUCTION_HEADERS_EXT_B prheb, fnd_lookup_values flv ' ||
2468: ' WHERE prheb.C_EXT_ATTR1 = ''' || x_dodaac || '''' ||
2469: ' AND prheb.C_EXT_ATTR2 = ''' || x_fiscal_year || '''' ||
2470: ' AND prheb.C_EXT_ATTR3 = ''' || x_instrument_type || '''' ||
2471: ' AND flv.meaning = prheb.C_EXT_ATTR7 ' ||

Line 2481: FROM fnd_lookup_values

2477: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
2478:
2479: SELECT meaning
2480: INTO x_serial_number
2481: FROM fnd_lookup_values
2482: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
2483: AND language = userenv ('LANG')
2484: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
2485: AND to_number(lookup_code) <= max_code; --

Line 2923: FROM fnd_lookup_values

2919:
2920: BEGIN
2921: SELECT to_number(lookup_code)
2922: INTO min_code
2923: FROM fnd_lookup_values
2924: WHERE meaning = x_min_value
2925: AND language = userenv ('LANG')
2926: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2927:

Line 2930: FROM fnd_lookup_values

2926: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2927:
2928: SELECT to_number(lookup_code)
2929: INTO max_code
2930: FROM fnd_lookup_values
2931: WHERE meaning = x_max_value
2932: AND language = userenv ('LANG')
2933: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
2934:

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 2950: FROM fnd_lookup_values

2946: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
2947:
2948: SELECT meaning
2949: INTO x_serial_number
2950: FROM fnd_lookup_values
2951: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
2952: AND language = userenv ('LANG')
2953: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
2954: AND to_number(lookup_code) <= max_code; --

Line 3014: FROM fnd_lookup_values

3010:
3011: BEGIN
3012: SELECT to_number(lookup_code)
3013: INTO min_code
3014: FROM fnd_lookup_values
3015: WHERE meaning = x_min_value
3016: AND language = userenv ('LANG')
3017: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3018:

Line 3021: FROM fnd_lookup_values

3017: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3018:
3019: SELECT to_number(lookup_code)
3020: INTO max_code
3021: FROM fnd_lookup_values
3022: WHERE meaning = x_max_value
3023: AND language = userenv ('LANG')
3024: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3025:

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 3041: FROM fnd_lookup_values

3037: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
3038:
3039: SELECT meaning
3040: INTO x_serial_number
3041: FROM fnd_lookup_values
3042: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
3043: AND language = userenv ('LANG')
3044: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
3045: AND to_number(lookup_code) <= max_code; --

Line 3452: FROM fnd_lookup_values

3448:
3449: BEGIN
3450: SELECT to_number(lookup_code)
3451: INTO min_code
3452: FROM fnd_lookup_values
3453: WHERE meaning = x_min_value
3454: AND language = userenv ('LANG')
3455: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3456:

Line 3459: FROM fnd_lookup_values

3455: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3456:
3457: SELECT to_number(lookup_code)
3458: INTO max_code
3459: FROM fnd_lookup_values
3460: WHERE meaning = x_max_value
3461: AND language = userenv ('LANG')
3462: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3463:

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 3477: FROM fnd_lookup_values

3473: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
3474:
3475: SELECT meaning
3476: INTO x_serial_number
3477: FROM fnd_lookup_values
3478: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
3479: AND language = userenv ('LANG')
3480: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
3481: AND to_number(lookup_code) <= max_code; --

Line 3532: FROM fnd_lookup_values

3528:
3529: BEGIN
3530: SELECT to_number(lookup_code)
3531: INTO min_code
3532: FROM fnd_lookup_values
3533: WHERE meaning = x_min_value
3534: AND language = userenv ('LANG')
3535: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3536:

Line 3539: FROM fnd_lookup_values

3535: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3536:
3537: SELECT to_number(lookup_code)
3538: INTO max_code
3539: FROM fnd_lookup_values
3540: WHERE meaning = x_max_value
3541: AND language = userenv ('LANG')
3542: AND lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS';
3543:

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 3557: FROM fnd_lookup_values

3553: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
3554:
3555: SELECT meaning
3556: INTO x_serial_number
3557: FROM fnd_lookup_values
3558: WHERE lookup_type='PO_CLM_SERIAL_NUM_CONSTANTS'
3559: AND language = userenv ('LANG')
3560: AND to_number(lookup_code) = Nvl(l_lookup_code, min_code) --
3561: AND to_number(lookup_code) <= max_code; --

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 4397: FROM fnd_lookup_values

4393: EXECUTE IMMEDIATE l_query INTO l_lookup_code ;
4394:
4395: SELECT meaning
4396: INTO x_serial_number
4397: FROM fnd_lookup_values
4398: WHERE lookup_type = l_lookup_const
4399: AND language = userenv ('LANG')
4400: AND to_number(lookup_code) = Nvl(l_lookup_code, 1); --
4401: