VIEW: APPS.XDP_SVE_VAL_ACTION_DISP_V

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.SERVICE_VAL_ACT_ID, B.INVENTORY_ITEM_ID, B.ORGANIZATION_ID, B.ACTION_SOURCE, F.LOOKUP_CODE ACTION_CODE, F.MEANING ACTION_DISPLAY_NAME , B.WI_MAPPING_TYPE, B.WI_MAPPING_PROC, B.VALID_DATE, B.INVALID_DATE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.DESCRIPTION FROM XDP_SERVICE_VAL_ACTS_TL T , XDP_SERVICE_VAL_ACTS B , FND_LOOKUPS F WHERE B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID AND B.ACTION_SOURCE = 'XDP' AND B.ACTION_CODE = F.LOOKUP_CODE AND F.LOOKUP_TYPE = 'XDP_ACTIONS' AND T.LANGUAGE = userenv('LANG') UNION SELECT B.ROWID ROW_ID, B.SERVICE_VAL_ACT_ID, B.INVENTORY_ITEM_ID, B.ORGANIZATION_ID, B.ACTION_SOURCE, TO_CHAR(OT.TRANSACTION_TYPE_ID) ACTION_CODE, OT.NAME ACTION_DISPLAY_NAME, B.WI_MAPPING_TYPE, B.WI_MAPPING_PROC, B.VALID_DATE, B.INVALID_DATE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.DESCRIPTION FROM XDP_SERVICE_VAL_ACTS_TL T, XDP_SERVICE_VAL_ACTS B, OE_TRANSACTION_TYPES_TL OT WHERE B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID AND B.ACTION_SOURCE = 'SALES' AND OT.TRANSACTION_TYPE_ID = TO_NUMBER(B.ACTION_CODE) AND T.LANGUAGE = userenv('LANG') AND OT.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.SERVICE_VAL_ACT_ID
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.ACTION_SOURCE
, F.LOOKUP_CODE ACTION_CODE
, F.MEANING ACTION_DISPLAY_NAME
, B.WI_MAPPING_TYPE
, B.WI_MAPPING_PROC
, B.VALID_DATE
, B.INVALID_DATE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.DESCRIPTION
FROM XDP_SERVICE_VAL_ACTS_TL T
, XDP_SERVICE_VAL_ACTS B
, FND_LOOKUPS F
WHERE B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID
AND B.ACTION_SOURCE = 'XDP'
AND B.ACTION_CODE = F.LOOKUP_CODE
AND F.LOOKUP_TYPE = 'XDP_ACTIONS'
AND T.LANGUAGE = USERENV('LANG') UNION SELECT B.ROWID ROW_ID
, B.SERVICE_VAL_ACT_ID
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.ACTION_SOURCE
, TO_CHAR(OT.TRANSACTION_TYPE_ID) ACTION_CODE
, OT.NAME ACTION_DISPLAY_NAME
, B.WI_MAPPING_TYPE
, B.WI_MAPPING_PROC
, B.VALID_DATE
, B.INVALID_DATE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.DESCRIPTION
FROM XDP_SERVICE_VAL_ACTS_TL T
, XDP_SERVICE_VAL_ACTS B
, OE_TRANSACTION_TYPES_TL OT
WHERE B.SERVICE_VAL_ACT_ID = T.SERVICE_VAL_ACT_ID
AND B.ACTION_SOURCE = 'SALES'
AND OT.TRANSACTION_TYPE_ID = TO_NUMBER(B.ACTION_CODE)
AND T.LANGUAGE = USERENV('LANG')
AND OT.LANGUAGE = USERENV('LANG')