1789: SELECT
1790: D.business_unit_id business_unit_id,D.org_id org_id,
1791: 'EVEH' object_type_J,'EVEH' object_type, D.event_header_id object_id
1792: FROM
1793: ams_event_headers_all_b D
1794: UNION ALL
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
1842: SELECT
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 (+)
1982: SELECT
1983: D.business_unit_id business_unit_id,D.org_id org_id,
1984: 'EVEH' object_type_J,'EVEH' object_type, D.event_header_id object_id
1985: FROM
1986: ams_event_headers_all_b D
1987: UNION ALL
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
2035: SELECT
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 (+)
3531: SELECT
3532: D.business_unit_id business_unit_id,D.org_id org_id,
3533: 'EVEH' object_type_J,'EVEH' object_type, D.event_header_id object_id
3534: FROM
3535: ams_event_headers_all_b D
3536: UNION ALL
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
3584: SELECT
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 (+)
3726: SELECT
3727: D.business_unit_id business_unit_id,D.org_id org_id,
3728: 'EVEH' object_type_J,'EVEH' object_type, D.event_header_id object_id
3729: FROM
3730: ams_event_headers_all_b D
3731: UNION ALL
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
3779: SELECT
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 (+)