DBA Data[Home] [Help]

APPS.BOM_ALT_DESIGS_POLICY SQL Statements

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

Line: 35

   select 1
   from   all_policies
   where  object_owner = p_policy_owner
   and    object_name  = 'BOM_ALTERNATE_DESIGNATORS'
   and    policy_name  = 'STRUCT_TYPE_ALTS';
Line: 42

   SELECT 1   FROM   All_Policies
   WHERE  Object_Owner = l_Prod_Schema
   AND    Object_Name  = 'BOM_ALTERNATE_DESIGNATORS'
   AND    Policy_Name  = 'STRUCT_TYPE_ALTS';
Line: 48

      SELECT oracle_username
      into p_policy_owner
      from fnd_oracle_userid
      where read_only_flag = 'U';
Line: 72

			  STATEMENT_TYPES => 'SELECT');
Line: 111

	select sys_context('Struct_Type_Ctx', 'appl_id')
	into l_current_appl_id
	from dual;