[Home] [Help]
| Product: | AHM - Hosting Manager(Obsolete) |
|---|---|
| Description: | This view gives the detail for the Party Billing Information like Billing Address, City, Country etc. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT FU.USER_ID
, FU.USER_NAME
, HP2.PERSON_FIRST_NAME
, HP2.PERSON_LAST_NAME
, HP2.PARTY_ID
, HP2.PARTY_NUMBER
, HP2.LAST_UPDATE_DATE PARTY_LAST_UPDATE
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.CITY
, HL.STATE
, HL.COUNTY
, HL.PROVINCE
, HL.POSTAL_CODE
, HL.COUNTRY
, HL.LOCATION_ID
, HL.LAST_UPDATE_DATE LOCATION_LAST_UPDATE
, HCP.PHONE_NUMBER
, HCP.CONTACT_POINT_ID
, HCP.OWNER_TABLE_ID
, HCP.LAST_UPDATE_DATE CONTACT_LAST_UPDATE
, ASA.PARTY_SECURITY_GROUP_ID
FROM HZ_PARTIES HP
, HZ_PARTIES HP2
, FND_USER FU
, HZ_RELATIONSHIPS HR
, HZ_RELATIONSHIPS HR2
, HZ_PARTY_SITES HPS
, HZ_PARTY_SITE_USES HPSU
, HZ_LOCATIONS HL
, HZ_CONTACT_POINTS HCP
, AHM_SLOT_ALLOCATIONS ASA
WHERE FU.CUSTOMER_ID = HR.PARTY_ID
AND HR.OBJECT_ID = HP.PARTY_ID
AND HR.OBJECT_ID = HR2.OBJECT_ID
AND HR.PARTY_ID != HR2.PARTY_ID
AND HR2.SUBJECT_ID = HP2.PARTY_ID
AND HP.PARTY_TYPE = 'ORGANIZATION'
AND HR.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
AND HR2.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
AND HP2.PARTY_ID = HPS.PARTY_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID
AND HPS.IDENTIFYING_ADDRESS_FLAG = 'Y'
AND HPS.PARTY_SITE_ID = HPSU.PARTY_SITE_ID
AND HPSU.SITE_USE_TYPE = 'BILL_TO'
AND HR2.PARTY_ID = HCP.OWNER_TABLE_ID
AND HCP.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND HCP.CONTACT_POINT_TYPE = 'PHONE'
AND HCP.PHONE_LINE_TYPE = 'GEN'
AND HP.PARTY_ID = ASA.PARTY_ID(+)