APPS.AMS_DMEXTRACT_PVT dependencies on AMS_DM_GEN_STG_GT

Line 173: TruncateTable ('AMS_DM_GEN_STG_GT');

169: --TruncateTable ('AMS_DM_AGG_STG');
170: --TruncateTable ('AMS_DM_BIC_STG');
171:
172: TruncateTable ('AMS_DM_DRV_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');

Line 360: INTO ams_dm_gen_stg_gt (

356: -- Insert for B2B
357: IF p_model_type = 'CUSTOMER_PROFITABILITY' OR p_is_org_prod THEN
358: INSERT /*+ first_rows*/
359: -- INTO ams_dm_gen_stg (
360: INTO ams_dm_gen_stg_gt (
361: party_id,
362: party_type,
363: country,
364: state,

Line 507: INTO ams_dm_gen_stg_gt ( -- nysotos - Sep 15, 2003 - Global Temp Table

503: AND (SYSDATE BETWEEN hop.effective_start_date(+) and NVL(hop.effective_end_date(+),SYSDATE));
504: ELSE
505: INSERT /*+ first_rows*/
506: -- INTO ams_dm_gen_stg (
507: INTO ams_dm_gen_stg_gt ( -- nysotos - Sep 15, 2003 - Global Temp Table
508: party_id,
509: party_type,
510: gender,
511: ethnicity,

Line 717: INTO ams_dm_gen_stg_gt ( -- nysotos - Sep 15, 2003 - Global Temp Table

713: END IF;
714: ELSE
715: INSERT /*+ first_rows*/
716: -- INTO ams_dm_gen_stg (
717: INTO ams_dm_gen_stg_gt ( -- nysotos - Sep 15, 2003 - Global Temp Table
718: party_id,
719: party_type,
720: gender,
721: ethnicity,

Line 3192: ams_dm_gen_stg_gt gen,

3188: -- ams_dm_perint_stg int,
3189: -- ams_dm_finnum_stg fin,
3190: -- ams_dm_party_profile_stg ppf
3191: ams_dm_drv_stg_gt drv,
3192: ams_dm_gen_stg_gt gen,
3193: ams_dm_perint_stg_gt int,
3194: ams_dm_finnum_stg_gt fin,
3195: ams_dm_profile_stg_gt ppf
3196: WHERE

Line 3652: ams_dm_gen_stg_gt gen,

3648: ppf.interest_period_days interest_period_days,
3649: ppf.payment_grace_days payment_grace_days
3650: FROM
3651: ams_dm_drv_stg_gt drv,
3652: ams_dm_gen_stg_gt gen,
3653: ams_dm_perint_stg_gt int,
3654: ams_dm_finnum_stg_gt fin,
3655: ams_dm_profile_stg_gt ppf
3656: WHERE