FND Design Data [Home] [Help]

View: ASO_PVT_PARTY_RLTN_V

Product: ASO - Order Capture
Description:
Implementation/DBA Data: ViewAPPS.ASO_PVT_PARTY_RLTN_V
View Text

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)

Columns

Name
PARTY_RELATIONSHIP_ID
SUBJECT_ID
OBJECT_ID
PARTY_ID