View: PA_OBJECT_RELATIONSHIPS_V

View Text

SELECT POR.OBJECT_RELATIONSHIP_ID
, POR.OBJECT_TYPE_FROM
, DECODE(SUBSTRB(POR.OBJECT_TYPE_FROM
, 1
, 2)
, 'PA'
, FLV1.MEANING
, IPD_CHANGE_MGMT_UTIL.GETOBJECTCODENAME( POR.OBJECT_TYPE_FROM
, POR.OBJECT_ID_FROM1
, POR.OBJECT_ID_FROM2
, POR.OBJECT_ID_FROM3
, POR.OBJECT_ID_FROM4
, POR.OBJECT_ID_FROM5))
, PA_OBJECT_RELATIONSHIPS_UTILS.GETOBJECTNAME(POR.OBJECT_TYPE_FROM
, POR.OBJECT_ID_FROM1
, POR.OBJECT_ID_FROM2
, POR.OBJECT_ID_FROM3
, POR.OBJECT_ID_FROM4
, POR.OBJECT_ID_FROM5)
, PA_OBJECT_RELATIONSHIPS_UTILS.GETOBJECTNAMELINK(POR.OBJECT_TYPE_FROM
, POR.OBJECT_ID_FROM1
, POR.OBJECT_ID_FROM2
, POR.OBJECT_ID_FROM3
, POR.OBJECT_ID_FROM4
, POR.OBJECT_ID_FROM5)
, POR.OBJECT_ID_FROM1
, POR.OBJECT_ID_FROM2
, POR.OBJECT_ID_FROM3
, POR.OBJECT_ID_FROM4
, POR.OBJECT_ID_FROM5
, POR.OBJECT_TYPE_TO
, DECODE(SUBSTRB(POR.OBJECT_TYPE_TO
, 1
, 2)
, 'PA'
, FLV2.MEANING
, IPD_CHANGE_MGMT_UTIL.GETOBJECTCODENAME( POR.OBJECT_TYPE_TO
, POR.OBJECT_ID_TO1
, POR.OBJECT_ID_TO2
, POR.OBJECT_ID_TO3
, POR.OBJECT_ID_TO4
, POR.OBJECT_ID_TO5))
, PA_OBJECT_RELATIONSHIPS_UTILS.GETOBJECTNAME(POR.OBJECT_TYPE_TO
, POR.OBJECT_ID_TO1
, POR.OBJECT_ID_TO2
, POR.OBJECT_ID_TO3
, POR.OBJECT_ID_TO4
, POR.OBJECT_ID_TO5)
, PA_OBJECT_RELATIONSHIPS_UTILS.GETOBJECTNAMELINK(POR.OBJECT_TYPE_TO
, POR.OBJECT_ID_TO1
, POR.OBJECT_ID_TO2
, POR.OBJECT_ID_TO3
, POR.OBJECT_ID_TO4
, POR.OBJECT_ID_TO5)
, POR.OBJECT_ID_TO1
, POR.OBJECT_ID_TO2
, POR.OBJECT_ID_TO3
, POR.OBJECT_ID_TO4
, POR.OBJECT_ID_TO5
, POR.RELATIONSHIP_TYPE
, POR.RELATIONSHIP_SUBTYPE
, PA_OBJECT_RELATIONSHIPS_UTILS.GET_REL_SUBTYPE_MEANING(POR.RELATIONSHIP_SUBTYPE)
, NVL(POR.IMPORTED_LAG
, POR.LAG_DAY)
, POR.PRIORITY
, PA_OBJECT_RELATIONSHIPS_UTILS.GET_PRIORITY_MEANING(POR.PRIORITY)
, POR.RECORD_VERSION_NUMBER
, POR.PM_PRODUCT_CODE
, HZP.PARTY_NAME
, POR.CREATED_BY
, POR.CREATION_DATE
, POR.LAST_UPDATED_BY
, POR.LAST_UPDATE_DATE
, POR.LAST_UPDATE_LOGIN
FROM PA_OBJECT_RELATIONSHIPS POR
, FND_LOOKUP_VALUES FLV1
, FND_LOOKUP_VALUES FLV2
, FND_USER FU
, HZ_PARTIES HZP
WHERE POR.OBJECT_TYPE_FROM = FLV1.LOOKUP_CODE
AND FLV1.LOOKUP_TYPE = DECODE(SUBSTRB(POR.OBJECT_TYPE_FROM
, 1
, 2)
, 'PA'
, 'PA_OBJECTS'
, 'IPD_CHANGE_OBJECTS')
AND FLV1.LANGUAGE = USERENV('LANG')
AND POR.OBJECT_TYPE_TO = FLV2.LOOKUP_CODE
AND FLV2.LOOKUP_TYPE = DECODE(SUBSTRB(POR.OBJECT_TYPE_TO
, 1
, 2)
, 'PA'
, 'PA_OBJECTS'
, 'IPD_CHANGE_OBJECTS')
AND FLV2.LANGUAGE = USERENV('LANG')
AND POR.CREATED_BY = FU.USER_ID(+)
AND NVL(FU.CUSTOMER_ID
, -99) = HZP.PARTY_ID(+)
AND NVL(HZP.PARTY_TYPE
, 'PERSON') = 'PERSON'

Columns