VIEW: APPS.PA_SEGMENT_RULE_PAIRINGS_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )