View: ASF_ORGANIZATION_RELAT_LOV_V

Product:	ASF - Sales Online
Description:	Contains related organization record
Implementation/DBA Data:	APPS.ASF_ORGANIZATION_RELAT_LOV_V

View Text

SELECT PAR.PARTY_NAME
, PAR.PARTY_NAME
, PAR.PARTY_ID
, PAR.PARTY_TYPE
, REL.STATUS
, REL.PARTY_ID
, REL.SUBJECT_ID
, REL.OBJECT_ID
, AR.MEANING
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES PAR
, AR_LOOKUPS AR
WHERE AR.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND AR.LOOKUP_CODE = REL.RELATIONSHIP_CODE
AND REL.OBJECT_ID = PAR.PARTY_ID
AND REL.STATUS IN ('A'
, 'I' )
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND PAR.STATUS IN ('A'
, 'I')

Columns