Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HZ_DQM_P_V |
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