VIEW: APPS.ASF_ORGANIZATION_RELAT_LOV_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')