View: GMS_LOC_CONTACTS_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_LOC_CONTACTS_V

View Text

SELECT AWD.AWARD_ID
, CONT.CUST_ACCOUNT_ROLE_ID
, L.MEANING
, SUBSTRB(PARTY.PERSON_FIRST_NAME
, 1
, 40)
, SUBSTRB(PARTY.PERSON_LAST_NAME
, 1
, 50)
, CONT.STATUS
, ORG_CONT.JOB_TITLE
, ORG_CONT.MAIL_STOP
, CONT.ORIG_SYSTEM_REFERENCE
, SITE.CUST_ACCT_SITE_ID
, CON.CUSTOMER_ID
, CON.USAGE_CODE
, L1.MEANING
, CON.PRIMARY_FLAG
, CON.LAST_UPDATE_DATE
, CON.LAST_UPDATED_BY
, CON.CREATION_DATE
, CON.CREATED_BY
, CON.LAST_UPDATE_LOGIN
, CON.ROWID
FROM GMS_AWARDS AWD
, GMS_AWARDS_CONTACTS CON
, HZ_CUST_ACCOUNT_ROLES CONT
, HZ_PARTIES PARTY
, HZ_ORG_CONTACTS ORG_CONT
, HZ_CUST_ACCT_SITES_ALL SITE
, HZ_RELATIONSHIPS REL
, AR_LOOKUPS L
, AR_LOOKUPS L1
WHERE CONT.ROLE_TYPE = L.LOOKUP_CODE(+) AND L.LOOKUP_TYPE(+) = 'CONTACT_TITLE' AND CON.AWARD_ID = AWD.AWARD_ID AND L1.LOOKUP_TYPE(+) = 'SITE_USE_CODE' AND L1.LOOKUP_CODE(+) = CON.USAGE_CODE AND CON.CONTACT_ID = CONT.CUST_ACCOUNT_ROLE_ID AND AWD.BILL_TO_CUSTOMER_ID = CONT.CUST_ACCOUNT_ID AND CONT.STATUS = 'A' AND CONT.PARTY_ID = REL.PARTY_ID AND REL.SUBJECT_ID = PARTY.PARTY_ID AND PARTY.PARTY_TYPE = 'PERSON' AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND CONT.ROLE_TYPE ='CONTACT' AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID AND SITE.CUST_ACCT_SITE_ID = CONT.CUST_ACCT_SITE_ID

Columns