Product: | IEU - Universal Work Queue |
---|---|
Description: | View used for UWQ selector SpreadTable. |
Implementation/DBA Data: | Not implemented in this database |
SELECT B.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, B.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'LEAD_ID' IEU_PARAM_PK_COL
, TO_CHAR(A.LEAD_ID) IEU_PARAM_PK_VALUE
, A.RESOURCE_ID
, A.RESOURCE_TYPE
, A.DESCRIPTION
, A.PARTY_ID
, A.PARTY_NAME
, A.SALES_STAGE_ID
, A.SALES_STAGE_NAME
, A.STATUS_CODE
, A.STATUS_MEANING
, A.WIN_PROBABILITY
, A.PROBABILITY_MEANING
, A.RESOURCE_GROUP_ID
, A.TOTAL_AMOUNT
, A.CUSTOMER_BUDGET
, A.DECISION_DATE
, A.LEAD_NUMBER
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_BY
, A.CREATION_DATE
, A.CHANNEL_CODE
, A.SALES_CHANNEL
, A.CURRENCY_CODE
, A.PARENT_PROJECT
, A.DECISION_TIMEFRAME_CODE
, A.DECISION_TIMEFRAME
FROM AST_SALES_OPP_UWQ_V A
, JTF_OBJECTS_VL B
WHERE B.OBJECT_CODE = A.OBJECT_CODE