View: PA_SEGMENT_RULE_PAIRINGS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_SEGMENT_RULE_PAIRINGS_V

View Text

SELECT P.ROWID
, P.APPLICATION_ID
, P.FUNCTION_CODE
, P.FUNCTION_TRANSACTION_CODE
, P.ID_FLEX_CODE
, P.ID_FLEX_NUM
, P.SEGMENT_NUM
, P.RULE_ID
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, P.DISPLAY_FLAG
, F.SEGMENT_NAME
, R.RULE_NAME
, P.ORG_ID
FROM PA_SEGMENT_RULE_PAIRINGS P
, PA_RULES R
, FND_ID_FLEX_SEGMENTS F
WHERE P.RULE_ID = R.RULE_ID
AND F.APPLICATION_ID = 101
AND F.ENABLED_FLAG = 'Y'
AND F.ID_FLEX_CODE = P.ID_FLEX_CODE
AND F.ID_FLEX_NUM = P.ID_FLEX_NUM
AND F.SEGMENT_NAME = ( SELECT A.SEGMENT_NAME
FROM FND_ID_FLEX_SEGMENTS A
, FND_ID_FLEX_SEGMENTS B
WHERE A.APPLICATION_ID = 101
AND A.ID_FLEX_CODE = P.ID_FLEX_CODE
AND A.ID_FLEX_NUM = P.ID_FLEX_NUM
AND A.ENABLED_FLAG = 'Y'
AND B.APPLICATION_ID = 101
AND B.ENABLED_FLAG = 'Y'
AND A.ID_FLEX_CODE = B.ID_FLEX_CODE
AND A.ID_FLEX_NUM = B.ID_FLEX_NUM
AND A.SEGMENT_NUM >= B.SEGMENT_NUM GROUP BY A.SEGMENT_NAME HAVING COUNT(*)-1 IN P.SEGMENT_NUM )

Columns