[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT event_offer_name
FROM ams_event_offers_vl
WHERE parent_event_offer_id = p_agenda_id;
SELECT
DLT.deliverable_name ,
DLV.custom_setup_id,
CAT.category_id,
OBJ.master_object_id,
OBJ.object_association_id,
OBJ.using_object_id,
CAT.category_name ,
OBJ.object_version_number,
OBJ.quantity_needed,
OBJ.fulfill_on_type_code,
OBJ.master_object_type,
OBJ.quantity_needed_by_date,
OBJ.USING_OBJECT_TYPE,
OBJ.primary_flag,
OBJ.USAGE_TYPE
FROM
AMS_OBJECT_ASSOCIATIONS OBJ,
AMS_DELIVERABLES_ALL_B DLV,
AMS_DELIVERABLES_ALL_TL DLT,
AMS_CATEGORIES_TL CAT
WHERE
OBJ.master_object_id = p_src_act_id AND
OBJ.USING_OBJECT_TYPE = 'DELV' AND
OBJ.USING_OBJECT_ID = DLV.DELIVERABLE_ID AND
OBJ.USING_OBJECT_ID = DLT.DELIVERABLE_ID AND
DLT.LANGUAGE = USERENV('LANG') AND
DLV.CATEGORY_TYPE_ID = CAT.CATEGORY_ID AND
CAT.LANGUAGE = USERENV('LANG') AND
OBJ.master_object_type =p_src_act_type;
select
EVENT_OFFER_ID
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,OBJECT_VERSION_NUMBER
,APPLICATION_ID
,PRIVATE_FLAG
,ACTIVE_FLAG
,SOURCE_CODE
,EVENT_LEVEL
,USER_STATUS_ID
,LAST_STATUS_DATE
,SYSTEM_STATUS_CODE
,EVENT_TYPE_CODE
,EVENT_DELIVERY_METHOD_ID
,''
,EVENT_REQUIRED_FLAG
,EVENT_LANGUAGE_CODE
,EVENT_LOCATION_ID
,''
,''
,''
,''
,OVERFLOW_FLAG
,PARTNER_FLAG
,EVENT_STANDALONE_FLAG
,REG_FROZEN_FLAG
,REG_REQUIRED_FLAG
,REG_CHARGE_FLAG
,REG_INVITED_ONLY_FLAG
,REG_WAITLIST_ALLOWED_FLAG
,REG_OVERBOOK_ALLOWED_FLAG
,PARENT_EVENT_OFFER_ID
,EVENT_DURATION
,EVENT_DURATION_UOM_CODE
, EVENT_START_DATE
,EVENT_START_DATE_TIME
,EVENT_END_DATE
,EVENT_END_DATE_TIME
,REG_START_DATE
,REG_START_TIME
,REG_END_DATE
,REG_END_TIME
,REG_MAXIMUM_CAPACITY
,REG_OVERBOOK_PCT
,REG_EFFECTIVE_CAPACITY
,REG_WAITLIST_PCT
,REG_MINIMUM_CAPACITY
,REG_MINIMUM_REQ_BY_DATE
,INVENTORY_ITEM_ID
,''
,ORGANIZATION_ID
,PRICELIST_header_ID
,PRICELIST_LINE_ID
,ORG_ID
,WAITLIST_ACTION_TYPE_CODE
,STREAM_TYPE_CODE
,OWNER_USER_ID
,EVENT_FULL_FLAG
,FORECASTED_REVENUE
,ACTUAL_REVENUE
,FORECASTED_COST
,ACTUAL_COST
,FUND_SOURCE_TYPE_CODE
,FUND_SOURCE_ID
,CERT_CREDIT_TYPE_CODE
,CERTIFICATION_CREDITS
,COORDINATOR_ID
,PRIORITY_TYPE_CODE
,CANCELLATION_REASON_CODE
,AUTO_REGISTER_FLAG
,EMAIL
,PHONE
,FUND_AMOUNT_TC
,FUND_AMOUNT_FC
,CURRENCY_CODE_TC
,CURRENCY_CODE_FC
,URL
,TIMEZONE_ID
,EVENT_VENUE_ID
,''
,''
,INBOUND_SCRIPT_NAME
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,EVENT_OFFER_NAME
,EVENT_MKTG_MESSAGE
,DESCRIPTION
,SETUP_TYPE_ID
,COUNTRY_CODE
,BUSINESS_UNIT_ID
,EVENT_CALENDAR
,START_PERIOD_NAME
,END_PERIOD_NAME
,GLOBAL_FLAG
,TASK_ID
--PROGRAM_ID
,PARENT_TYPE
,PARENT_ID
,CREATE_ATTENDANT_LEAD_FLAG
,CREATE_REGISTRANT_LEAD_FLAG
,EVENT_OBJECT_TYPE
,REG_TIMEZONE_ID
,event_password
,record_event_flag
,allow_register_in_middle_flag
,publish_attendees_flag
,direct_join_flag
,event_notification_method
,actual_start_time
,actual_end_time
,SERVER_ID
,owner_fnd_user_id
,meeting_dial_in_info
,meeting_email_subject
,meeting_schedule_type
,meeting_status
,meeting_misc_info
,publish_flag
,meeting_encryption_key_code
,number_of_attendees
,EVENT_PURPOSE_CODE
FROM ams_event_offers_vl
WHERE parent_event_offer_id = p_src_act_id
AND event_level='SUB';
SELECT coordinator_id, parent_type,parent_id,agenda_name,description,agenda_type, b.agenda_id --* perf fix
FROM ams_agendas_b b, ams_agendas_tl tl--ams_agendas_v SQL Rep perf fix
WHERE b.agenda_id = tl.agenda_id
AND tl.language = USERENV('LANG')
AND parent_id = p_src_act_id
AND agenda_type = 'TRACK'
AND active_flag = 'Y'; --bug fix 3097466 by anchaudh on 14-Aug-2003.
SELECT coordinator_id,parent_type,parent_id,agenda_name,description,agenda_type,b.agenda_id,
start_date_time, end_date_time
FROM ams_agendas_b b, ams_agendas_tl tl --ams_agendas_v SQL Rep Perf Fix
WHERE b.agenda_id = tl.agenda_id
AND tl.language = USERENV('LANG')
AND parent_id = p_track_id
AND agenda_type = 'SESSION'
AND active_flag = 'Y'; --bug fix 3097466 by anchaudh on 14-Aug-2003.
SELECT event_start_date, event_end_date
FROM ams_event_offers_all_b
WHERE event_offer_id = p_event_offer_id;
SELECT delivery_media_type_code
FROM Ams_act_delivery_methods
WHERE act_delivery_method_used_by_id = event_offer_id;
SELECT event_start_date, event_end_date
FROM ams_event_offers_vl
WHERE event_offer_id = event_offer_id_in;
select count(*) into l_rec_cnt
FROM ams_act_categories
where ACT_CATEGORY_USED_BY_ID = l_event_offer_id;
SELECT ARC_ACT_CATEGORY_USED_BY
INTO l_ARC_ACT_CATEGORY_USED_BY
FROM ams_act_categories
where ACT_CATEGORY_USED_BY_ID = l_event_offer_id;