APPS.BIM_FUND_FACTS dependencies on AMS_OBJECT_ASSOCIATIONS

Line 1824: ams_object_associations D

1820: BA.business_unit_id business_unit_id,BA.org_id org_id,
1821: 'DELV' object_type_J, 'CAMPDELV' object_type, D.using_object_id object_id
1822: FROM
1823: ams_campaigns_all_b BA,
1824: ams_object_associations D
1825: WHERE
1826: D.using_object_type='DELV' AND
1827: D.master_object_type (+) = 'CAMP' AND
1828: D.master_object_id = BA.campaign_id (+)

Line 1836: ams_object_associations D

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 (+)
1840: AND D.using_object_type (+) = 'DELV'

Line 1847: ams_object_associations D

1843: BA.business_unit_id business_unit_id,BA.org_id org_id,
1844: 'DELV' object_type_J, 'EVEHDELV' object_type, D.using_object_id object_id
1845: FROM
1846: ams_event_headers_all_b BA,
1847: ams_object_associations D
1848: WHERE D.using_object_type(+) = 'DELV'
1849: AND D.master_object_type(+) = 'EVEH'
1850: AND D.master_object_id = BA.event_header_id (+)
1851: UNION ALL

Line 1857: ams_object_associations D

1853: BA.business_unit_id business_unit_id,BA.org_id org_id,
1854: 'DELV' object_type_J, 'EVEODELV' object_type, D.using_object_id object_id
1855: FROM
1856: ams_event_offers_all_b BA,
1857: ams_object_associations D
1858: WHERE D.using_object_type(+) = 'DELV'
1859: AND D.master_object_type(+) = 'EVEO'
1860: AND D.master_object_id = BA.event_offer_id (+)
1861: UNION ALL

Line 1867: ams_object_associations D

1863: BA.business_unit_id business_unit_id,BA.org_id org_id,
1864: 'DELV' object_type_J, 'EONEDELV' object_type, D.using_object_id object_id
1865: FROM
1866: ams_event_offers_all_b BA,
1867: ams_object_associations D
1868: WHERE D.using_object_type(+) = 'DELV'
1869: AND D.master_object_type(+) = 'EONE'
1870: AND D.master_object_id = BA.event_offer_id (+)
1871: ) U

Line 2017: ams_object_associations D

2013: BA.business_unit_id business_unit_id,BA.org_id org_id,
2014: 'DELV' object_type_J, 'CAMPDELV' object_type, D.using_object_id object_id
2015: FROM
2016: ams_campaigns_all_b BA,
2017: ams_object_associations D
2018: WHERE
2019: D.using_object_type='DELV' AND
2020: D.master_object_type (+) = 'CAMP' AND
2021: D.master_object_id = BA.campaign_id (+)

Line 2029: ams_object_associations D

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 (+)
2033: AND D.using_object_type (+) = 'DELV'

Line 2040: ams_object_associations D

2036: BA.business_unit_id business_unit_id,BA.org_id org_id,
2037: 'DELV' object_type_J, 'EVEHDELV' object_type, D.using_object_id object_id
2038: FROM
2039: ams_event_headers_all_b BA,
2040: ams_object_associations D
2041: WHERE D.using_object_type(+) = 'DELV'
2042: AND D.master_object_type(+) = 'EVEH'
2043: AND D.master_object_id = BA.event_header_id (+)
2044: UNION ALL

Line 2050: ams_object_associations D

2046: BA.business_unit_id business_unit_id,BA.org_id org_id,
2047: 'DELV' object_type_J, 'EVEODELV' object_type, D.using_object_id object_id
2048: FROM
2049: ams_event_offers_all_b BA,
2050: ams_object_associations D
2051: WHERE D.using_object_type(+) = 'DELV'
2052: AND D.master_object_type(+) = 'EVEO'
2053: AND D.master_object_id = BA.event_offer_id (+)
2054: UNION ALL

Line 2060: ams_object_associations D

2056: BA.business_unit_id business_unit_id,BA.org_id org_id,
2057: 'DELV' object_type_J, 'EONEDELV' object_type, D.using_object_id object_id
2058: FROM
2059: ams_event_offers_all_b BA,
2060: ams_object_associations D
2061: WHERE D.using_object_type(+) = 'DELV'
2062: AND D.master_object_type(+) = 'EONE'
2063: AND D.master_object_id = BA.event_offer_id (+)
2064: ) U

Line 3566: ams_object_associations D

3562: BA.business_unit_id business_unit_id,BA.org_id org_id,
3563: 'DELV' object_type_J, 'CAMPDELV' object_type, D.using_object_id object_id
3564: FROM
3565: ams_campaigns_all_b BA,
3566: ams_object_associations D
3567: WHERE
3568: D.using_object_type='DELV' AND
3569: D.master_object_type (+) = 'CAMP' AND
3570: D.master_object_id = BA.campaign_id (+)

Line 3578: ams_object_associations D

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 (+)
3582: AND D.using_object_type (+) = 'DELV'

Line 3589: ams_object_associations D

3585: BA.business_unit_id business_unit_id,BA.org_id org_id,
3586: 'DELV' object_type_J, 'EVEHDELV' object_type, D.using_object_id object_id
3587: FROM
3588: ams_event_headers_all_b BA,
3589: ams_object_associations D
3590: WHERE D.using_object_type(+) = 'DELV'
3591: AND D.master_object_type(+) = 'EVEH'
3592: AND D.master_object_id = BA.event_header_id (+)
3593: UNION ALL

Line 3599: ams_object_associations D

3595: BA.business_unit_id business_unit_id,BA.org_id org_id,
3596: 'DELV' object_type_J, 'EVEODELV' object_type, D.using_object_id object_id
3597: FROM
3598: ams_event_offers_all_b BA,
3599: ams_object_associations D
3600: WHERE D.using_object_type(+) = 'DELV'
3601: AND D.master_object_type(+) = 'EVEO'
3602: AND D.master_object_id = BA.event_offer_id (+)
3603: UNION ALL

Line 3609: ams_object_associations D

3605: BA.business_unit_id business_unit_id,BA.org_id org_id,
3606: 'DELV' object_type_J, 'EONEDELV' object_type, D.using_object_id object_id
3607: FROM
3608: ams_event_offers_all_b BA,
3609: ams_object_associations D
3610: WHERE D.using_object_type(+) = 'DELV'
3611: AND D.master_object_type(+) = 'EONE'
3612: AND D.master_object_id = BA.event_offer_id (+)
3613: ) U

Line 3761: ams_object_associations D

3757: BA.business_unit_id business_unit_id,BA.org_id org_id,
3758: 'DELV' object_type_J, 'CAMPDELV' object_type, D.using_object_id object_id
3759: FROM
3760: ams_campaigns_all_b BA,
3761: ams_object_associations D
3762: WHERE
3763: D.using_object_type='DELV' AND
3764: D.master_object_type (+) = 'CAMP' AND
3765: D.master_object_id = BA.campaign_id (+)

Line 3773: ams_object_associations D

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 (+)
3777: AND D.using_object_type (+) = 'DELV'

Line 3784: ams_object_associations D

3780: BA.business_unit_id business_unit_id,BA.org_id org_id,
3781: 'DELV' object_type_J, 'EVEHDELV' object_type, D.using_object_id object_id
3782: FROM
3783: ams_event_headers_all_b BA,
3784: ams_object_associations D
3785: WHERE D.using_object_type(+) = 'DELV'
3786: AND D.master_object_type(+) = 'EVEH'
3787: AND D.master_object_id = BA.event_header_id (+)
3788: UNION ALL

Line 3794: ams_object_associations D

3790: BA.business_unit_id business_unit_id,BA.org_id org_id,
3791: 'DELV' object_type_J, 'EVEODELV' object_type, D.using_object_id object_id
3792: FROM
3793: ams_event_offers_all_b BA,
3794: ams_object_associations D
3795: WHERE D.using_object_type(+) = 'DELV'
3796: AND D.master_object_type(+) = 'EVEO'
3797: AND D.master_object_id = BA.event_offer_id (+)
3798: UNION ALL

Line 3804: ams_object_associations D

3800: BA.business_unit_id business_unit_id,BA.org_id org_id,
3801: 'DELV' object_type_J, 'EONEDELV' object_type, D.using_object_id object_id
3802: FROM
3803: ams_event_offers_all_b BA,
3804: ams_object_associations D
3805: WHERE D.using_object_type(+) = 'DELV'
3806: AND D.master_object_type(+) = 'EONE'
3807: AND D.master_object_id = BA.event_offer_id (+)
3808: ) U