how to show all data
I need to display the approved supplier to this item and it work but I need when No approved suppliers to this item display all data
select vendor_name, segment1 , decode (hold_status, 'Y', '*', '') on_hold, num_1099 taxpayer_id,
vat_registration_num tax_registration_num,vendor_id
vendor_name, segment1 , decode (hold_status, 'Y', '*', '') on_hold, num_1099 taxpayer_id,
vat_registration_num tax_registration_num,vendor_id
,vendor_id
from po_suppliers_val_v
po_suppliers_val_v
where vendor_id in(select vendor_id from PO_ASL_SUPPLIERS_V where item_id=:ITEM_ID)
order
0