[Home] [Help]
View: IEU_UWQ_LEAD_V
Product: | IEU - Universal Work Queue |
Description: | View used for UWQ selector SpreadTable. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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.STATUS_CODE
, A.STATUS_MEANING
, A.ASSIGN_SALES_GROUP_ID
, A.BUDGET_AMOUNT
, A.CURRENCY_CODE
, A.CREATION_DATE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_BY
FROM AST_SALES_LEAD_UWQ_V A
, JTF_OBJECTS_VL B
WHERE B.OBJECT_CODE = A.OBJECT_CODE
Columns
Name |
IEU_OBJECT_FUNCTION |
IEU_OBJECT_PARAMETERS |
IEU_MEDIA_TYPE_UUID |
IEU_PARAM_PK_COL |
IEU_PARAM_PK_VALUE |
RESOURCE_ID |
RESOURCE_TYPE |
DESCRIPTION |
PARTY_ID |
PARTY_NAME |
STATUS_CODE |
STATUS_MEANING |
ASSIGN_SALES_GROUP_ID |
BUDGET_AMOUNT |
CURRENCY_CODE |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATE_BY |