APPS.AMS_DMEXTRACT_PVT dependencies on AMS_DM_PERINT_STG_GT

Line 174: TruncateTable ('AMS_DM_PERINT_STG_GT');

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');
178: TruncateTable ('AMS_DM_BIC_STG_GT');

Line 849: INSERT INTO ams_dm_perint_stg_gt ( -- nysotos - Sep 15, 2003 - Global Temp Table

845:
846: IF l_is_b2b THEN
847: IF p_model_type<>'CUSTOMER_PROFITABILITY' OR p_is_org_prod THEN
848: -- INSERT INTO ams_dm_perint_stg (
849: INSERT INTO ams_dm_perint_stg_gt ( -- nysotos - Sep 15, 2003 - Global Temp Table
850: party_id,
851: -- interest related attributes
852: interest_art_flag,
853: interest_books_flag,

Line 898: INSERT INTO ams_dm_perint_stg_gt ( -- nyostos - Sept 15, 2003 - Global Temp Table

894: ;
895: END IF;
896: ELSE
897: -- INSERT INTO ams_dm_perint_stg (
898: INSERT INTO ams_dm_perint_stg_gt ( -- nyostos - Sept 15, 2003 - Global Temp Table
899: party_id,
900: -- interest related attributes
901: interest_art_flag,
902: interest_books_flag,

Line 3193: ams_dm_perint_stg_gt 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
3197: drv.party_id = gen.party_id (+)

Line 3653: ams_dm_perint_stg_gt int,

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
3657: drv.party_id = pdt.party_id