APPS.AMS_DMEXTRACT_PVT dependencies on AMS_DM_BIC_STG_GT

Line 178: TruncateTable ('AMS_DM_BIC_STG_GT');

174: TruncateTable ('AMS_DM_PERINT_STG_GT');
175: TruncateTable ('AMS_DM_FINNUM_STG_GT');
176: TruncateTable ('AMS_DM_PROFILE_STG_GT');
177: TruncateTable ('AMS_DM_AGG_STG_GT');
178: TruncateTable ('AMS_DM_BIC_STG_GT');
179:
180: -------------------- finish --------------------------
181: IF (AMS_DEBUG_HIGH_ON) THEN
182: AMS_Utility_PVT.debug_message (l_full_name || ': End');

Line 2452: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/

2448: IF p_model_type='CUSTOMER_PROFITABILITY' OR p_is_org_prod THEN
2449: -- nyostos - Sep 15, 2003 - Use Global Temporary Table
2450: -- INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG,DEFAULT,DEFAULT)*/
2451: -- INTO ams_dm_BIC_stg (
2452: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/
2453: INTO ams_dm_BIC_stg_GT (
2454: party_id,
2455: avg_talk_time,
2456: avg_order_amount,

Line 2453: INTO ams_dm_BIC_stg_GT (

2449: -- nyostos - Sep 15, 2003 - Use Global Temporary Table
2450: -- INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG,DEFAULT,DEFAULT)*/
2451: -- INTO ams_dm_BIC_stg (
2452: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/
2453: INTO ams_dm_BIC_stg_GT (
2454: party_id,
2455: avg_talk_time,
2456: avg_order_amount,
2457: avg_units_per_order,

Line 2586: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/

2582: ELSE
2583: -- nyostos - Sep 15, 2003 - Use Global Temporary Table
2584: -- INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG,DEFAULT,DEFAULT)*/
2585: -- INTO ams_dm_BIC_stg (
2586: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/
2587: INTO ams_dm_BIC_stg_GT (
2588: party_id,
2589: avg_talk_time,
2590: avg_order_amount,

Line 2587: INTO ams_dm_BIC_stg_GT (

2583: -- nyostos - Sep 15, 2003 - Use Global Temporary Table
2584: -- INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG,DEFAULT,DEFAULT)*/
2585: -- INTO ams_dm_BIC_stg (
2586: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/
2587: INTO ams_dm_BIC_stg_GT (
2588: party_id,
2589: avg_talk_time,
2590: avg_order_amount,
2591: avg_units_per_order,

Line 2729: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/

2725: ELSE
2726: -- nyostos - Sep 15, 2003 - Use Global Temporary Table
2727: -- INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG,DEFAULT,DEFAULT)*/
2728: -- INTO ams_dm_BIC_stg (
2729: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/
2730: INTO ams_dm_BIC_stg_GT (
2731: party_id,
2732: avg_talk_time,
2733: avg_order_amount,

Line 2730: INTO ams_dm_BIC_stg_GT (

2726: -- nyostos - Sep 15, 2003 - Use Global Temporary Table
2727: -- INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG,DEFAULT,DEFAULT)*/
2728: -- INTO ams_dm_BIC_stg (
2729: INSERT -- /*+ APPEND PARALLEL(AMS_DM_BIC_STG_GT,DEFAULT,DEFAULT)*/
2730: INTO ams_dm_BIC_stg_GT (
2731: party_id,
2732: avg_talk_time,
2733: avg_order_amount,
2734: avg_units_per_order,

Line 3436: ams_dm_bic_stg_gt bic

3432: -- ams_dm_agg_stg agg,
3433: -- ams_dm_bic_stg bic
3434: ams_dm_drv_stg_gt drv,
3435: ams_dm_agg_stg_gt agg,
3436: ams_dm_bic_stg_gt bic
3437: WHERE drv.party_id = agg.party_id (+)
3438: AND drv.party_id = bic.party_id (+)
3439: ;
3440: -------------------- finish --------------------------

Line 3879: ams_dm_bic_stg_gt bic

3875: bic.profitability profitability
3876: FROM
3877: ams_dm_drv_stg_gt drv,
3878: ams_dm_agg_stg_gt agg,
3879: ams_dm_bic_stg_gt bic
3880: WHERE drv.party_id = pdtt.party_id
3881: AND drv.party_id = agg.party_id (+)
3882: AND drv.party_id = bic.party_id (+)
3883: )