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: BIL_FCTV_PIPELINE

Product:	BIL - Sales Intelligence (Obsolete)
Description:	Quantitative measures related to sales opportunities
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASCD.LEAD_ID
, ASCD.LEAD_NUMBER
, ASCD.LEAD_LINE_ID
, ASCD.SALES_CREDIT_ID
, NULL
, ASCD.ORGANIZATION_ID
, ASCD.SALESFORCE_ID
, ASCD.SALES_GROUP_ID
, ASCD.CUSTOMER_ID
, ASCD.CHANNEL_CODE
, ASCD.INTEREST_TYPE_ID
, ASCD.PRIMARY_INTEREST_CODE_ID
, ASCD.SECONDARY_INTEREST_CODE_ID
, ASCD.ITEM_ID
, ASCD.SALES_STAGE_ID
, ASCD.STATUS_CODE
, ASCD.C1_CURRENCY_CODE
, ASCD.CREATION_DATE
, ASCD.DECISION_DATE
, ASCD.WIN_PROBABILITY
, ASCD.OPP_DESCRIPTION
, ASCD.CREDIT_TYPE_ID
, OSCT.QUOTA_FLAG
, ASCD.C1_SALES_CREDIT_AMOUNT
, NULL
, ASCD.C1_SALES_CREDIT_AMOUNT
, NULL
, NULL
, ASCD.QUANTITY
, ASCD.UOM_CODE
, ASCD.UOM_DESCRIPTION
, NULL
, ASCD.LEAD_SOURCE_CODE
, ASCD.SALES_REP_NAME
, ASCD.CUSTOMER_NAME
FROM AS_SALES_CREDITS_DENORM ASCD
, OE_SALES_CREDIT_TYPES OSCT
WHERE ASCD.OPP_DELETED_FLAG = 'N'
AND ASCD.CREDIT_TYPE_ID = OSCT.SALES_CREDIT_TYPE_ID WITH READ ONLY

Columns

Name
LEAD_ID
LEAD_NUMBER
LEAD_LINE_ID
SALES_CREDIT_ID
MC_SALES_CREDIT_ID
ORG_ID
SALESFORCE_FK
SALES_GROUP_FK
CUSTOMER_FK
SALES_CHANNEL_FK
INTEREST_TYPE_FK
PRIMARY_INTEREST_CODE_FK
SECONDARY_INTEREST_CODE_FK
INVENTORY_ITEM_FK
SALES_STAGE_FK
STATUS_CODE_FK
CURRENCY_CODE
CREATION_DATE
DECISION_DATE
WIN_PROBABILITY
DESCRIPTION
CREDIT_TYPE_ID
QUOTA_FLAG
REVENUE_AMOUNT
REVENUE_PERCENT
CREDIT_AMOUNT
CREDIT_PERCENT
LINE_TOTAL_AMOUNT
LINE_QUANTITY
LINE_UOM_CODE
UOM_DESCRIPTION
SHIP_DATE
MARKETING_CODE
SALES_REP_NAME
CUSTOMER_NAME