DBA Data[Home] [Help]

APPS.BIX_POP_AO_SUM_PKG dependencies on BIX_DM_INTERFACE

Line 167: FROM BIX_DM_INTERFACE

163: SUM(LEADS_AMOUNT_TXN) leads_amount_txn,
164: SUM(OPPORTUNITIES_WON + OPPORTUNITIES_CROSS_SOLD + OPPORTUNITIES_UP_SOLD) OPPORTUNITIES_WON,
165: SUM(OPPORTUNITIES_WON_AMOUNT) OPPORTUNITIES_WON_AMOUNT,
166: SUM(OPPORTUNITIES_WON_AMOUNT_TXN) OPPORTUNITIES_WON_AMOUNT_TXN
167: FROM BIX_DM_INTERFACE
168: WHERE direction = 1 --OUTBOUND
169: AND period_start_date_time BETWEEN p_start_date_time AND p_end_date_time
170: GROUP BY
171: campaign_schedule_id,