APPS.AMS_DMEXTRACT_PVT dependencies on FND_GLOBAL

Line 3043: FND_GLOBAL.USER_ID created_by, ---------------> FND_GLOBAL

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,

Line 3045: fnd_global.user_id last_updated_by,

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

Line 3047: fnd_global.conc_login_id last_update_login,

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,

Line 3340: FND_GLOBAL.USER_ID created_by,

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,

Line 3342: fnd_global.user_id last_updated_by,

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

Line 3344: fnd_global.conc_login_id last_update_login,

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,

Line 3563: fnd_global.user_id last_updated_by,

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,

Line 3565: fnd_global.conc_login_id last_update_login,

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,

Line 3790: fnd_global.user_id last_updated_by,

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,

Line 3792: fnd_global.conc_login_id last_update_login,

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,