POZ_SUPP_ACCESS_SITES

Details

Schema: FUSION
Object owner: POZ
Object type: VIEW

Columns

Name
VENDOR_SITE_ID VENDOR_SITE_CODE PRC_BU_ID INACTIVE_DATE PARTY_SITE_ID PARTY_SITE_NAME VENDOR_ID PARTY_ID SUPPLIER_NAME SEGMENT1 END_DATE_ACTIVE ENABLED_FLAG

Name

VENDOR_SITE_ID

VENDOR_SITE_CODE

PRC_BU_ID

INACTIVE_DATE

PARTY_SITE_ID

PARTY_SITE_NAME

VENDOR_ID

PARTY_ID

SUPPLIER_NAME

SEGMENT1

END_DATE_ACTIVE

ENABLED_FLAG

Query

SQL_Statement
SELECT st.vendor_site_id, st.vendor_site_code, st.prc_bu_id, st.inactive_date, st.party_site_id, ps.party_site_name, s.vendor_id, s.party_id, p.party_name supplier_name, s.segment1, s.end_date_active, s.enabled_flag FROM poz_suppliers s, poz_supplier_sites_all_m st, hz_parties p, hz_party_sites ps WHERE s.vendor_id = st.vendor_id AND s.party_id = p.party_id AND (st.inactive_date IS NULL OR st.inactive_date > SYSDATE) AND (s.enabled_flag = 'Y' AND (s.end_date_active > SYSDATE OR s.end_date_active IS NULL)) AND st.party_site_id = ps.party_site_id AND st.vendor_site_id IN (SELECT dataaccess.access_value FROM poz_contact_attributes lvl, POS_USER_ACCESS_VALUES dataaccess WHERE lvl.access_level = 'SUPPLIER_SITE' AND lvl.per_party_id = dataaccess.PER_PARTY_ID AND dataaccess.access_code = 'SUPPLIER_SITE' AND lvl.PER_PARTY_ID = HRC_SESSION_UTIL.get_user_partyid UNION ALL SELECT site.vendor_site_id FROM poz_contact_attributes lvl, POS_USER_ACCESS_VALUES dataaccess, POZ_SUPPLIER_SITES_ALL_M SITE WHERE lvl.access_level = 'SUPPLIER' AND lvl.per_party_id = dataaccess.PER_PARTY_ID AND dataaccess.access_code = 'SUPPLIER' AND dataaccess.access_value = site.vendor_id AND lvl.PER_PARTY_ID = HRC_SESSION_UTIL.get_user_partyid)

SQL_Statement

SELECT st.vendor_site_id,

st.vendor_site_code,

st.prc_bu_id,

st.inactive_date,

st.party_site_id,

ps.party_site_name,

s.vendor_id,

s.party_id,

p.party_name supplier_name,

s.segment1,

s.end_date_active,

s.enabled_flag

FROM poz_suppliers s,

poz_supplier_sites_all_m st,

hz_parties p,

hz_party_sites ps

WHERE s.vendor_id = st.vendor_id

AND s.party_id = p.party_id

AND (st.inactive_date IS NULL

OR st.inactive_date > SYSDATE)

AND (s.enabled_flag = 'Y'

AND (s.end_date_active > SYSDATE

OR s.end_date_active IS NULL))

AND st.party_site_id = ps.party_site_id

AND st.vendor_site_id IN

(SELECT dataaccess.access_value

FROM poz_contact_attributes lvl,

POS_USER_ACCESS_VALUES dataaccess

WHERE lvl.access_level = 'SUPPLIER_SITE'

AND lvl.per_party_id = dataaccess.PER_PARTY_ID

AND dataaccess.access_code = 'SUPPLIER_SITE'

AND lvl.PER_PARTY_ID = HRC_SESSION_UTIL.get_user_partyid

UNION ALL

SELECT site.vendor_site_id

FROM poz_contact_attributes lvl,

POS_USER_ACCESS_VALUES dataaccess,

POZ_SUPPLIER_SITES_ALL_M SITE

WHERE lvl.access_level = 'SUPPLIER'

AND lvl.per_party_id = dataaccess.PER_PARTY_ID

AND dataaccess.access_code = 'SUPPLIER'

AND dataaccess.access_value = site.vendor_id

AND lvl.PER_PARTY_ID = HRC_SESSION_UTIL.get_user_partyid)