868: SELECT displayed_field
869: , lookup_code
870: INTO l_final_destination_type_dsp
871: , l_final_destination_type_code
872: FROM po_lookup_codes
873: WHERE lookup_code = 'INVENTORY'
874: AND lookup_type = 'RCV DESTINATION TYPE';
875: END IF;
876:
1282: IF (l_is_expense = 'Y') THEN
1283:
1284: SELECT lookup_code
1285: INTO l_tmp_destination_code
1286: FROM po_lookup_codes
1287: WHERE lookup_code = 'EXPENSE'
1288: AND lookup_type = 'RCV DESTINATION TYPE';
1289:
1290: ELSE
1290: ELSE
1291:
1292: SELECT lookup_code
1293: INTO l_tmp_destination_code
1294: FROM po_lookup_codes
1295: WHERE lookup_code = 'INVENTORY'
1296: AND lookup_type = 'RCV DESTINATION TYPE';
1297:
1298: END IF;