View: AR_XML_INVOICE_TP_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_XML_INVOICE_TP_V

View Text

SELECT CUST_ACCT.CUST_ACCOUNT_ID
, SITE_USES.SITE_USE_ID
, ROLES.CUST_ACCOUNT_ROLE_ID
, PARTY.PARTY_NAME
, CUST_ACCT.ACCOUNT_NUMBER
, SITE_USES.LOCATION
, LOCATIONS.ADDRESS1
, LOCATIONS.ADDRESS2
, LOCATIONS.ADDRESS3
, LOCATIONS.ADDRESS4
, DECODE( CUST_ACCT_SITES.CUST_ACCT_SITE_ID
, NULL
, NULL
, ARH_ADDR_PKG.ARXTW_FORMAT_ADDRESS(LOCATIONS.ADDRESS_STYLE
, LOCATIONS.ADDRESS1
, LOCATIONS.ADDRESS2
, LOCATIONS.ADDRESS3
, LOCATIONS.ADDRESS4
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL)) ADDRESS
, LOCATIONS.CITY
, LOCATIONS.COUNTY
, LOCATIONS.STATE
, LOCATIONS.PROVINCE
, LOCATIONS.POSTAL_CODE
, FT.TERRITORY_SHORT_NAME
, DECODE( CUST_ACCT_SITES.CUST_ACCT_SITE_ID
, NULL
, NULL
, ARH_ADDR_PKG.ARXTW_FORMAT_ADDRESS(LOCATIONS.ADDRESS_STYLE
, LOCATIONS.ADDRESS1
, LOCATIONS.ADDRESS2
, LOCATIONS.ADDRESS3
, LOCATIONS.ADDRESS4
, LOCATIONS.CITY
, LOCATIONS.COUNTY
, LOCATIONS.STATE
, LOCATIONS.PROVINCE
, LOCATIONS.POSTAL_CODE
, FT.TERRITORY_SHORT_NAME)) COMPLETE_ADDRESS
, DECODE(SUBSTRB(CONTACT_PARTY.PERSON_LAST_NAME
, 1
, 50)
, NULL
, SUBSTRB(CONTACT_PARTY.PERSON_FIRST_NAME
, 1
, 40)
, SUBSTRB(CONTACT_PARTY.PERSON_LAST_NAME
, 1
, 50) ||'
, ' || SUBSTRB(CONTACT_PARTY.PERSON_FIRST_NAME
, 1
, 40)) NAME
, CONTACT_PARTY.EMAIL_ADDRESS
, CONTACT_PARTY.PRIMARY_PHONE_COUNTRY_CODE
, CONTACT_PARTY.PRIMARY_PHONE_AREA_CODE
, CONTACT_PARTY.PRIMARY_PHONE_NUMBER
, CONTACT_PARTY.PRIMARY_PHONE_EXTENSION
, PARTY.TAX_REFERENCE
, AR_XML_VIEW_FUNCTIONS.TP_FUNCTION1(PARTY_SITES.PARTY_SITE_ID) USER1
, AR_XML_VIEW_FUNCTIONS.TP_FUNCTION2(PARTY_SITES.PARTY_SITE_ID) USER2
, AR_XML_VIEW_FUNCTIONS.TP_FUNCTION3(PARTY_SITES.PARTY_SITE_ID) USER3
, AR_XML_VIEW_FUNCTIONS.TP_FUNCTION4(PARTY_SITES.PARTY_SITE_ID) USER4
, AR_XML_VIEW_FUNCTIONS.TP_FUNCTION5(PARTY_SITES.PARTY_SITE_ID) USER5
FROM HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES_ALL SITE_USES
, HZ_CUST_ACCT_SITES_ALL CUST_ACCT_SITES
, HZ_PARTY_SITES PARTY_SITES
, HZ_LOCATIONS LOCATIONS
, FND_TERRITORIES_VL FT
, HZ_CUST_ACCOUNT_ROLES ROLES
, HZ_RELATIONSHIPS REL
, HZ_PARTIES CONTACT_PARTY
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND SITE_USES.CUST_ACCT_SITE_ID = CUST_ACCT_SITES.CUST_ACCT_SITE_ID
AND CUST_ACCT_SITES.PARTY_SITE_ID = PARTY_SITES.PARTY_SITE_ID
AND LOCATIONS.LOCATION_ID = PARTY_SITES.LOCATION_ID
AND LOCATIONS.COUNTRY = FT.TERRITORY_CODE(+)
AND ROLES.ROLE_TYPE(+) = 'CONTACT'
AND ROLES.PARTY_ID = REL.PARTY_ID(+)
AND REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG(+) = 'F'
AND REL.SUBJECT_ID = CONTACT_PARTY.PARTY_ID(+)

Columns