DBA Data[Home] [Help]

APPS.BIM_FUND_FACTS dependencies on AMS_EVENT_OFFERS_ALL_B

Line 1799: ams_event_offers_all_b D

1795: SELECT
1796: D.business_unit_id business_unit_id,D.org_id org_id,
1797: 'EVEO' object_type_J, 'EVEO' object_type, D.event_offer_id object_id
1798: FROM
1799: ams_event_offers_all_b D
1800: WHERE event_header_id is not null
1801: UNION ALL
1802: SELECT
1803: D.business_unit_id business_unit_id,D.org_id org_id,

Line 1806: ams_event_offers_all_b D

1802: SELECT
1803: D.business_unit_id business_unit_id,D.org_id org_id,
1804: 'EONE' object_type_J, 'EONE' object_type, D.event_offer_id object_id
1805: FROM
1806: ams_event_offers_all_b D
1807: WHERE event_header_id is null
1808: UNION ALL
1809: SELECT
1810: BC.business_unit_id business_unit_id,BC.org_id org_id,

Line 1856: ams_event_offers_all_b BA,

1852: SELECT
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 (+)

Line 1866: ams_event_offers_all_b BA,

1862: SELECT
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 (+)

Line 1992: ams_event_offers_all_b D

1988: SELECT
1989: D.business_unit_id business_unit_id,D.org_id org_id,
1990: 'EVEO' object_type_J, 'EVEO' object_type, D.event_offer_id object_id
1991: FROM
1992: ams_event_offers_all_b D
1993: WHERE event_header_id is not null
1994: UNION ALL
1995: SELECT
1996: D.business_unit_id business_unit_id,D.org_id org_id,

Line 1999: ams_event_offers_all_b D

1995: SELECT
1996: D.business_unit_id business_unit_id,D.org_id org_id,
1997: 'EONE' object_type_J, 'EONE' object_type, D.event_offer_id object_id
1998: FROM
1999: ams_event_offers_all_b D
2000: WHERE event_header_id is null
2001: UNION ALL
2002: SELECT
2003: BC.business_unit_id business_unit_id,BC.org_id org_id,

Line 2049: ams_event_offers_all_b BA,

2045: SELECT
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 (+)

Line 2059: ams_event_offers_all_b BA,

2055: SELECT
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 (+)

Line 3541: ams_event_offers_all_b D

3537: SELECT
3538: D.business_unit_id business_unit_id,D.org_id org_id,
3539: 'EVEO' object_type_J, 'EVEO' object_type, D.event_offer_id object_id
3540: FROM
3541: ams_event_offers_all_b D
3542: WHERE event_header_id is not null
3543: UNION ALL
3544: SELECT
3545: D.business_unit_id business_unit_id,D.org_id org_id,

Line 3548: ams_event_offers_all_b D

3544: SELECT
3545: D.business_unit_id business_unit_id,D.org_id org_id,
3546: 'EONE' object_type_J, 'EONE' object_type, D.event_offer_id object_id
3547: FROM
3548: ams_event_offers_all_b D
3549: WHERE event_header_id is null
3550: UNION ALL
3551: SELECT
3552: BC.business_unit_id business_unit_id,BC.org_id org_id,

Line 3598: ams_event_offers_all_b BA,

3594: SELECT
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 (+)

Line 3608: ams_event_offers_all_b BA,

3604: SELECT
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 (+)

Line 3736: ams_event_offers_all_b D

3732: SELECT
3733: D.business_unit_id business_unit_id,D.org_id org_id,
3734: 'EVEO' object_type_J, 'EVEO' object_type, D.event_offer_id object_id
3735: FROM
3736: ams_event_offers_all_b D
3737: WHERE event_header_id is not null
3738: UNION ALL
3739: SELECT
3740: D.business_unit_id business_unit_id,D.org_id org_id,

Line 3743: ams_event_offers_all_b D

3739: SELECT
3740: D.business_unit_id business_unit_id,D.org_id org_id,
3741: 'EONE' object_type_J, 'EONE' object_type, D.event_offer_id object_id
3742: FROM
3743: ams_event_offers_all_b D
3744: WHERE event_header_id is null
3745: UNION ALL
3746: SELECT
3747: BC.business_unit_id business_unit_id,BC.org_id org_id,

Line 3793: ams_event_offers_all_b BA,

3789: SELECT
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 (+)

Line 3803: ams_event_offers_all_b BA,

3799: SELECT
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 (+)