APPS.AMS_DMEXTRACT_PVT dependencies on AMS_DM_PROFILE_STG_GT

Line 176: TruncateTable ('AMS_DM_PROFILE_STG_GT');

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');
179:
180: -------------------- finish --------------------------

Line 1058: INSERT INTO ams_dm_profile_stg_gt ( -- nyostos - Sep 15, 2003 - Global Temp Table

1054:
1055: IF l_is_b2b THEN
1056: IF p_model_type='CUSTOMER_PROFITABILITY' OR p_is_org_prod THEN
1057: -- INSERT INTO ams_dm_party_profile_stg (
1058: INSERT INTO ams_dm_profile_stg_gt ( -- nyostos - Sep 15, 2003 - Global Temp Table
1059: party_id,
1060: credit_check_flag,
1061: tolerance,
1062: discount_terms_flag,

Line 1097: INSERT INTO ams_dm_profile_stg_gt ( -- nyostos - Sep 15, 2003 - Global Temp Table

1093: GROUP BY drv.party_id
1094: ;
1095: ELSE
1096: -- INSERT INTO ams_dm_party_profile_stg (
1097: INSERT INTO ams_dm_profile_stg_gt ( -- nyostos - Sep 15, 2003 - Global Temp Table
1098: party_id,
1099: credit_check_flag,
1100: tolerance,
1101: discount_terms_flag,

Line 1147: INSERT INTO ams_dm_profile_stg_gt ( -- nyostos - Sep 15, 2003 - Global Temp Table

1143: ;
1144: END IF;
1145: ELSE
1146: -- INSERT INTO ams_dm_party_profile_stg (
1147: INSERT INTO ams_dm_profile_stg_gt ( -- nyostos - Sep 15, 2003 - Global Temp Table
1148: party_id,
1149: credit_check_flag,
1150: tolerance,
1151: discount_terms_flag,

Line 3195: ams_dm_profile_stg_gt 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 (+)
3198: AND drv.party_id = int.party_id (+)
3199: AND drv.party_id = fin.party_id (+)

Line 3655: ams_dm_profile_stg_gt ppf

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
3658: AND drv.party_id = gen.party_id (+)
3659: AND drv.party_id = int.party_id (+)