MSC_AP_SUPPLIER_SITES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PARTNER_NAME VENDOR_SITE_CODE SR_TP_ID SR_TP_SITE_ID LOCATION_ID LOCATION_CODE PARTNER_TYPE PARTNER_SITE_ADDRESS INACTIVE_DATE DELETED_FLAG REQ_BU_FLAG PURCHASING_SITE_FLAG SOURCING_SITE_FLAG POZ_ROWID

Query

SQL_Statement

SELECT hp.party_name partner_name, pvsa.vendor_site_code vendor_site_code, pvsa.vendor_id sr_tp_id, pvsa.vendor_site_id sr_tp_site_id, pvsa.location_id location_id, to_char(rl.location_id) location_code, 1 partner_type, rl.address1 || rl.address2 || rl.address3 || rl.address4 partner_site_address, pvsa.inactive_date inactive_date, (case when ((pvv.end_date_active is not null and (pvv.end_date_active < sysdate)) or (pvsa.inactive_date is not null and pvsa.inactive_date< sysdate)) then 1 else 2 end ) deleted_flag, (case when NOT exists (select 1 from POZ_SITE_ASSIGNMENTS_ALL_M asg where asg.vendor_site_id = pvsa.vendor_site_id and nvl(asg.inactive_date,sysdate) >= sysdate ) then 1 else 2 end ) req_bu_flag , purchasing_site_flag, rfq_only_site_flag sourcing_site_flag, pvsa.rowid poz_rowid FROM POZ_SUPPLIER_SITES_ALL_M pvsa, poz_suppliers pvv, hz_parties hp, hz_locations rl WHERE pvsa.vendor_id = pvv.vendor_id AND hp.party_id = pvv.party_id AND pvsa.location_id =rl.location_id(+) AND (pvsa.purchasing_site_flag = 'Y' OR pvsa.rfq_only_site_flag = 'Y')