VIEW: APPS.CSF_M_II_RELATIONSHIPS_V

Source

View Text - Preformatted

SELECT rel_acc.ACCESS_ID , cir.RELATIONSHIP_ID , cir.OBJECT_ID , cir.SUBJECT_ID , cir.POSITION_REFERENCE , cir.ACTIVE_START_DATE , cir.ACTIVE_END_DATE , cir.DISPLAY_ORDER , cir.MANDATORY_FLAG , asg_base.get_user_name CLIENT_NAME FROM CSI_II_RELATIONSHIPS cir, csm_ii_relationships_acc rel_acc WHERE rel_acc.user_id = asg_base.get_user_id AND rel_acc.relationship_id = cir.relationship_id AND cir.relationship_type_code = 'COMPONENT-OF' AND SYSDATE BETWEEN nvl(cir.active_start_date, SYSDATE) AND nvl(cir.active_end_date, SYSDATE)

View Text - HTML Formatted

SELECT REL_ACC.ACCESS_ID
, CIR.RELATIONSHIP_ID
, CIR.OBJECT_ID
, CIR.SUBJECT_ID
, CIR.POSITION_REFERENCE
, CIR.ACTIVE_START_DATE
, CIR.ACTIVE_END_DATE
, CIR.DISPLAY_ORDER
, CIR.MANDATORY_FLAG
, ASG_BASE.GET_USER_NAME CLIENT_NAME
FROM CSI_II_RELATIONSHIPS CIR
, CSM_II_RELATIONSHIPS_ACC REL_ACC
WHERE REL_ACC.USER_ID = ASG_BASE.GET_USER_ID
AND REL_ACC.RELATIONSHIP_ID = CIR.RELATIONSHIP_ID
AND CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
AND SYSDATE BETWEEN NVL(CIR.ACTIVE_START_DATE
, SYSDATE)
AND NVL(CIR.ACTIVE_END_DATE
, SYSDATE)