1. Tables and Views for Procurement
  2. POZ_SUPP_ACCESS_SUPPLIERS_V

POZ_SUPP_ACCESS_SUPPLIERS_V

Details

  • Schema: FUSION

  • Object owner: POZ

  • Object type: VIEW

Columns

Name

VENDOR_ID

PARTY_ID

SUPPLIER_NAME

SEGMENT1

END_DATE_ACTIVE

ENABLED_FLAG

Query

SQL_Statement

SELECT s.vendor_id,

s.party_id,

p.party_name supplier_name,

s.segment1,

s.end_date_active,

s.enabled_flag

FROM poz_suppliers s,

hz_parties p

WHERE s.party_id = p.party_id

AND (s.enabled_flag = 'Y'

AND (s.end_date_active > SYSDATE

OR s.end_date_active IS NULL))

AND s.vendor_id IN

(SELECT dataaccess.access_value

FROM POS_USER_ACCESS_VALUES dataaccess

WHERE dataaccess.access_code = 'SUPPLIER'

AND dataaccess.PER_PARTY_ID = HRC_SESSION_UTIL.get_user_partyid)