VIEW: APPS.ASO_PVT_PARTY_RLTN_V

Source

View Text - Preformatted

SELECT RELATIONSHIP_ID, SUBJECT_ID, OBJECT_ID, PARTY_ID FROM HZ_RELATIONSHIPS WHERE STATUS = 'A' AND trunc(START_DATE) <= trunc(sysdate) AND trunc(nvl(END_DATE, sysdate)) >= trunc(sysdate)

View Text - HTML Formatted

SELECT RELATIONSHIP_ID
, SUBJECT_ID
, OBJECT_ID
, PARTY_ID
FROM HZ_RELATIONSHIPS
WHERE STATUS = 'A'
AND TRUNC(START_DATE) <= TRUNC(SYSDATE)
AND TRUNC(NVL(END_DATE
, SYSDATE)) >= TRUNC(SYSDATE)