3039: city
3040: )
3041: SELECT
3042: drv.party_id party_id,
3043: FND_GLOBAL.USER_ID created_by, ---------------> FND_GLOBAL
3044: SYSDATE creation_date,
3045: fnd_global.user_id last_updated_by,
3046: SYSDATE last_update_date,
3047: fnd_global.conc_login_id last_update_login,
3041: SELECT
3042: drv.party_id party_id,
3043: FND_GLOBAL.USER_ID created_by, ---------------> FND_GLOBAL
3044: SYSDATE creation_date,
3045: fnd_global.user_id last_updated_by,
3046: SYSDATE last_update_date,
3047: fnd_global.conc_login_id last_update_login,
3048: 1 object_version_number,
3049: gen.party_type party_type, ---------------> 1-1
3043: FND_GLOBAL.USER_ID created_by, ---------------> FND_GLOBAL
3044: SYSDATE creation_date,
3045: fnd_global.user_id last_updated_by,
3046: SYSDATE last_update_date,
3047: fnd_global.conc_login_id last_update_login,
3048: 1 object_version_number,
3049: gen.party_type party_type, ---------------> 1-1
3050: gen.gender gender,
3051: gen.ethnicity ethnicity,
3336: call_length,
3337: profitability)
3338: SELECT
3339: drv.party_id party_id,
3340: FND_GLOBAL.USER_ID created_by,
3341: SYSDATE creation_date,
3342: fnd_global.user_id last_updated_by,
3343: SYSDATE last_update_date,
3344: fnd_global.conc_login_id last_update_login,
3338: SELECT
3339: drv.party_id party_id,
3340: FND_GLOBAL.USER_ID created_by,
3341: SYSDATE creation_date,
3342: fnd_global.user_id last_updated_by,
3343: SYSDATE last_update_date,
3344: fnd_global.conc_login_id last_update_login,
3345: 1 object_version_number,
3346: agg.age age, --------------- to be mapped
3340: FND_GLOBAL.USER_ID created_by,
3341: SYSDATE creation_date,
3342: fnd_global.user_id last_updated_by,
3343: SYSDATE last_update_date,
3344: fnd_global.conc_login_id last_update_login,
3345: 1 object_version_number,
3346: agg.age age, --------------- to be mapped
3347: agg.days_since_last_school days_since_last_school,
3348: agg.days_since_last_event days_since_last_event,
3559: risk_code,
3560: interest_period_days,
3561: payment_grace_days
3562: ) = ( SELECT
3563: fnd_global.user_id last_updated_by,
3564: SYSDATE last_update_date,
3565: fnd_global.conc_login_id last_update_login,
3566: gen.gender gender,
3567: gen.ethnicity ethnicity,
3561: payment_grace_days
3562: ) = ( SELECT
3563: fnd_global.user_id last_updated_by,
3564: SYSDATE last_update_date,
3565: fnd_global.conc_login_id last_update_login,
3566: gen.gender gender,
3567: gen.ethnicity ethnicity,
3568: gen.marital_status marital_status,
3569: gen.personal_income personal_income,
3786: tot_calls,
3787: call_length,
3788: profitability
3789: ) = ( SELECT
3790: fnd_global.user_id last_updated_by,
3791: SYSDATE last_update_date,
3792: fnd_global.conc_login_id last_update_login,
3793: agg.age age,
3794: agg.days_since_last_school days_since_last_school,
3788: profitability
3789: ) = ( SELECT
3790: fnd_global.user_id last_updated_by,
3791: SYSDATE last_update_date,
3792: fnd_global.conc_login_id last_update_login,
3793: agg.age age,
3794: agg.days_since_last_school days_since_last_school,
3795: agg.days_since_last_event days_since_last_event,
3796: agg.num_times_targeted num_times_targeted,