CST_XLA_UNREF_RTN_SOURCES_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
UNREF_RETURN_SUPPLIER_ID UNREF_RETURN_SUPPLIER_SITE UNREF_RETURN_SUPPLIER_TYPE SUPPLIER_RETURN_HEADER_ID

Query

SQL_Statement
SELECT srh.vendor_id unref_return_supplier_id, srh.vendor_site_id unref_return_supplier_site, poz.vendor_type_lookup_code unref_return_supplier_type, srh.supplier_return_header_id supplier_return_header_id FROM rcv_supplier_return_headers srh, poz_suppliers poz where srh.vendor_id = poz.vendor_id