APPS.AMS_DMEXTRACT_PVT dependencies on AMS_DM_FINNUM_STG_GT

Line 175: TruncateTable ('AMS_DM_FINNUM_STG_GT');

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

Line 943: INSERT INTO ams_dm_finnum_stg_gt ( -- nyostos - Sep 15, 2003 -

939: -- financial number attributes
940: IF l_is_b2b THEN --kbasavar
941: IF p_model_type='CUSTOMER_PROFITABILITY' OR p_is_org_prod THEN
942: -- INSERT INTO ams_dm_finnum_stg (
943: INSERT INTO ams_dm_finnum_stg_gt ( -- nyostos - Sep 15, 2003 -
944: party_id,
945: gross_annual_income,
946: debt_to_income_ratio,
947: net_worth,

Line 984: INSERT INTO ams_dm_finnum_stg_gt (

980: ;
981: ELSE
982: -- nyostos - Sep 15, 2003 - Global Temp Table
983: -- INSERT INTO ams_dm_finnum_stg (
984: INSERT INTO ams_dm_finnum_stg_gt (
985: party_id,
986: gross_annual_income,
987: debt_to_income_ratio,
988: -- num_credit_lines,

Line 3194: ams_dm_finnum_stg_gt 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 (+)
3198: AND drv.party_id = int.party_id (+)

Line 3654: ams_dm_finnum_stg_gt fin,

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