VIEW: APPS.POS_PS_MERGE_V

Source

View Text - Preformatted

SELECT ps.classification_id classification_id, vendor.party_id party_id, vendor.vendor_id vendor_id, vendor.vendor_name vendor_name from pos_sup_products_services ps, ap_suppliers vendor WHERE vendor.vendor_id = ps.vendor_id

View Text - HTML Formatted

SELECT PS.CLASSIFICATION_ID CLASSIFICATION_ID
, VENDOR.PARTY_ID PARTY_ID
, VENDOR.VENDOR_ID VENDOR_ID
, VENDOR.VENDOR_NAME VENDOR_NAME
FROM POS_SUP_PRODUCTS_SERVICES PS
, AP_SUPPLIERS VENDOR
WHERE VENDOR.VENDOR_ID = PS.VENDOR_ID