DBA Data[Home] [Help]

APPS.HXC_TBB_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

    select
       time_building_block_id
      ,type
      ,measure
      ,unit_of_measure
      ,start_time
      ,stop_time
      ,parent_building_block_id
      ,parent_building_block_ovn
      ,scope
      ,object_version_number
      ,approval_status
      ,resource_id
      ,resource_type
      ,approval_style_id
      ,date_from
      ,date_to
      ,comment_text
      ,application_set_id
      ,data_set_id
      ,translation_display_key
    from hxc_time_building_blocks
    where time_building_block_id = p_time_building_block_id;
Line: 146

    select
       time_building_block_id
      ,type
      ,measure
      ,unit_of_measure
      ,start_time
      ,stop_time
      ,parent_building_block_id
      ,parent_building_block_ovn
      ,scope
      ,object_version_number
      ,approval_status
      ,resource_id
      ,resource_type
      ,approval_style_id
      ,date_from
      ,date_to
      ,comment_text
      ,application_set_id
      ,data_set_id
      ,translation_display_key
    from hxc_time_building_blocks
    where time_building_block_id = p_time_building_block_id
    and object_version_number    = (select max(object_version_number)
                                    from hxc_time_building_blocks
                                    where time_building_block_id = p_time_building_block_id)
    for	update nowait;