APPS.MRP_PARAMETER_MRPEPPS SQL Statements

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

Line: 134

    select plan_id, name from bisbv_business_plans;

Line: 137

  SELECT distinct period_type name from gl_periods;

Line: 140

  SELECT distinct compile_designator name from mrp_plans
   	where data_completion_date is not null
	and plan_completion_date is not null;

Line: 145

  SELECT organization_name name, organization_id from org_organization_definitions;

Line: 220

  params(1).Value := htf.formSelectOpen( 'P_ORGANIZATION_ID' );

Line: 223

      params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );

Line: 225

      params(1).Value := params(1).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.organization_id );

Line: 228

  params(1).Value := params(1).Value || htf.formSelectClose;

Line: 235

  params(2).Value := htf.formSelectOpen( 'P_BUSINESS_PLAN' );

Line: 238

      params(2).Value := params(2).Value || htf.formSelectOption( c1.name, 'Y', 'value=' || c1.plan_id );

Line: 240

      params(2).Value := params(2).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.plan_id );

Line: 243

  params(2).Value := params(2).Value || htf.formSelectClose;

Line: 248

  params(3).Value := htf.formSelectOpen('P_PLAN1');

Line: 250

	params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );

Line: 252

  params(3).Value := params(3).Value || htf.formSelectClose;

Line: 253

  params(3).Value := params(3).Value || ' - ' || htf.formSelectOpen( 'P_PLAN2' );

Line: 255

	params(3).Value := params(3).Value || htf.formSelectOption( c1.name, NULL, 'value=' || c1.name );

Line: 257

  params(3).Value := params(3).Value || htf.formSelectClose;

Line: 263

  params(4).Value := htf.formSelectOpen( 'P_PERIOD_TYPE' );

Line: 266

		htf.formSelectOption( c1.name, NULL, 'value=' || c1.name);

Line: 268

  params(4).Value := params(4).Value || htf.formSelectClose;

Line: 293

    select organization_id
    into l_organization_id
    from org_organization_definitions
    where organization_name like P_ORG_NAME;

Line: 308

      select max(organization_id), count(*)
      into l_organization_id, l_count
      from org_organization_definitions
      where organization_name like P_ORG_NAME AND
            organization_id = P_ORG_ID;

Line: 340

    select compile_designator
    into l_plan_name
    from mrp_plans
    where compile_designator like P_PLAN_NAME;

Line: 355

    select max(compile_designator), count(*)
    into l_plan_name, l_count
    from mrp_plans
    where compile_designator like P_PLAN_NAME;