View: AST_LM_CKEY_TAX_EREF_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_LM_CKEY_TAX_EREF_V

View Text

SELECT PARTY.PARTY_ID
, 0 RELATIONSHIP_ID
, NULL RELATIONSHIP_TYPE
, 0
, PARTY.PARTY_NAME
, ALK1.MEANING PARTY_TYPE
, ALK1.LOOKUP_CODE PARTY_TYPE_CODE
, 0 PERSON_ID
, NULL JOB_TITLE
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.PROVINCE
, PARTY.POSTAL_CODE
, FTT.TERRITORY_SHORT_NAME
, CPT.PHONE_COUNTRY_CODE
, CPT.PHONE_AREA_CODE
, CPT.PHONE_NUMBER
, CPT.PHONE_EXTENSION
, PARTY.EMAIL_ADDRESS
, PARTY.JGZZ_FISCAL_CODE
, PARTY.ORIG_SYSTEM_REFERENCE
, NULL
, NULL
, ALK.MEANING STATUS
, PARTY.STATUS STATUS_CODE
FROM HZ_PARTIES PARTY
, HZ_CONTACT_POINTS CPT
, AR_LOOKUPS ALK1
, AR_LOOKUPS ALK
, FND_TERRITORIES_TL FTT
WHERE PARTY.PARTY_ID=CPT.OWNER_TABLE_ID (+)
AND PARTY.PARTY_TYPE IN ('ORGANIZATION'
, 'PERSON')
AND ALK1.LOOKUP_TYPE (+) ='PARTY_TYPE'
AND ALK1.LOOKUP_CODE (+) = PARTY.PARTY_TYPE
AND ALK1.ENABLED_FLAG (+) = 'Y'
AND ALK.LOOKUP_TYPE (+) ='CODE_STATUS'
AND ALK.LOOKUP_CODE (+) = PARTY.STATUS
AND ALK.ENABLED_FLAG (+) = 'Y'
AND CPT.PRIMARY_FLAG(+) ='Y'
AND CPT.STATUS(+) ='A'
AND CPT.CONTACT_POINT_TYPE(+) ='PHONE'
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+) UNION SELECT PARTY.PARTY_ID
, HZR.PARTY_ID RELATIONSHIP_ID
, NULL RELATIONSHIP_TYPE
, 0
, PARTY.PARTY_NAME
, ALK1.MEANING PARTY_TYPE
, ALK1.LOOKUP_CODE PARTY_TYPE_CODE
, HZR.OBJECT_ID PERSON_ID
, HCT.JOB_TITLE
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.PROVINCE
, PARTY.POSTAL_CODE
, FTT.TERRITORY_SHORT_NAME
, CPT.PHONE_COUNTRY_CODE
, CPT.PHONE_AREA_CODE
, CPT.PHONE_NUMBER
, CPT.PHONE_EXTENSION
, PARTY.EMAIL_ADDRESS
, PARTY.JGZZ_FISCAL_CODE
, PARTY.ORIG_SYSTEM_REFERENCE
, NULL
, NULL
, ALK.MEANING STATUS
, PARTY.STATUS STATUS_CODE
FROM HZ_PARTIES PARTY
, HZ_CONTACT_POINTS CPT
, AR_LOOKUPS ALK1
, AR_LOOKUPS ALK
, FND_TERRITORIES_TL FTT
, HZ_ORG_CONTACTS HCT
, HZ_RELATIONSHIPS HZR
WHERE PARTY.PARTY_ID=CPT.OWNER_TABLE_ID (+)
AND PARTY.PARTY_TYPE='PARTY_RELATIONSHIP'
AND ALK1.LOOKUP_TYPE (+) ='PARTY_TYPE'
AND ALK1.LOOKUP_CODE (+)= PARTY.PARTY_TYPE
AND ALK1.ENABLED_FLAG (+)= 'Y'
AND ALK.LOOKUP_TYPE (+)='CODE_STATUS'
AND ALK.LOOKUP_CODE (+)= PARTY.STATUS
AND ALK.ENABLED_FLAG (+)= 'Y'
AND CPT.PRIMARY_FLAG (+)='Y'
AND CPT.STATUS (+)='A'
AND CPT.CONTACT_POINT_TYPE (+)='PHONE'
AND PARTY.PARTY_ID=HZR.PARTY_ID
AND HCT.PARTY_RELATIONSHIP_ID (+)=HZR.RELATIONSHIP_ID
AND HZR.DIRECTIONAL_FLAG='F'
AND HZR.STATUS(+)='A'
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND FTT.SOURCE_LANG(+) = USERENV('LANG')
AND PARTY.COUNTRY = FTT.TERRITORY_CODE(+)

Columns