DBA Data[Home] [Help]

APPS.BIM_FUND_FACTS dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 1786: ams_campaign_schedules_b B

1782: D.business_unit_id business_unit_id,D.org_id org_id,
1783: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id
1784: FROM
1785: ams_campaigns_all_b D,
1786: ams_campaign_schedules_b B
1787: WHERE B.campaign_id = D.campaign_id (+)
1788: UNION ALL
1789: SELECT
1790: D.business_unit_id business_unit_id,D.org_id org_id,

Line 1835: ams_campaign_schedules_b E,

1831: BA.business_unit_id business_unit_id,BA.org_id org_id,
1832: 'DELV' object_type_J, 'CSCHDELV' object_type, D.using_object_id object_id
1833: FROM
1834: ams_campaigns_all_b BA,
1835: ams_campaign_schedules_b E,
1836: ams_object_associations D
1837: WHERE
1838: D.master_object_type (+) = 'CSCH' AND D.master_object_id = E.SCHEDULE_ID
1839: (+) AND E.campaign_id = BA.campaign_id (+)

Line 1979: ams_campaign_schedules_b B

1975: D.business_unit_id business_unit_id,D.org_id org_id,
1976: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id
1977: FROM
1978: ams_campaigns_all_b D,
1979: ams_campaign_schedules_b B
1980: WHERE B.campaign_id = D.campaign_id (+)
1981: UNION ALL
1982: SELECT
1983: D.business_unit_id business_unit_id,D.org_id org_id,

Line 2028: ams_campaign_schedules_b E,

2024: BA.business_unit_id business_unit_id,BA.org_id org_id,
2025: 'DELV' object_type_J, 'CSCHDELV' object_type, D.using_object_id object_id
2026: FROM
2027: ams_campaigns_all_b BA,
2028: ams_campaign_schedules_b E,
2029: ams_object_associations D
2030: WHERE
2031: D.master_object_type (+) = 'CSCH' AND D.master_object_id = E.SCHEDULE_ID
2032: (+) AND E.campaign_id = BA.campaign_id (+)

Line 3528: ams_campaign_schedules_b B

3524: D.business_unit_id business_unit_id,D.org_id org_id,
3525: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id
3526: FROM
3527: ams_campaigns_all_b D,
3528: ams_campaign_schedules_b B
3529: WHERE B.campaign_id = D.campaign_id (+)
3530: UNION ALL
3531: SELECT
3532: D.business_unit_id business_unit_id,D.org_id org_id,

Line 3577: ams_campaign_schedules_b E,

3573: BA.business_unit_id business_unit_id,BA.org_id org_id,
3574: 'DELV' object_type_J, 'CSCHDELV' object_type, D.using_object_id object_id
3575: FROM
3576: ams_campaigns_all_b BA,
3577: ams_campaign_schedules_b E,
3578: ams_object_associations D
3579: WHERE
3580: D.master_object_type (+) = 'CSCH' AND D.master_object_id = E.SCHEDULE_ID
3581: (+) AND E.campaign_id = BA.campaign_id (+)

Line 3723: ams_campaign_schedules_b B

3719: D.business_unit_id business_unit_id,D.org_id org_id,
3720: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id
3721: FROM
3722: ams_campaigns_all_b D,
3723: ams_campaign_schedules_b B
3724: WHERE B.campaign_id = D.campaign_id (+)
3725: UNION ALL
3726: SELECT
3727: D.business_unit_id business_unit_id,D.org_id org_id,

Line 3772: ams_campaign_schedules_b E,

3768: BA.business_unit_id business_unit_id,BA.org_id org_id,
3769: 'DELV' object_type_J, 'CSCHDELV' object_type, D.using_object_id object_id
3770: FROM
3771: ams_campaigns_all_b BA,
3772: ams_campaign_schedules_b E,
3773: ams_object_associations D
3774: WHERE
3775: D.master_object_type (+) = 'CSCH' AND D.master_object_id = E.SCHEDULE_ID
3776: (+) AND E.campaign_id = BA.campaign_id (+)