VIEW: APPS.HZ_DQM_P_V

Source

View Text - Preformatted

SELECT p.party_id dqparty_id, h.meaning dqparty_type, p.party_name dqparty_name, p.party_number dqparty_number, p.jgzz_fiscal_code dqjgzz_fiscal_code, p.tax_reference dqtax_reference, p.duns_number_c dqduns_number_c, h1.meaning dqcategory_code, p.sic_code dqsic_code, p.status dqstatus, NVL(arpt_sql_func_util.get_lookup_meaning ('REGISTRY_STATUS',p.status),p.status) dqstatusm, p.address1 dqaddress1, p.address2 dqaddress2, p.address3 dqaddress3, p.address4 dqaddress4, p.city dqcity, p.postal_code dqpostal_code, p.county dqcounty, t.territory_short_name dqcountry, p.state dqstate, p.province dqprovince FROM hz_parties p, fnd_territories_vl t, ar_lookups h, ar_lookups h1 WHERE p.country = t.territory_code(+) AND NVL(p.status,'A') NOT IN ('M') AND h.lookup_type(+) = 'PARTY_TYPE' AND h.lookup_code(+) = p.party_type AND h1.lookup_type(+)= 'CUSTOMER_CATEGORY' AND h1.lookup_code(+)= p.category_code

View Text - HTML Formatted

SELECT P.PARTY_ID DQPARTY_ID
, H.MEANING DQPARTY_TYPE
, P.PARTY_NAME DQPARTY_NAME
, P.PARTY_NUMBER DQPARTY_NUMBER
, P.JGZZ_FISCAL_CODE DQJGZZ_FISCAL_CODE
, P.TAX_REFERENCE DQTAX_REFERENCE
, P.DUNS_NUMBER_C DQDUNS_NUMBER_C
, H1.MEANING DQCATEGORY_CODE
, P.SIC_CODE DQSIC_CODE
, P.STATUS DQSTATUS
, NVL(ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('REGISTRY_STATUS'
, P.STATUS)
, P.STATUS) DQSTATUSM
, P.ADDRESS1 DQADDRESS1
, P.ADDRESS2 DQADDRESS2
, P.ADDRESS3 DQADDRESS3
, P.ADDRESS4 DQADDRESS4
, P.CITY DQCITY
, P.POSTAL_CODE DQPOSTAL_CODE
, P.COUNTY DQCOUNTY
, T.TERRITORY_SHORT_NAME DQCOUNTRY
, P.STATE DQSTATE
, P.PROVINCE DQPROVINCE
FROM HZ_PARTIES P
, FND_TERRITORIES_VL T
, AR_LOOKUPS H
, AR_LOOKUPS H1
WHERE P.COUNTRY = T.TERRITORY_CODE(+)
AND NVL(P.STATUS
, 'A') NOT IN ('M')
AND H.LOOKUP_TYPE(+) = 'PARTY_TYPE'
AND H.LOOKUP_CODE(+) = P.PARTY_TYPE
AND H1.LOOKUP_TYPE(+)= 'CUSTOMER_CATEGORY'
AND H1.LOOKUP_CODE(+)= P.CATEGORY_CODE