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 PON_AUCTION_HEADERS_EXT_B

Line 352: FROM pon_auction_headers_ext_b

348:
349: ELSIF p_caller = 'SOL' OR p_caller = 'SOL_AMD' THEN
350:
351: SELECT c_ext_attr40 INTO x_doc_number
352: FROM pon_auction_headers_ext_b
353: WHERE auction_header_id = p_doc_header_id
354: AND attr_group_id = l_attrb_grp_id;
355: END IF;
356:

Line 1103: ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||

1099: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
1100: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
1101: ' minus '||
1102: ' SELECT distinct plc.lookup_code FROM '||
1103: ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
1104: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
1105: ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
1106: ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
1107: ' and prheb.C_EXT_ATTR2 = '||x_fiscal_year ||

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 1259: from PON_AUCTION_HEADERS_EXT_B

1255:
1256: ELSE
1257:
1258: select count(*) INTO l_cnt
1259: from PON_AUCTION_HEADERS_EXT_B
1260: WHERE C_EXT_ATTR40 = x_document_number
1261: AND auction_header_id <> x_auction_header_id;
1262:
1263: IF l_cnt > 0 THEN

Line 1357: ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||

1353: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
1354: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
1355: ' minus '||
1356: ' SELECT distinct plc.lookup_code FROM '||
1357: ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
1358: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
1359: ' and prheb.C_EXT_ATTR9 = plc.displayed_field ' ||
1360: ' and prheb.C_EXT_ATTR1 = '''||x_prefix ||''''||
1361: ' and prheb.C_EXT_ATTR2 = '||x_fiscal_year ||

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 2107: ' FROM PON_AUCTION_HEADERS_EXT_B '||

2103:
2104: l_where_cls := SubStr(l_where_cls,1, Length(l_where_cls)-1);
2105:
2106: l_query := ' SELECT Max(To_Number(C_EXT_ATTR2)) '||
2107: ' FROM PON_AUCTION_HEADERS_EXT_B '||
2108: ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
2109: ' and ATTR_GROUP_ID in ('||l_where_cls||')';
2110:
2111: BEGIN

Line 2167: from PON_AUCTION_HEADERS_EXT_B

2163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2164: END IF;
2165:
2166: select count(*) INTO l_cnt
2167: from PON_AUCTION_HEADERS_EXT_B
2168: WHERE C_EXT_ATTR40 = x_document_number
2169: AND AUCTION_HEADER_ID <> p_auction_header_id;
2170:
2171: IF l_cnt > 0 THEN

Line 2357: ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||

2353: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
2354: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
2355: ' minus '||
2356: ' SELECT distinct plc.lookup_code FROM '||
2357: ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
2358: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
2359: ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
2360: ' and prheb.C_EXT_ATTR1 = '''||x_dodaac ||''''||
2361: ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||

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 2442: ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||

2438: x_max_value||''' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'')' ||
2439: ' and lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'' '||
2440: ' minus '||
2441: ' SELECT distinct plc.lookup_code FROM '||
2442: ' PON_AUCTION_HEADERS_EXT_B prheb, po_lookup_codes plc ' ||
2443: ' WHERE plc.lookup_type=''PO_CLM_SERIAL_NUM_CONSTANTS'''||
2444: ' and prheb.C_EXT_ATTR7 = plc.displayed_field ' ||
2445: ' and prheb.C_EXT_ATTR1 = '''||x_dodaac ||''''||
2446: ' and prheb.C_EXT_ATTR2 = '''||x_fiscal_year ||''''||

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 2632: from PON_AUCTION_HEADERS_EXT_B

2628: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data);
2629: END IF;
2630:
2631: select count(*) INTO l_cnt
2632: from PON_AUCTION_HEADERS_EXT_B
2633: WHERE C_EXT_ATTR40 = x_document_number
2634: AND auction_header_id <> x_auction_header_id;
2635:
2636: IF l_cnt > 0 THEN

Line 4142: ' FROM PON_AUCTION_HEADERS_EXT_B '||

4138:
4139: l_where_cls := SubStr(l_where_cls,1, Length(l_where_cls)-1);
4140:
4141: l_query := ' SELECT Max(To_Number(C_EXT_ATTR7)) '||
4142: ' FROM PON_AUCTION_HEADERS_EXT_B '||
4143: ' where C_EXT_ATTR1 ='''||x_base_doc_number||''' ' ||
4144: ' and C_EXT_ATTR2 ='''||x_control_char||''' '||
4145: ' and ATTR_GROUP_ID in ('||l_where_cls||') '||
4146: ' and C_EXT_ATTR7 not like ''%X%'' ';

Line 4211: from PON_AUCTION_HEADERS_EXT_B

4207: END IF;
4208:
4209: IF x_serial_number IS NOT NULL AND Upper(x_serial_number) <> 'XXXX' THEN
4210: select count(*) INTO l_cnt
4211: from PON_AUCTION_HEADERS_EXT_B
4212: WHERE C_EXT_ATTR40 = x_document_number
4213: AND AUCTION_HEADER_ID <> p_auction_header_id;
4214:
4215: IF l_cnt > 0 THEN