DBA Data[Home] [Help]

APPS.IRC_CMP_SHD SQL Statements

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

Line: 48

    select
       communication_property_id
      ,object_type
      ,object_id
      ,default_comm_status
      ,allow_attachment_flag
      ,auto_notification_flag
      ,allow_add_recipients
      ,default_moderator
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,information_category
      ,information1
      ,information2
      ,information3
      ,information4
      ,information5
      ,information6
      ,information7
      ,information8
      ,information9
      ,information10
      ,object_version_number
    from        irc_comm_properties
    where       communication_property_id = p_communication_property_id;
Line: 144

    select
       communication_property_id
      ,object_type
      ,object_id
      ,default_comm_status
      ,allow_attachment_flag
      ,auto_notification_flag
      ,allow_add_recipients
      ,default_moderator
      ,attribute_category
      ,attribute1
      ,attribute2
      ,attribute3
      ,attribute4
      ,attribute5
      ,attribute6
      ,attribute7
      ,attribute8
      ,attribute9
      ,attribute10
      ,information_category
      ,information1
      ,information2
      ,information3
      ,information4
      ,information5
      ,information6
      ,information7
      ,information8
      ,information9
      ,information10
      ,object_version_number
    from        irc_comm_properties
    where       communication_property_id = p_communication_property_id
    for update nowait;