VIEW: APPS.AST_LM_CKEY_TAX_EREF_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)