APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_LOOKUP_CODES

Line 603: FROM po_lookup_codes

599: p_dest_type_code_tbl(i)
600: FROM DUAL
601: WHERE p_dest_type_code_tbl(i) IS NOT NULL
602: AND NOT EXISTS(SELECT 1
603: FROM po_lookup_codes
604: WHERE lookup_type = 'DESTINATION TYPE'
605: AND ((nvl(l_item_status_tbl(i),'D') = 'D'
606: /* AND lookup_code = 'EXPENSE') commented and added below 7644072*/
607: AND lookup_code <> 'INVENTORY') -- bug 7644072