DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_LOOKUP_CODES

Line 591: FROM po_lookup_codes

587: p_dest_type_code_tbl(i)
588: FROM DUAL
589: WHERE p_dest_type_code_tbl(i) IS NOT NULL
590: AND NOT EXISTS(SELECT 1
591: FROM po_lookup_codes
592: WHERE lookup_type = 'DESTINATION TYPE'
593: AND ((nvl(l_item_status_tbl(i),'D') = 'D'
594: /* AND lookup_code = 'EXPENSE') commented and added below 7644072*/
595: AND lookup_code <> 'INVENTORY') -- bug 7644072