select pv.vendor_name ,
decode(pbca.lookup_code, 'VETERAN_OWNED', 'Y', 'N') as veteran_owned
from PO_VENDORS pv, POS_BUS_CLASS_ATTR pbca
where pv.vendor_id = :1
and pbca.party_id (+) =
POS_VENDOR_UTIL_PKG.get_party_id_for_vendor(pv.vendor_id)
and pbca.lookup_code(+) = 'VETERAN_OWNED'
and pbca.status(+) ='A'
and pbca.class_status = 'APPROVED'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16793185/viewspace-697383/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
