SQL Language (MOSC)

MOSC Banner

how to show all data

edited Feb 18, 2010 5:25AM in SQL Language (MOSC) 9 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center