JE_IT_EXEMPT_LETTERS_UI_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
LEGAL_ENTITY_ID LEGAL_ENTITY_NAME LEGAL_ENTITY_IDENT LEGAL_ENTITY_REG_NUM VENDOR_ID SUPPLIER_NAME SUPPLIER_ADDRESS SUPPLIER_NUMBER SUPPLIER_TAX_PAY_IDENT SUPPLIER_TAX_REG_NUM VENDOR_SITE_ID VENDOR_SITE_CODE

Query

SQL_Statement

SELECT xle.LEGAL_ENTITY_ID, xle.NAME LEGAL_ENTITY_NAME, xle.LEGAL_ENTITY_IDENTIFIER LEGAL_ENTITY_IDENT, xle.REGISTRATION_NUMBER LEGAL_ENTITY_REG_NUM, sup.VENDOR_ID, hzp.PARTY_NAME SUPPLIER_NAME, HZ_FORMAT_PUB.FORMAT_ADDRESS( hzl.LOCATION_ID, NULL, NULL, ', ') SUPPLIER_ADDRESS, sup.SEGMENT1 SUPPLIER_NUMBER, hzp.JGZZ_FISCAL_CODE SUPPLIER_TAX_PAY_IDENT, ptp.REP_REGISTRATION_NUMBER SUPPLIER_TAX_REG_NUM, sus.VENDOR_SITE_ID, sus.VENDOR_SITE_CODE FROM POZ_SUPPLIERS sup, POZ_SUPPLIER_SITES_ALL_M sus, HZ_PARTIES hzp, HZ_LOCATIONS hzl, XLE_FIRSTPARTY_INFORMATION_V xle, FUN_ALL_BUSINESS_UNITS_V fbu, ZX_PARTY_TAX_PROFILE ptp WHERE sup.VENDOR_ID = sus.VENDOR_ID AND sus.TAX_REPORTING_SITE_FLAG = 'Y' AND fbu.BU_ID = sus.PRC_BU_ID AND xle.LEGAL_ENTITY_ID = fbu.LEGAL_ENTITY_ID AND sup.PARTY_ID = hzp.PARTY_ID AND sus.LOCATION_ID = hzl.LOCATION_ID AND ptp.PARTY_ID = hzp.PARTY_ID AND ptp.PARTY_TYPE_CODE = 'THIRD_PARTY' AND ptp.SUPPLIER_FLAG = 'Y' AND EXISTS (SELECT 1 FROM JE_IT_YEAR_EX_LIMIT exl WHERE xle.LEGAL_ENTITY_ID = exl.LEGAL_ENTITY_ID)