APPS.MRP_END_ASSY SQL Statements

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

Line: 26

          SELECT bom.using_assembly_id using_assembly_item_id,
                         sum(bom.usage_quantity) operation_usage_quantity
          FROM   mrp_bom_components bom,
                 mrp_plan_organizations_v plans
          WHERE  bom.compile_designator = c_compile_desig
          AND    bom.compile_designator = plans.compile_designator
          AND    trunc(bom.effectivity_date) <= trunc(plans.CUTOFF_DATE)
          AND    bom.organization_id = plans.planned_organization
          AND    bom.inventory_item_id = c_component
          AND    bom.alternate_bom_designator is null
          AND    bom.organization_id = c_org_id
          group by using_assembly_id ;

Line: 66

      SELECT NVL(full_lead_time, 0) +
             NVL(postprocessing_lead_time, 0) +
             NVL(preprocessing_lead_time, 0)
      INTO   lead_time
      FROM   mrp_system_items
      WHERE  organization_id = p_org_id
      AND    compile_designator = p_compile_desig
      AND    inventory_item_id = ea.using_assembly_item_id;

Line: 81

	SELECT count(inventory_item_id)
	INTO   check_table
	FROM   mrp_bom_components
	WHERE  organization_id = p_org_id
	AND    compile_designator = p_compile_desig
	AND    alternate_bom_designator is null
	AND    inventory_item_id = ea.using_assembly_item_id
	AND    ROWNUM = 1;

Line: 95

        SELECT COUNT(inventory_item_id)
        INTO   check_table
        FROM   mrp_end_assemblies
        WHERE  organization_id = p_org_id
        AND    compile_designator = p_compile_desig
        AND    inventory_item_id = p_item_to_peg
        AND    using_assembly_id = direct_using_assembly
        AND    end_assembly_id = ea.using_assembly_item_id
        AND    ROWNUM = 1;

Line: 113

          INSERT INTO mrp_end_assemblies (organization_id,
                      compile_designator, inventory_item_id,
                      using_assembly_id, end_assembly_id, usage,
                      set_back_time, end_usage,
                      last_update_date, last_updated_by,
                      creation_date, created_by)
          VALUES      (p_org_id, p_compile_desig, p_item_to_peg,
                       direct_using_assembly, ea.using_assembly_item_id,
                       direct_usage, cum_set_back_time, cum_usage,
                       SYSDATE, var_user_id, SYSDATE, var_user_id);

Line: 130

          SELECT set_back_time
          INTO   old_set_back_time
          FROM   mrp_end_assemblies
          WHERE  organization_id = p_org_id
          AND    compile_designator = p_compile_desig
          AND    inventory_item_id = p_item_to_peg
          AND    using_assembly_id = direct_using_assembly
          AND    end_assembly_id = ea.using_assembly_item_id;

Line: 141

            SELECT end_usage
            INTO   old_usage
            FROM   mrp_end_assemblies
            WHERE  organization_id = p_org_id
            AND    compile_designator = p_compile_desig
            AND    inventory_item_id = p_item_to_peg
            AND    using_assembly_id = direct_using_assembly
            AND    end_assembly_id = ea.using_assembly_item_id;

Line: 152

            UPDATE mrp_end_assemblies
            SET    end_usage = cum_usage,
				   set_back_time = cum_set_back_time,
				   last_update_date = SYSDATE,
				   last_updated_by = var_user_id
            WHERE  organization_id = p_org_id
            AND    compile_designator = p_compile_desig
            AND    inventory_item_id = p_item_to_peg
            AND    using_assembly_id = direct_using_assembly
            AND    end_assembly_id = ea.using_assembly_item_id;

Line: 183

	  SELECT COUNT(*)
	  INTO count_rows
	  FROM mrp_end_assemblies
	  WHERE organization_id = p_org_id
	  AND compile_designator = p_compile_desig
	  AND inventory_item_id = p_item_to_peg
	  AND ROWNUM = 1;