APPS.AMS_DMEXTRACT_PVT dependencies on AMS_DM_AGG_STG_GT

Line 177: TruncateTable ('AMS_DM_AGG_STG_GT');

173: TruncateTable ('AMS_DM_GEN_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

Line 1769: INSERT INTO ams_dm_agg_stg_gt(

1765:
1766: l_party_list.delete;
1767:
1768: FOR k IN 1..l_master_party_id_list.COUNT LOOP
1769: INSERT INTO ams_dm_agg_stg_gt(
1770: party_id,
1771: age,
1772: days_since_last_school,
1773: days_since_last_event,

Line 2352: INSERT INTO ams_dm_agg_stg_gt(

2348:
2349: l_party_list.delete;
2350:
2351: FOR k IN 1..l_master_party_id_list.COUNT LOOP
2352: INSERT INTO ams_dm_agg_stg_gt(
2353: party_id,
2354: days_since_last_event,
2355: num_times_targeted,
2356: last_targeted_channel_code,

Line 3435: ams_dm_agg_stg_gt agg,

3431: -- ams_dm_drv_stg drv,
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: ;

Line 3878: ams_dm_agg_stg_gt agg,

3874: bic.call_length call_length,
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 (+)