Product: | ASO - Order Capture |
---|---|
Description: | It gives the information about Party Name,Party Type etc. |
Implementation/DBA Data: | APPS.ASO_I_ORG_CONTACTS_V |
SELECT OC.ORG_CONTACT_ID
, P.PARTY_NAME
, P.PARTY_NUMBER
, P.PARTY_TYPE
, P.PERSON_FIRST_NAME
, P.PERSON_MIDDLE_NAME
, P.PERSON_LAST_NAME
, LK.MEANING
, OC.JOB_TITLE
, OC.STATUS
, PR.OBJECT_ID
, OC.CONTACT_NUMBER
, PR.SUBJECT_ID
, ROLE.ROLE_TYPE
, PR.PARTY_ID
FROM HZ_ORG_CONTACTS OC
, HZ_PARTIES P
, HZ_PARTY_RELATIONSHIPS PR
, AR_LOOKUPS LK
, HZ_ORG_CONTACT_ROLES ROLE
WHERE OC.PARTY_RELATIONSHIP_ID = PR.PARTY_RELATIONSHIP_ID
AND PR.SUBJECT_ID = P.PARTY_ID
AND LK.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND LK.LOOKUP_CODE(+) = OC.TITLE
AND OC.ORG_CONTACT_ID = ROLE.ORG_CONTACT_ID(+)