eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ITG_TRANSFER_RULE_ACTIONS_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.ROWID ROW_ID
, A.ACTION_ID
, A.RULE_ID
, A.ACTION_CODE
, A.SEGMENT_NUM
, A.LEAF_NUM_ID
, NVL(RSEG.SEGMENT_NAME
, DECODE(A.ACTION_CODE
, 'A'
, A.ASSIGN_VALUE)) SEGMENT_NAME
, NVL(L.LEAF_FIELD
, DECODE(A.ACTION_CODE
, 'A'
, A.ASSIGN_VALUE)) LEAF_FIELD
, RSEG.FLEX_VALUE_SET_ID
, RSEG.ALPHANUMERIC_ALLOWED_FLAG
, A.ASSIGN_VALUE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
FROM ITG_TRANSFER_RULE_ACTIONS A
, ITG_CATALOG_OF_LEAVES L
, (SELECT R.RULE_ID
, SEG.ID_FLEX_NUM
, SEG.SEGMENT_NUM
, SEG.SEGMENT_NAME
, SEG.FLEX_VALUE_SET_ID
, VSET.ALPHANUMERIC_ALLOWED_FLAG
FROM ITG_TRANSFER_RULES R
, FND_ID_FLEX_SEGMENTS SEG
, FND_FLEX_VALUE_SETS VSET
WHERE R.CHART_OF_ACCOUNTS_ID = SEG.ID_FLEX_NUM
AND SEG.FLEX_VALUE_SET_ID = VSET.FLEX_VALUE_SET_ID) RSEG
WHERE RSEG.RULE_ID (+)= A.RULE_ID
AND RSEG.SEGMENT_NUM (+)= A.SEGMENT_NUM
AND L.LEAF_NUM_ID(+) = A.LEAF_NUM_ID

Columns

Name
ROW_ID
ACTION_ID
RULE_ID
ACTION_CODE
SEGMENT_NUM
LEAF_NUM_ID
SEGMENT_NAME
LEAF_FIELD
FLEX_VALUE_SET_ID
ALPHANUMERIC_ALLOWED_FLAG
ASSIGN_VALUE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN