POZ_SUPPLIERS_V

Details

• Schema: FUSION

• Object owner: POZ

• Object type: VIEW

Columns

Name

VENDOR_NAME VENDOR_ID OBJECT_VERSION_NUMBER SEGMENT1 PARTY_ID ENABLED_FLAG SUMMARY_FLAG VENDOR_TYPE_LOOKUP_CODE VENDOR_NAME_ALT DUNS_NUMBER_C CUSTOMER_NUM ONE_TIME_FLAG PARENT_PARTY_ID PARENT_VENDOR_ID MIN_ORDER_AMOUNT SET_OF_BOOKS_ID TYPE_1099 WITHHOLDING_STATUS_LOOKUP_CODE WITHHOLDING_START_DATE ORGANIZATION_TYPE_LOOKUP_CODE START_DATE_ACTIVE END_DATE_ACTIVE MINORITY_GROUP_LOOKUP_CODE WOMEN_OWNED_FLAG SMALL_BUSINESS_FLAG STANDARD_INDUSTRY_CLASS TAX_VERIFICATION_DATE NAME_CONTROL STATE_REPORTABLE_FLAG FEDERAL_REPORTABLE_FLAG TAX_REPORTING_NAME ALLOW_AWT_FLAG AWT_GROUP_ID BANK_CHARGE_BEARER NI_NUMBER SUPPLIER_LOCKED_FLAG REBUILD_INDEX LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_CATEGORY CORPORATE_WEBSITE BUSINESS_RELATIONSHIP SPEND_AUTH_JUSTIFICATION SPEND_AUTH_REVIEW_STATUS DATAFOX_COMPANY_ID DF_SCORE ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE10 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP10 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP6 ATTRIBUTE_TIMESTAMP7 ATTRIBUTE_TIMESTAMP8 ATTRIBUTE_TIMESTAMP9 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE10 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_DATE6 GLOBAL_ATTRIBUTE_DATE7 GLOBAL_ATTRIBUTE_DATE8 GLOBAL_ATTRIBUTE_DATE9 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER10 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_NUMBER6 GLOBAL_ATTRIBUTE_NUMBER7 GLOBAL_ATTRIBUTE_NUMBER8 GLOBAL_ATTRIBUTE_NUMBER9 GLOBAL_ATTRIBUTE_TIMESTAMP1 GLOBAL_ATTRIBUTE_TIMESTAMP10 GLOBAL_ATTRIBUTE_TIMESTAMP2 GLOBAL_ATTRIBUTE_TIMESTAMP3 GLOBAL_ATTRIBUTE_TIMESTAMP4 GLOBAL_ATTRIBUTE_TIMESTAMP5 GLOBAL_ATTRIBUTE_TIMESTAMP6 GLOBAL_ATTRIBUTE_TIMESTAMP7 GLOBAL_ATTRIBUTE_TIMESTAMP8 GLOBAL_ATTRIBUTE_TIMESTAMP9

Query

SQL_Statement

SELECT tca_party.party_name VENDOR_NAME, poz_vendor.VENDOR_ID, poz_vendor.OBJECT_VERSION_NUMBER, poz_vendor.SEGMENT1, poz_vendor.PARTY_ID, poz_vendor.ENABLED_FLAG, poz_vendor.SUMMARY_FLAG, poz_vendor.VENDOR_TYPE_LOOKUP_CODE, tca_additional_names.PARTY_NAME AS VENDOR_NAME_ALT, tca_party.duns_number_c DUNS_NUMBER_C, poz_vendor.CUSTOMER_NUM, poz_vendor.ONE_TIME_FLAG, poz_vendor.PARENT_PARTY_ID, poz_vendor.PARENT_VENDOR_ID, poz_vendor.MIN_ORDER_AMOUNT, poz_vendor.SET_OF_BOOKS_ID, poz_vendor.TYPE_1099, poz_vendor.WITHHOLDING_STATUS_LOOKUP_CODE, poz_vendor.WITHHOLDING_START_DATE, poz_vendor.ORGANIZATION_TYPE_LOOKUP_CODE, poz_vendor.START_DATE_ACTIVE, poz_vendor.END_DATE_ACTIVE, poz_vendor.MINORITY_GROUP_LOOKUP_CODE, poz_vendor.WOMEN_OWNED_FLAG, poz_vendor.SMALL_BUSINESS_FLAG, poz_vendor.STANDARD_INDUSTRY_CLASS, poz_vendor.TAX_VERIFICATION_DATE, poz_vendor.NAME_CONTROL, poz_vendor.STATE_REPORTABLE_FLAG, poz_vendor.FEDERAL_REPORTABLE_FLAG, poz_vendor.TAX_REPORTING_NAME, poz_vendor.ALLOW_AWT_FLAG, poz_vendor.AWT_GROUP_ID, poz_vendor.BANK_CHARGE_BEARER, poz_vendor.NI_NUMBER, poz_vendor.SUPPLIER_LOCKED_FLAG, poz_vendor.REBUILD_INDEX, poz_vendor.LAST_UPDATE_DATE, poz_vendor.LAST_UPDATED_BY, poz_vendor.LAST_UPDATE_LOGIN, poz_vendor.CREATION_DATE, poz_vendor.CREATED_BY, poz_vendor.REQUEST_ID, poz_vendor.PROGRAM_APPLICATION_ID, poz_vendor.PROGRAM_ID, poz_vendor.PROGRAM_UPDATE_DATE, poz_vendor.ATTRIBUTE_CATEGORY, poz_vendor.ATTRIBUTE1, poz_vendor.ATTRIBUTE2, poz_vendor.ATTRIBUTE3, poz_vendor.ATTRIBUTE4, poz_vendor.ATTRIBUTE5, poz_vendor.ATTRIBUTE6, poz_vendor.ATTRIBUTE7, poz_vendor.ATTRIBUTE8, poz_vendor.ATTRIBUTE9, poz_vendor.ATTRIBUTE10, poz_vendor.ATTRIBUTE11, poz_vendor.ATTRIBUTE12, poz_vendor.ATTRIBUTE13, poz_vendor.ATTRIBUTE14, poz_vendor.ATTRIBUTE15, poz_vendor.GLOBAL_ATTRIBUTE1, poz_vendor.GLOBAL_ATTRIBUTE2, poz_vendor.GLOBAL_ATTRIBUTE3, poz_vendor.GLOBAL_ATTRIBUTE4, poz_vendor.GLOBAL_ATTRIBUTE5, poz_vendor.GLOBAL_ATTRIBUTE6, poz_vendor.GLOBAL_ATTRIBUTE7, poz_vendor.GLOBAL_ATTRIBUTE8, poz_vendor.GLOBAL_ATTRIBUTE9, poz_vendor.GLOBAL_ATTRIBUTE10, poz_vendor.GLOBAL_ATTRIBUTE11, poz_vendor.GLOBAL_ATTRIBUTE12, poz_vendor.GLOBAL_ATTRIBUTE13, poz_vendor.GLOBAL_ATTRIBUTE14, poz_vendor.GLOBAL_ATTRIBUTE15, poz_vendor.GLOBAL_ATTRIBUTE16, poz_vendor.GLOBAL_ATTRIBUTE17, poz_vendor.GLOBAL_ATTRIBUTE18, poz_vendor.GLOBAL_ATTRIBUTE19, poz_vendor.GLOBAL_ATTRIBUTE20, poz_vendor.GLOBAL_ATTRIBUTE_CATEGORY, poz_vendor.CORPORATE_WEBSITE, poz_vendor.BUSINESS_RELATIONSHIP, poz_vendor.SPEND_AUTH_JUSTIFICATION, poz_vendor.SPEND_AUTH_REVIEW_STATUS, poz_vendor.DATAFOX_COMPANY_ID, poz_vendor.DF_SCORE , poz_vendor.ATTRIBUTE16, poz_vendor.ATTRIBUTE17, poz_vendor.ATTRIBUTE18, poz_vendor.ATTRIBUTE19, poz_vendor.ATTRIBUTE20, poz_vendor.ATTRIBUTE_DATE1, poz_vendor.ATTRIBUTE_DATE10, poz_vendor.ATTRIBUTE_DATE2, poz_vendor.ATTRIBUTE_DATE3, poz_vendor.ATTRIBUTE_DATE4, poz_vendor.ATTRIBUTE_DATE5, poz_vendor.ATTRIBUTE_DATE6, poz_vendor.ATTRIBUTE_DATE7, poz_vendor.ATTRIBUTE_DATE8, poz_vendor.ATTRIBUTE_DATE9, poz_vendor.ATTRIBUTE_NUMBER1, poz_vendor.ATTRIBUTE_NUMBER10, poz_vendor.ATTRIBUTE_NUMBER2, poz_vendor.ATTRIBUTE_NUMBER3, poz_vendor.ATTRIBUTE_NUMBER4, poz_vendor.ATTRIBUTE_NUMBER5, poz_vendor.ATTRIBUTE_NUMBER6, poz_vendor.ATTRIBUTE_NUMBER7, poz_vendor.ATTRIBUTE_NUMBER8, poz_vendor.ATTRIBUTE_NUMBER9, poz_vendor.ATTRIBUTE_TIMESTAMP1, poz_vendor.ATTRIBUTE_TIMESTAMP10, poz_vendor.ATTRIBUTE_TIMESTAMP2, poz_vendor.ATTRIBUTE_TIMESTAMP3, poz_vendor.ATTRIBUTE_TIMESTAMP4, poz_vendor.ATTRIBUTE_TIMESTAMP5, poz_vendor.ATTRIBUTE_TIMESTAMP6, poz_vendor.ATTRIBUTE_TIMESTAMP7, poz_vendor.ATTRIBUTE_TIMESTAMP8, poz_vendor.ATTRIBUTE_TIMESTAMP9, poz_vendor.GLOBAL_ATTRIBUTE_DATE1, poz_vendor.GLOBAL_ATTRIBUTE_DATE10, poz_vendor.GLOBAL_ATTRIBUTE_DATE2, poz_vendor.GLOBAL_ATTRIBUTE_DATE3, poz_vendor.GLOBAL_ATTRIBUTE_DATE4, poz_vendor.GLOBAL_ATTRIBUTE_DATE5, poz_vendor.GLOBAL_ATTRIBUTE_DATE6, poz_vendor.GLOBAL_ATTRIBUTE_DATE7, poz_vendor.GLOBAL_ATTRIBUTE_DATE8, poz_vendor.GLOBAL_ATTRIBUTE_DATE9, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER1, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER10, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER2, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER3, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER4, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER5, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER6, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER7, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER8, poz_vendor.GLOBAL_ATTRIBUTE_NUMBER9, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP1, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP10, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP2, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP3, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP4, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP5, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP6, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP7, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP8, poz_vendor.GLOBAL_ATTRIBUTE_TIMESTAMP9 FROM POZ_SUPPLIERS poz_vendor, HZ_PARTIES tca_party, HZ_ADDTNL_PARTY_NAMES tca_additional_names WHERE tca_party.party_id = poz_vendor.party_id AND tca_party.party_id = tca_additional_names.party_id(+) AND tca_additional_names.party_name_type(+) = 'PHONETIC' AND tca_additional_names.preferred_flag(+) = 'Y' AND tca_additional_names.STATUS_FLAG(+) = 'A'